Google Answers Logo
View Question
 
Q: Computer programming: VB.net and axSpreadsheet control ( No Answer,   0 Comments )
Question  
Subject: Computer programming: VB.net and axSpreadsheet control
Category: Computers > Programming
Asked by: wwallace-ga
List Price: $20.00
Posted: 11 Apr 2003 17:17 PDT
Expires: 24 Apr 2003 11:07 PDT
Question ID: 189496
I am a VB.net developer.  I wrote a windows application that
prominently featured a control called "axSpreadsheet."  It ran very
well on my computer (Visual Basic.net standard edition is what I have
installed on my computer).

When I emailed the application to a coworker, it would not run on his
computer. He only has the "distributable .net framework download"
installed on his computer.

We quickly reached the conclusion that axSpreadsheet is the culprit.

Is it possible to distribute a windows application written in VB.net
that utilizes the axSpreadsheet control, so that it runs on another
computer?  Does he require an additional download?

Request for Question Clarification by mmastrac-ga on 13 Apr 2003 08:49 PDT
Did you email the axSpreadsheet .ocx or .dll control along with the application?

Clarification of Question by wwallace-ga on 14 Apr 2003 13:54 PDT
Hi mmastrac,

Thanks for responding.

I mailed the following .dlls with the application:

adodb.dll
AxInterop.OWC.dll
Interop.OWC.dll
msdatasrc.dll
stdole.dll

Thanks,

Bill.

Request for Question Clarification by mmastrac-ga on 14 Apr 2003 20:17 PDT
What sort of error message are you encountering?  

Which dll is axSpreadsheet contained in?  Does it exist on your
friends computer?  Has your friend registered the axSpreadsheet
ocx/dll on his computer (regsvr32 control.dll)?

From what I can tell, you have all of the appropriate .NET components
sent over.  We may be looking at a COM object registration issue at
this point.

Clarification of Question by wwallace-ga on 15 Apr 2003 09:28 PDT
If that is the case, what should I try to do?

Request for Question Clarification by mmastrac-ga on 15 Apr 2003 16:29 PDT
It sounds like your friend does not have Office XP installed.  As far
as I know, the axSpreadSheet object comes from the Office XP web
components set.  The Office XP Web Components can be downloaded from
this page:

http://office.microsoft.com/downloads/2002/owc10.aspx

This note appears on the page, however:

Note   If you do not own an Office XP license, the Office Web
Components will run with view-only functionality rather than with full
interactive functionality. (Data access pages do not require an Office
XP license, so you will always be able to take advantage of a page's
full interactive functionality.)

Try having your coworked download and install this package.  This
should help your app start up, but it may have reduced functionality.

Clarification of Question by wwallace-ga on 16 Apr 2003 11:46 PDT
We tried the download but it did not fix the problem (this is a real education!).

Thank you very much for all of your help.

Is there anything else we could try?

Clarification of Question by wwallace-ga on 16 Apr 2003 11:53 PDT
Am I flogging a dead horse?  Have you heard of any 3rd party .net
controls that have axSpreadsheet capabilities?

Request for Question Clarification by mmastrac-ga on 17 Apr 2003 06:40 PDT
The ComponentOne FlexGrid for .NET supports this sort of
functionality:

http://www.componentone.com/products.aspx?ProductCode=1&ProductID=17

It's a powerful grid with most of the functionality of Excel.  You can
even download an evalutation to try out before you commit to it.  I
personally use this grid in my .NET apps.

I would still like to solve your problem with axSpreadsheet, however. 
Can you post the text of any .NET exceptions you are receiving, or the
text of any error messageboxes?  If you can let me know what the
symptoms are, I'll have a better idea of what the problem is.

Clarification of Question by wwallace-ga on 18 Apr 2003 09:16 PDT
Here is the text of the .net exception:

Application has generated an exception that could not be handled.

Process id=0x580(1408), Thread id=0x590(1424).

This exception occurs after you double click the exe, but before the
main form is displayed.

Request for Question Clarification by mmastrac-ga on 18 Apr 2003 09:41 PDT
Some more questions for diagnosis:

- Does your friend have a version of Office installed?
- If so, which one?
- Which version of Office do you have installed?

If you would like, you can upload your files by ftp to: www.grack.com
username:ftp, password:jbTUlKX - drop them in the incoming directory. 
I can then take a look at your program and give you a better idea of
what is going on.

The error you're getting is often caused by a missing COM object or
ActiveX control.  The question is, right now: which one is missing?

Matt.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy