Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't start macro via button click
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't start macro via button click
What about saving the macro in the Thisworkbook module? A shot in the dark
but hey - who knows! Mark (InWales) "dan" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recording won't record mouse click of add-in app button | Excel Discussion (Misc queries) | |||
Button will not start macro | Excel Worksheet Functions | |||
Write a macro that enables User to simply click a button and . . . | Excel Discussion (Misc queries) | |||
Start/Stop Macro Button | Excel Discussion (Misc queries) | |||
How do I set a macro to run when I click a Command Button in Exce. | Excel Programming |