MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How Do I Deliver this VBA Customized Workbook

Posted by Jason Ramirez on December 07, 2001 9:32 AM

I did some development for a client using VBA in Excel 97. I used userforms, ADO, Datagrids, and several databound controls on the forms. I want to be able to deliver this to any Windows (95, 98, ME, NT, 2000)machine. I tried to just copy the VBA laden spreadsheet to a directory on the source machine but it needed some DLLs and OCXs (I assumed) that weren't installed on the machine.

How do I create a package that will install on any Windows machine that will make sure to correctly install any library dependencies of my VBA customized Excel 97 spreadsheet?

Any help or redirection would be greatly appreciated.


Posted by Joe Was on December 07, 2001 9:45 AM

Access has a packager utility but sadly Excel does not. The only way for a user to use your application is for their machine to have Excel installed. JSW

Posted by Jason Ramirez on December 07, 2001 11:58 AM

Lets assume that they have Excel 97. There are still DLLs that i have on my machine where i did the development that the client's machine will not have.

Will installers such as WISE Installation System work?



Posted by Joe Was on December 07, 2001 3:33 PM

I have also posted for a solution and have contacted Microsoft, who did say that the Access packeger will work with Excel. When I tried it the VB that Excel uses is different than Access VB and Macros failed. All the other packagers I have tried also fail to deal with Macro VB code. What they do do is put a snap-shot of the application on the virgin PC, which look like your application, sheet formulas may work but all the coding is locked out. Microsoft did this so people will buy licenses in order to use your application. If you find a way around this please let me know, as I have a lot of applications which could do well as stand-alones'. I have requested on MS's developer site an addition to the next version of Excel, which will package applications, who knows. Its a bite! JSW