LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cancel the printer setup dialog Peter Excel Programming 3 March 29th 07 01:16 AM
Excel/VBA/Internet Explorer Alex[_30_] Excel Programming 1 November 22nd 05 05:09 PM
Printer Setup Dialog Box Michael Smith Excel Programming 2 September 19th 05 03:43 PM
Internet Explorer & Excel David Excel Programming 0 February 4th 05 08:51 PM
Internet Explorer Automation with Excel VBA Joćo Rodrigues Excel Programming 0 July 22nd 04 06:55 PM


All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"