create a vba .exe file erp 18.11.2005 01:51:42 I have just completed a very tedious program that had me learining vb, vba, and exel vba for 2000 on my XP os all at the same time. The system i created the program on of course allows it to work just fine. I brought it to work on me 2000 os office 97 excel and the thing will not compile- says ther is files missing- I have ID'ed them on me home system but don't know how to get the program to work on the 2000 os system- I can't seem to find the information on how to create an exe file for VBA.

Re: create a vba .exe file Cindy M -WordMVP- <C.Meister-C[ at ]hispeed.ch> 25.11.2005 10:03:54 Hi =?Utf-8?B?ZXJw?=, [Quoted Text] > I have just completed a very tedious program that had me learining vb, vba, > and exel vba for 2000 on my XP os all at the same time. The system i > created the program on of course allows it to work just fine. I brought it > to work on me 2000 os office 97 excel and the thing will not compile- says > ther is files missing- I have ID'ed them on me home system but don't know how > to get the program to work on the 2000 os system- I can't seem to find the > information on how to create an exe file for VBA. > You don't supply us with enough information. Is this code you've written in VB, or in Excel (or something else)? there is no such thing as a "vba.exe". If you've created the project in VB, then you'd need to execute a command like "Make EXE" from the VB file menu. You might also need to create a Setup project. If you've written the code in a VBA project in an Excel workbook, then you'd need to bring that workbook to your office machine. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)

Re: create a vba .exe file "Dawn Crosier" <dlc110161[ at ]hotmail.com> 30.11.2005 19:25:50 In addition to what Cindy told you, when changing VBA projects from version to version the VBA code can get confused because it looks to various references for help in knowing what they should do. So, in the computer that the code does not work, open the VB Editor and from the Tools menu, select References. Look at the list which contains checkmarks, and notice whether any of them start with MISSING. If so, then clear the checkmark and go down the list and find the proper one. For instance, you developed in Word 2000. When you opened your project in Word 97, you should see Microsoft Office 9.0 Object Library listed as missing. If you scroll down you should find that there is a Microsoft Office 8.0 Object Library that you can check, and chances are good that your code will begin to work. However, there are things that you can do in Office 2000 that you can not do in Office 97, so you may have to tweak your code to allow for those kinds of variations. I always recommend developing your code in the lowest version of Office that you expect the code to run in. The newer versions "know" there are older versions created, but the older versions don't "know" about anything that comes after them. Hope that helps. -- Dawn Crosier Microsoft MVP "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. "erp" <erp[ at ]discussions.microsoft.com> wrote in message news:65B04921-78B1-4A64-A836-23F3714D69AD[ at ]microsoft.com... |I have just completed a very tedious program that had me learining vb, vba, | and exel vba for 2000 on my XP os all at the same time. The system i | created the program on of course allows it to work just fine. I brought it | to work on me 2000 os office 97 excel and the thing will not compile- says | ther is files missing- I have ID'ed them on me home system but don't know how | to get the program to work on the 2000 os system- I can't seem to find the | information on how to create an exe file for VBA.