printing question

excelmacro · Apr 30th, 2002, 11:59 AM

I have a macro to print certain ranges on a sheet, and it automatically prints the sheets when i run the macro. I now want to change the macro to enable me to select the printer that the macro uses. Essentially what i want is for the print dialogue box to come up when i run the macro. how do i do this?

jamienwood · Apr 30th, 2002, 01:12 PM

I have also had this trouble, and the only way I got my macro to print to the printer I wanted was to set the printer as the default printer, I know this isn't the answer, so if anyone else knows the answer could you email it to me jamienwood@hotmail.com

Jack in the UK · Apr 30th, 2002, 03:27 PM

strangle this is correct..

also dual bis or manual feed is a mess in VBA

eh! something excel cant to.. manual feed!

Ivan F Moala · May 1st, 2002, 03:28 AM

Quote:

On 2002-04-30 10:59, excelmacro wrote:
I have a macro to print certain ranges on a sheet, and it automatically prints the sheets when i run the macro. I now want to change the macro to enable me to select the printer that the macro uses. Essentially what i want is for the print dialogue box to come up when i run the macro. how do i do this?



Sub prtdlg()

Application.Dialogs(xlDialogPrinterSetup).Show

Application.Dialogs(xlDialogPrint).Show

End Sub

excelmacro · May 1st, 2002, 08:14 AM

Thanks

Apr 30th, 2002, 03:27 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	strangle this is correct.. also dual bis or manual feed is a mess in VBA eh! something excel cant to.. manual feed! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 11:59 AM	#1
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	I have a macro to print certain ranges on a sheet, and it automatically prints the sheets when i run the macro. I now want to change the macro to enable me to select the printer that the macro uses. Essentially what i want is for the print dialogue box to come up when i run the macro. how do i do this?

Apr 30th, 2002, 01:12 PM	#2
jamienwood Board Regular Join Date: Apr 2002 Location: Manchester UK Posts: 133	I have also had this trouble, and the only way I got my macro to print to the printer I wanted was to set the printer as the default printer, I know this isn't the answer, so if anyone else knows the answer could you email it to me jamienwood@hotmail.com

May 1st, 2002, 08:14 AM	#5
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	Thanks