Odd printing query - filenames

sim667 · Nov 11, 2011

I need to batch process some XLS documents and print them out..... No each document is for a specific person, whose name is the filename, however the name is not actually in the document anywhere.

There's about 70 of them, so the last thing I want to do is to open each on, add a name and then resave.

Does anyone know of how I can get the filename to printout on the bottom of each print? That would be a massive timesaver for me.

r0k · Nov 11, 2011

sim667 said: ↑

I need to batch process some XLS documents and print them out..... No each document is for a specific person, whose name is the filename, however the name is not actually in the document anywhere.

There's about 70 of them, so the last thing I want to do is to open each on, add a name and then resave.

Does anyone know of how I can get the filename to printout on the bottom of each print? That would be a massive timesaver for me.
Click to expand...

You haven't mentioned which software you are using. Is it LibreOffice? Office 2004? iWork? There are functions available in most spreadsheet programs to take all or part of the document's name and or path and put it into a cell. You can look up the formulas in each app's help system. In Excel and Libre Office, it's called "Cell". I'm not sure what it's called in Numbers.

So you will end up editing all 70 files but you can simply paste in the formula each time and it should give its own filename when you print the spreadsheet after pasting in the formula. It's easier to pick rows to put at the top and left of a printout than the bottom or right, so paste the formula in at the top and it should show up on every page (if you have print area set up that way).

sim667 · Nov 11, 2011

Or another way round is to make an excel automator script to add the file name as a header and save it again. I'm just rubbish with automator

sim667 · Nov 11, 2011

r0k said: ↑

You haven't mentioned which software you are using. Is it LibreOffice? Office 2004? iWork? There are functions available in most spreadsheet programs to take all or part of the document's name and or path and put it into a cell. You can look up the formulas in each app's help system. In Excel and Libre Office, it's called "Cell". I'm not sure what it's called in Numbers.

So you will end up editing all 70 files but you can simply paste in the formula each time and it should give its own filename when you print the spreadsheet after pasting in the formula. It's easier to pick rows to put at the top and left of a printout than the bottom or right, so paste the formula in at the top and it should show up on every page (if you have print area set up that way).
Click to expand...

Oh sorry it's office, the latest one

Odd printing query - filenames

sim667 macrumors 65816

r0k macrumors 68040

sim667 thread starter macrumors 65816

sim667 thread starter macrumors 65816

Share This Page

Touch Arcade

YouTube

Useful Searches

Odd printing query - filenames

sim667 macrumors 65816

r0k macrumors 68040

sim667 thread starter macrumors 65816

sim667 thread starter macrumors 65816

Share This Page