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

Reply
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
How to stop Excel remembering/loading macro from previously opened Workbook Norman Yuan Excel Discussion (Misc queries) 4 June 17th 06 04:13 PM
How to run a macro as soon a a workbook (.xls) is opened? Sangamesh Acharya Excel Worksheet Functions 1 December 15th 05 11:15 PM
Launching Excel macro for every workbook opened. AbsoluteZero Excel Programming 1 December 15th 05 06:21 PM
Add-in to run macro when ANY workbook is opened? jruppert Excel Programming 2 November 5th 04 02:28 PM
Run a macro when a workbook is opened Mervyn Thomas[_3_] Excel Programming 2 July 25th 03 11:40 AM


All times are GMT +1. The time now is 10:02 PM.

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"