Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following Macro behaves differently when manually started from the menu,
or when assigned to a Control button. It does not work correctly when started from the button. It works OK from the menu ( Tools;Macro;Macro <macro name Run) The macro is supposed to create a adobe pdf file from a selected print range. Using Excel 2000 , Adobe 6.0 Prof. I have searched the trouble shooting section without sucess. Can somebody help? Sub Macro1() Dim FILENAM Sheets("Schedules").Select ActiveSheet.PageSetup.PrintArea = "$A$230:$L$274" Application.ActivePrinter = "Adobe PDF on Ne02:" FILENAM = "C:\Test\mac1.pdf" Application.SendKeys FILENAM, True SendKeys "{Enter}" SendKeys "Y" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Adobe PDF on Ne02:" Application.Wait (Now + TimeValue("0:00:01")) Sheets("Notes").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Launch of Macro | Excel Discussion (Misc queries) | |||
Is it possible to make a Button on a tool bar to launch an Add-in | Excel Discussion (Misc queries) | |||
button to launch my userform | Excel Programming | |||
Can you use an IF statement to launch a macro? | Excel Programming | |||
Can I launch the Calendar Control from a Comand Button | Excel Programming |