ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro won't run in Excel 2000 when workbook opened via URL (https://www.excelbanter.com/excel-programming/357510-macro-wont-run-excel-2000-when-workbook-opened-via-url.html)

[email protected]

Macro won't run in Excel 2000 when workbook opened via URL
 
I have an issue with a workbook for Office 2000. The workbook has
macros we would like the user to be able to run. We can use this as a
workaround http://support.microsoft.com/default.aspx/kb/260519 but
given that you can link directly to the book in Office XP and 2003 I
was wondering if there was a way to do this in Office 2000 as well. I'm
not very hopeful because when you open the workbook and search for
macros in the workbook via Tools-Macros there are none listed. Also if
you look at the workbook's name in VBA the value is something like
"book1.xls?param=value" with the URL parameters tacked on the end
instead of regular old "book1.xls"

Does anybody know a better workaround than forcing the open dialog to
come up?

Thanks for any help you can offer.

Mike



All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com