View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John JBM John JBM is offline
external usenet poster
 
Posts: 3
Default 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