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.
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.