ExcelBanter - Need Macro1 to call Macro2 stored on Network drive

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need Macro1 to call Macro2 stored on Network drive (https://www.excelbanter.com/excel-programming/331352-need-macro1-call-macro2-stored-network-drive.html)

LESman

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

Gary's Student

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

Dave Peterson[_5_]

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

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