Can't start macro via button click

  • Thread starter Thread starter dan
  • Start date Start date
D

dan

Hi guys,

I created an excel file with a macro and I used to start this macro
using a button - it worked fine. Now I need to access this excel file
with a webserver. If I access my excel file with IE, it opens my Excel
and loads the excel file - exactly what I want, but if I click at my
button, Excel can't find the macro. The reason for this is apperently
the name of my workbook: It is no longer myfilename.xls, but
http://myserver.blahblub.com/... . It seems, that this workbookname is
reason why I can't start my macro.

Can someone tell my, how to connect a button with a macro, which will
start, even if the name of the workbook is a kind of URL?

TIA,
Daniel
 
What about saving the macro in the Thisworkbook module? A shot in the dark
but hey - who knows!

Mark (InWales)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top