View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Mike.Surel@geac.com is offline
external usenet poster
 
Posts: 1
Default 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