deyken
01-19-2012, 11:43 PM
Hi Guys!
I wrote a "generic" macro that connects to a database and uploads an Excel document's content into a SQL Server 2008 database. I need this macro to be globally available, so that I do not have to put the macro code into every single one of these excel workbooks. I also need to do this on our company's netweork so that other users have the same access to this macro.
I tried connecting this macro to a button, wehich I placed onto the Quick Access Toolbar and it seemed to work for a bit. Now, however, it tells me that this macro is not available to my Excel application.
My question is: Can I place the macro code somewhere in a DLL or other globally available place where any Excel application can access it?
PS: I also tried saving it as an Excel Add-In and then importing it into several users' Excel Applications, but this do not seem to work...
Any help would be appreciated. Thank you very much in advance!!
I wrote a "generic" macro that connects to a database and uploads an Excel document's content into a SQL Server 2008 database. I need this macro to be globally available, so that I do not have to put the macro code into every single one of these excel workbooks. I also need to do this on our company's netweork so that other users have the same access to this macro.
I tried connecting this macro to a button, wehich I placed onto the Quick Access Toolbar and it seemed to work for a bit. Now, however, it tells me that this macro is not available to my Excel application.
My question is: Can I place the macro code somewhere in a DLL or other globally available place where any Excel application can access it?
PS: I also tried saving it as an Excel Add-In and then importing it into several users' Excel Applications, but this do not seem to work...
Any help would be appreciated. Thank you very much in advance!!