Error opening an Excel workbook

Hello,

I wrote a program in Visual Basic 6 whose only function is to automate entries on an Excel sheet. The program runs fine on my computer, but when I attempted to deploy it on a computer at work, via a deployment wizard it could not find Excel. The program came up and ran fine, but whenever I attempted to use its internal functions that open an existing Excel sheet, it crashes.

I've been attempting to make a work around for the problem, by way of converting it to an Excel Add-In, but I've never worked with addins before. When I compile it as an addin, I'm given a .DLL file, and when I attempt to open an Add-In from Excel, .DLL is not one of the supported extentions.

Any suggestions?

You should have no problem deploying a VB program. Check out the Application Deployment forum. You could also visit www.*********** to get Inno Setup and Inno Script. They are an alternative to using the P&D Wizard.
Randem is a member here. Check out the forum.

Quote:

---

Originally Posted by Surveillance

Hello,

I wrote a program in Visual Basic 6 whose only function is to automate entries on an Excel sheet. The program runs fine on my computer, but when I attempted to deploy it on a computer at work, via a deployment wizard it could not find Excel. The program came up and ran fine, but whenever I attempted to use its internal functions that open an existing Excel sheet, it crashes.

I've been attempting to make a work around for the problem, by way of converting it to an Excel Add-In, but I've never worked with addins before. When I compile it as an addin, I'm given a .DLL file, and when I attempt to open an Add-In from Excel, .DLL is not one of the supported extentions.

Any suggestions?

---

I'm going to ask the obvious question and that is: Is Excel installed on the target machine?

If so (and I would assume that it is but I had to ask), what is the specific error you get when you try to open a worksheet? Is the worksheet also installed on the target machine (or, at least, accessible from the target machine...if it is on a network drive, does the target machine has access to that drive?)

What version of Excel did you set a reference to in your project? What version of Excel is on the system at work, if any as Hack has already mentioned?

An Excel Add-In is an *.xla extension generated from within Excel and not VB6. ;)

Moved from Classic VB. :)


Note: w00t w00t - 18,000 Posts! Gangsta Yoda™ http://www.vbforums.com/attachment.p...chmentid=38679®

Yes, Excel is installed on the target computer, though after fiddling with it some more today, there seems to be some sort of error with its installation. When I attempt to open an Excel file, the computer begins trying to install Excel again, though if I open the installed copy I can open other files fine.

On the bright side, I feel better about my program... on the down side, I'm not in the MIS dept, and they don't know I'm attempting to install any such software, nor would they appreciate it if they found out I was, I think.

Some people just don't understand efficiency. Heh.

Thanks for the help, sorry to waste your time :)

You can also tell them that if you messup the system, your only securing their job security or something like that. :D Just kidding though, dont want to irritate them since they are your lifeline to get permission to install things. ;)

If your getting the Installer dialog boxes then just run through them and finish installing the features of Excel that your needing. If you deployed Excel dlls or references then you may have overwrote the original ones and now it thinks it not installed. Remember that you can not legally deploy any Office references. ;)