PDA

View Full Version : Solved: Run macro in other sheets.



zennon
08-30-2007, 07:53 AM
Hi,

Is it possible to call/run macros in other workbooks on a server from another workbook on a PC?

What I'm trying to do......

I have a worksheet that has profit/lost details for customers and the salesperson that services these customers on a server. This worksheet has a macro that filters by the salesperson ID. On the sales persons PC I want them to have a sheet that that calls the datasheet on the server and filters by their name and then copies the filtered date onto their PC so that they can create pivot tables.

I have done this with the data being in the same workbook on the PC but the boss wan't to run the data and wants a master sheet on the server.

Can this be done? I have not got any examples at the moment as I need to know weather it can be done before I start.

mvidas
08-30-2007, 08:11 AM
Hi,

Short answer: Yes

Application.Run "'\\Server\Path\Workbook Name.xls'!MacroName"

However, it will open that external workbook. Why not put your macros into an addin or something?