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.