Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Vb.net - excel 97 automation

Not sure if this is the right newsgroup...
-----------------------------
I have a vb.net app that reads data from Access and places
it into Excel. This was done utilizing Office XP. The
user is testing on their machine, which only has Office
97. The app bombs when trying to create the excel object,
i.e., CreateObject(Excel.Application).

I have a reference to Excel 10 in the vb.net app.
However, I cannot find an Excel 8 (exe, dll, etc.) in
which to add that as a reference instead.

How do I make the vb.net app reference the Excel 97
object? I tried running regsvr32 excel9.olb on my
development machine, but it states an error indicating it
couldn't find an entry point.

Thanks for any help.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automation - import into excel Tracy[_4_] New Users to Excel 2 March 26th 10 02:18 PM
Using Excel with automation Thomas Bodell Excel Discussion (Misc queries) 5 May 8th 09 03:09 PM
Automation to Excel from Access Bob Barnes Excel Discussion (Misc queries) 1 February 11th 08 05:18 AM
Excel spradsheet automation help deepika New Users to Excel 1 January 4th 08 06:22 PM
automation from access into excel SAm Excel Discussion (Misc queries) 7 January 27th 06 02:49 AM


All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"