Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving to PDF Writer
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 Maycotte ------------------------------------------------------------------------ I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604 View this thread: http://www.excelforum.com/showthread...hreadid=562429 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving to PDF Writer
I'd appreciate any help and ideas -- I Maycott ----------------------------------------------------------------------- I Maycotte's Profile: http://www.excelforum.com/member.php...fo&userid=3560 View this thread: http://www.excelforum.com/showthread.php?threadid=56242 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CD Writer | New Users to Excel | |||
PDF writer | Excel Discussion (Misc queries) | |||
PDF Writer | Excel Programming | |||
PDF Writer Error | Excel Programming | |||
Cheque Writer in Excel | Excel Programming |