Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I am using a macro to create a report and the last step is to print a particular worksheet using a PDF maker. I have figured out how to specify the printer as being the PDF maker, but I also want to be able to automatically enter the file name and path, which I will build within the macro depending upon some user inputs. I've built the text strings as I need, I just need to be able to "feed" them to the PDF maker rather than have the dialog box come up and ask the user for that information. Any help? Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
open file (as variable) from macro | Excel Discussion (Misc queries) | |||
Opening a file with a Macro | Excel Discussion (Misc queries) | |||
How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) |