Search results for query: *

To All, According to Microsoft I need Visual Studio Tools for Office,which works only with Office 2003 Professional.In the meantime I deleted Excel.exe from my package and the the program works OK provided the computer has Excel installed. LostinCode was correct.Thanks to All for your help...

To All, I am at fault trying to do what cannot (and now I believe should not ) be done. I will contact Microsoft regarding the way to provide from VB restricted Excel functionality for users who do not have Excel. Incidentally Microsoft is protected because Error 429 denies Automation if...

To All, My problem still persists. I used CreateObject to enable OLE Automation and to assign it to an Object Variable. I used GetObject to open a file. I used Set to select a Worksheet (direct selection does not work gives Error 438). The action on the first Worksheet worked OK. When I...

Dear strongm, Excel.exe can be packaged by PWD Wizard by Adding it to your packaged files; it becomes available only to VB program which is calling it. Regards, Henry Henry Drillich drillich@tpgi.com.au

Dear johnwm Runtime version means that only the VB program can acess this Excel functionality. You cannot open it and use outside the program.Regards, Henry Henry Drillich drillich@tpgi.com.au

Dear LostIn Code, Runtime version means that only the VB program can acess this Excel functionality. You cannot open it and use outside the program.Regards, Henry Henry Drillich drillich@tpgi.com.au

Dear Chip, Thanks for your advice. I will try to replace Set statements with CreateObject and hope it will work. Regards, Henry Henry Drillich drillich@tpgi.com.au

Dear Golom, The package includes runtime version of Excel and all necesary References and Components. Following Chip H.'s suggestion I will try to replace Set statements with CreateObject and see what happens. Thanks and regards, Henry Henry Drillich drillich@tpgi.com.au

I have written a program in VB6 using extensively Excel Workbooks and Worksheets and this is packaged by MS PWD. The program runs well on all machines which have MS Office installed but will not run on machines without Excel installed giving Runtime "Error 429 Activex component can't create...

Thanks for your advice. I installed the runtime libraries as well as Sevice Pack 5.It looks to me that this is the problem caused by lack of resources allocated by Windows 98. Unfortunately I can get it going in Windows 98 only by scaling down some operations. Windows XP handle the program...

Program written in VB6 runs out of available memory in Windows 98 (it is OK in Windows XP). Unloading some forms (which are not required for this segment) does not release available memory, neither does the increase in the size of the Swap File (checking with System Monitor), which remains...

Dear Mike, It appears that the problem is in Windows98 and not in DCOM98 (it was incompatible with an HP program supplied with my Laptop.). I ported eventually my program to Windows 98 to find the same error (No 7. Checking the System Monitor reveals that Windows 98 does not release the memory...

Thanks for info. I will let you know when I fix it. Regards, Henry Henry Drillich drillich@tpgi.com.au

Did you install Service Pack 5? Regards, Henry Henry Drillich drillich@tpgi.com.au

Did you install Service Pack 5? Regards, Henry Henry Drillich drillich@tpgi.com.au

Dear Mike, Thanks for your E-mail. I installed DCOM98 (latest web version 1.3, installed DCOM98.exe version is 4.71.10150)) before installing my application. I am using MDAC. The program itself is OK as I tried it out on number of Windows XP installations and I attribute the runtime error 7 out...

I wrote a program in VB6 in Windows XP environment and packaged it with Microsoft PD Wizard. The programa distributes and runs OK in Windows XP. However in Windows 98 it installes OK but when running comes with Runtime Error 7 Out of space. I believe that this is due to some problem in DCOM 98...

Use PD Wizard (in VB6). Also Service pack SP5Regards, Henry Henry Drillich drillich@tpgi.com.au

Re usingPD Wizard make sure that you download Service Pack SP5. You need also to check Setup Listing that all files are correctly registered (.tlb should have TLB Register not SelfRegister); any errors you can change in Notepad. Regards, Henry Henry Drillich drillich@tpgi.com.au

Further info: The program created in Windows XP environment. Service Pack SP5 (for VB6) is installed. DCOM98 installed on Windows 98 machine. Henry Henry Drillich drillich@tpgi.com.au