Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Macro1 to call Macro2 stored on Network drive
I would like to have a macro triggered by by a toolbar button that would call another macro that is stored out on a Network drive. Is this possible using Excel VB script? If so, how? Appreciate any help you are willing to offer. Thanks. MP -- LESman ------------------------------------------------------------------------ LESman's Profile: http://www.excelforum.com/member.php...o&userid=24150 View this thread: http://www.excelforum.com/showthread...hreadid=377749 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Macro1 to call Macro2 stored on Network drive
One approach to try is to use My Computer to assign a network drive i.e. Z:
Then you would include code like: Windows("Z:\library.xls").Activate Application.Run "Z:\personal.xls!comac" This would access macro comac in spreadsheet library.xls on the Z €“drive. Network considerations might require different code. -- Gary's Student "LESman" wrote: I would like to have a macro triggered by by a toolbar button that would call another macro that is stored out on a Network drive. Is this possible using Excel VB script? If so, how? Appreciate any help you are willing to offer. Thanks. MP -- LESman ------------------------------------------------------------------------ LESman's Profile: http://www.excelforum.com/member.php...o&userid=24150 View this thread: http://www.excelforum.com/showthread...hreadid=377749 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Macro1 to call Macro2 stored on Network drive
Can't you just assign the macro to the toolbar when you build the toolbar.
Remember to use the UNC naming convention. LESman wrote: I would like to have a macro triggered by by a toolbar button that would call another macro that is stored out on a Network drive. Is this possible using Excel VB script? If so, how? Appreciate any help you are willing to offer. Thanks. MP -- LESman ------------------------------------------------------------------------ LESman's Profile: http://www.excelforum.com/member.php...o&userid=24150 View this thread: http://www.excelforum.com/showthread...hreadid=377749 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
map network drive | Excel Discussion (Misc queries) | |||
Calling a common XLA Library file, stored on a network drive :) | Excel Discussion (Misc queries) | |||
Calling a common XLA Library file, stored on a network drive :) | Setting up and Configuration of Excel | |||
Link workbooks-C drive to network drive | Excel Worksheet Functions | |||
Userform Local Drive & Network drive question | Excel Programming |