VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
Go Back  Xtreme Visual Basic Talk > > > VB.net 2010 application does not run on all computers


Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2012, 07:51 AM
BeBob9000 BeBob9000 is offline
Newcomer
 
Join Date: Jan 2012
Posts: 3
Default VB.net 2010 application does not run on all computers


I have an VB.NET 2010 application using framework 4 that has issues with reading and writing to cells using command similar to 'RequiredSoftwareVersion = EmployeesSheet.Cells(37, 4).value'. The big thing is I can open/close the workbook, select which worksheet in the workbook. On some computers it works fine, on others I get a pop-up that asks if you want details, continune, quit. All the computers have Office 2007 installed.
Reply With Quote
  #2  
Old 01-04-2012, 10:15 AM
Gruff's Avatar
GruffVB.net 2010 application does not run on all computers Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

Was the computer logged in as an administrator when the program was installed?

Sounds like the UAC (User Account Control Settings) is on for some Window 7 boxes.

If they are not Window 7 machines then I have no idea.
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
  #3  
Old 01-04-2012, 02:00 PM
BeBob9000 BeBob9000 is offline
Newcomer
 
Join Date: Jan 2012
Posts: 3
Default

Some thins I should have said before:

* All machines are running Windows XP.
* The software was installed as I was the Administrator.
* RequiredSoftwareVersion = EmployeesSheet.Cells(37, 4).value expression results in an error "Unable to cast COM object of type 'System_.ComObject' to interface type 'Microsoft.Office.Interop.Excel.Range'. No such interface supported.

I don't understand the why I would get this because I have opened the Excel file, read the names of ALL the worksheet(s) in the workbook. Shouldn't I be able to read a cell if I can read the name of the sheet?
Reply With Quote
  #4  
Old 01-04-2012, 02:09 PM
BeBob9000 BeBob9000 is offline
Newcomer
 
Join Date: Jan 2012
Posts: 3
Default Somethings I forgot

All of the computers will be running Windows XP, and I was the Admin when I install the software.

'RequiredSoftwareVersion = EmployeesSheet.Cells(37, 4).value' line of code give an error of No such interface supported. See attached image.
Attached Images
File Type: bmp N1.bmp (366.3 KB, 4 views)
Reply With Quote
  #5  
Old 01-04-2012, 04:43 PM
Gruff's Avatar
GruffVB.net 2010 application does not run on all computers Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

Where did you get RequiredSoftwareVersion from? I do not see it listed on MSDN as an Excel method. Your error would indicate that the input for RequiredSoftwareVersion is not an excel range. Find out what it needs to be an convert your Excel.Range to that type
Then push it into RequiredSoftwareVersion.

Do you have: Option Strict Off?
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
 
VB.net 2010 application does not run on all computers
VB.net 2010 application does not run on all computers
 
-->