Microsoft KB Archive/228894

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

Article ID: 228894

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q228894



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 kbprb kbdtacode KB228894

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.