View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Kevin M[_2_] Kevin M[_2_] is offline
external usenet poster
 
Posts: 10
Default Macros Referenced in Custom Menu Fail after Save

On Apr 18, 2:43 pm, Dave Peterson wrote:
I have no idea how this would work with those HTTP file names.

But if there are spaces, couldn't you try replacing them with %20's. (You'll
have to test it, though.)



Kevin M wrote:

<<snipped

Ugh.


I tried exactly what you said, Dave, and I'm still getting these pesky
errors. It really makes no sense to me how Excel can say "http://
xxx.yyy.com/foo/bar.xls!SelectForm" or whatever isn't working, when
the path and everything is perfect. Does the fact that there are
spaces (%20) in the name of the hosted file screw things up?


Many thanks for all your help.


--

Dave Peterson


The spaces are automatically replaced with the appropriate characters.