|
Executing of excel Macros.
Hello All, Is it possible to store a excel macro in a Server or in an application and then is it possible to execute that in the client machines? basically if i change the code in the excel macro, instead of deploying to all the clients in can as well updte the server side and then run it from there., Best Regards Karthik -- KarthikK ------------------------------------------------------------------------ KarthikK's Profile: http://www.excelforum.com/member.php...o&userid=24663 View this thread: http://www.excelforum.com/showthread...hreadid=382407 |
You could create an add-in and store that in a network server, and then load
the add-in in Excel. It will then pick up any changes on each start of Excel. -- HTH Bob Phillips "KarthikK" wrote in message ... Hello All, Is it possible to store a excel macro in a Server or in an application and then is it possible to execute that in the client machines? basically if i change the code in the excel macro, instead of deploying to all the clients in can as well updte the server side and then run it from there., Best Regards Karthik -- KarthikK ------------------------------------------------------------------------ KarthikK's Profile: http://www.excelforum.com/member.php...o&userid=24663 View this thread: http://www.excelforum.com/showthread...hreadid=382407 |
Hello Bob. Thank you very much. But could you please help me out on that. How can i create an Add-In and how can i install it?? best regards Karthik -- KarthikK ------------------------------------------------------------------------ KarthikK's Profile: http://www.excelforum.com/member.php...o&userid=24663 View this thread: http://www.excelforum.com/showthread...hreadid=382407 |
Creating an addin is very simple.
Open a new workbook and setup your code in that new workbook (you need to make sure that you code is flexible enough to work in a different workbook than the hosting workbook, but that is probably another story). The save the workbook as an add-in on the server. Addins are a workbook type, you should find it at the bottom of the list of file types. Beware, as soon as you pick addins, Excel will try and direct the save directory, so be doubly sure it is where you want. Once saved, close it down, and the install it by going to menu Tools?Addins and then click the browse button and go find the file. You will then see an entry in the list of addins and it will be checked. Every time Excel starts in future that add-in will be loaded. So you can change it, and next time, the changes will be picked up. You install on other desktops in the same way. -- HTH Bob Phillips "KarthikK" wrote in message ... Hello Bob. Thank you very much. But could you please help me out on that. How can i create an Add-In and how can i install it?? best regards Karthik -- KarthikK ------------------------------------------------------------------------ KarthikK's Profile: http://www.excelforum.com/member.php...o&userid=24663 View this thread: http://www.excelforum.com/showthread...hreadid=382407 |
Thank you very much Bob! -- KarthikK ------------------------------------------------------------------------ KarthikK's Profile: http://www.excelforum.com/member.php...o&userid=24663 View this thread: http://www.excelforum.com/showthread...hreadid=382407 |
| All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com