LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Problem running macros in Excel filenames containing special characters like []

My workbook embeds my own toolbar linked with some VB code. When I
download this workbook from the internet, IE asks whether to Open, Save
or Cancel the file. When I choose Open, IE creates a temporary file
adding "[1]" in the file name. On opening, Excel asks me whether I want
to activate macros. I choose yes. Now when I press one of my toolbar
buttons, excel asks me again to enable the macros. Choosing yes again
puts the file in a deadlock and the VB code behind the toolbar button
failed to execute. As soon as I save the file without using "[]" in the
filename, the macros work fine.

Does anybody have an idea how to work around this problem?

Thanks in advance.

Reto

 
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
using wildcard characters for filenames in externally linked files Harold Good Excel Discussion (Misc queries) 0 June 27th 06 03:40 AM
Putting special characters into Excel... Alex Excel Discussion (Misc queries) 2 August 25th 05 07:53 PM
Problem with running Macros Mark Alex Excel Discussion (Misc queries) 1 May 17th 05 02:28 PM
VBA PROBLEM - Running Macros! MrMerton[_2_] Excel Programming 3 July 6th 04 02:56 PM
Problem running macros in Office/Excel 97 Rich J Excel Programming 1 January 29th 04 06:16 PM


All times are GMT +1. The time now is 05:15 AM.

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"