[QUOTE=Armando Penblade;3965193]Are you single-clicking the cell, hitting Ctrl-C/Copy, then going to filename entry box, and Pasting the cell’s contents in as a name?QUOTE]
Yes this is exactly what we are doing. The issue being we are actually highlighting 4 cells at a time horizontally and pasting them in to the file name entry box and say 1 in 5 times it errors out.
We want to automate the processing by exporting as a csv (ms dos file) and using a bat file to auto rename but if continues to error it will then fail.
Also when pasting out it is leaving big gaps, for example.
The pasted text from the cells is
This(Row A) File(Row b) is(Row c) Rubbish(Row D) and pasting it to the pdf it looks like this
This(BIG SPACE)File(BIG SPACE)is(BIG SPACE)Rubbish. The gap is big but it is only 1 space in real size, eg using backspace once removes the big gap. Maybe this causes the issue, but we cannot make it fail every time only say 1 in 10 times the other 9 work fine even if they do have the big gaps which we also have to manually remove.
For some quick context, I do not generally manage the IT side of a project like this but run the whole end to end process, but have been employed to take 3 million on documents, to scan and upload them in to share point under specific guidelines, searchable pdf’s and specific naming conventions based on 4 entries on a spread sheet.
Once I started and looked at their process it was going to take around 4 years to do. I have made major changes to the Prep and scan stages and we are now down to 18 months. Ideally I would like to get us down to 1 year. By out putting the scanned images against their relevant spread sheet line I hope to automate the final process from a manual one to a quicker simple rename bat file.
I just need to get the spread sheet clean. The current dept will be finished in 3 weeks and the next dept is the biggest. the companies IT depart is 1 guy who is pretty good but also run off his feet and I would like to be up running in a few weeks so all the given advice is really appreciated even if it’s just enough for me to understand the issue.
One point I may need to look at is how the spread sheet is generated, I think it’s pulled from the back end of the software they use so it could be they need to change how the sheet is generated.