Show Printer Setup Dialog in Excel from Internet Explorer
I'm trying to make the Printer Setup Dialog available to users. The Excel
file is accessed and opened from a web page. The following code works fine
if the file is opened in Excel, but if the file is opened from IE I get a
Run-time error '1004' Unable to get the Show property of the Dialog class.
Any help would be appreciated.
bdlgAnswer = myWorkbook.Application.Dialogs(xlDialogPrinterSetu p).Show
--
John
|