I
I Maycotte
Hello everyone,
I recorded a macro that runs a For loop through a range in Sheet1.
Each cell is individually copied and pasted onto Sheet2 (the values in
sheet 2 are dependent on the cell copied/pasted onto it). At each cell
in the for loop, I send the file to a PDF Writer. This is where I run
into trouble. I have the right destination of the pdf writer, but
everytime it wants to save it prompts me for a file name to save as.
Since I am running through hundreds of cells, I want to incorporate
code that automatically saves without the user having to sit and type
hundreds of filenames. In my attempt to fix this, I recorded yet
another macro going through the motions of file, print to pdf, save as,
etc... but it only records the send to pdf writer part. Does anybody
have any ideas how I could incorporate the "save as" part into my code?
Thanks in advance.
-- Isaac
I recorded a macro that runs a For loop through a range in Sheet1.
Each cell is individually copied and pasted onto Sheet2 (the values in
sheet 2 are dependent on the cell copied/pasted onto it). At each cell
in the for loop, I send the file to a PDF Writer. This is where I run
into trouble. I have the right destination of the pdf writer, but
everytime it wants to save it prompts me for a file name to save as.
Since I am running through hundreds of cells, I want to incorporate
code that automatically saves without the user having to sit and type
hundreds of filenames. In my attempt to fix this, I recorded yet
another macro going through the motions of file, print to pdf, save as,
etc... but it only records the send to pdf writer part. Does anybody
have any ideas how I could incorporate the "save as" part into my code?
Thanks in advance.
-- Isaac