XL2000: Can't Record "Open Published Web Page in Browser" Option

ID: Q228894

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you select the Open published web page in browser check box in the Publish dialog box while recording a macro, Excel does not add the code that the macro needs to repeat this action. Therefore, when you run the macro, it does not open the page in the browser.

CAUSE

The Microsoft Excel object model does not currently support automatically opening a published page in a Web browser.

RESOLUTION

After recording the macro, modify the macro by adding the following code:


ActiveWorkbook.WebPagePreview

Additional query words: XL2000

Keywords : kbmacro kbdtacode xlvbahowto
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb