Printer issue in Excel VBA

[haissk]

Hi
I have a problem with excel VBA, if a sytem does not have any printers configured, then my application should add a new printer "Microsoft office image writer" and set that as my application's active printer. Please help me with the lines of code

Thankyou
Sathish

 

[SMB Cooper]

Please watch this podcast from MrExcel himself regarding what printer driver to install with Excel.

http://www.mrexcel.com/Excel_Faster_Macros_training.html

After installing the printer driver, just do a "macro recording" to generate the code you want.