Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique filenames
Here's a tricky one (for me anyway)
I have a macro that reads a line of data from a sheet and presents it in a second sheet as a report. This report also contains some fixed text and simple graphics. The macro then prints the 'report' and goes back to the first sheet for the next line of data ....... and so on. There are hundreds of rows in the sheet and therefore hundreds of printed reports. OK so far? What I would like to do is to save each of the 'reports' using a unique reference taken from one of the cells in the row that has been copied onto the report. Any ideas? As an addition, it would be preferable to save the report in a PDF format. Thanks in anticipation. Under Pressure |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generation of filenames | Excel Programming | |||
what do 'blue filenames' mean? | Excel Discussion (Misc queries) | |||
getting filenames | Excel Programming | |||
unique filenames in macros | Excel Programming | |||
Getting filenames via VBA | Excel Programming |