pulsecoding
New Member
- Joined
- May 26, 2011
- Messages
- 31
Hi,
I am generating a pdf file through vba excel. I am now able to generate pdf through code.
<!-- BEGIN TEMPLATE: bbcode_code -->
but after this line gets executed, pdf creator throws a dialog box asking to modify the name of file and location and then press button "save" or "cancel" to save the pdf file.
I need to have code which will modify the name and location and then it will press "save" button on the dialog box.
Thanks for reading this post.
Thanks
Abhijeet
I am generating a pdf file through vba excel. I am now able to generate pdf through code.
<!-- BEGIN TEMPLATE: bbcode_code -->
Code:
Application.ActivePrinter = "PDFCreator on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="PDFCreator on Ne00:", Collate:=True
but after this line gets executed, pdf creator throws a dialog box asking to modify the name of file and location and then press button "save" or "cancel" to save the pdf file.
I need to have code which will modify the name and location and then it will press "save" button on the dialog box.
Thanks for reading this post.
Thanks
Abhijeet