|
-
Jul 21st, 2003, 04:01 PM
#1
Thread Starter
Junior Member
Excel Object Crashes non-XP systems
I am creating an Excel object in my VB6 app. My development machine has Excel 10 (XP), and so I set a reference to "Mcirosoft Excel 10 Library" and then do this:
Dim xl As Excel.Application
Private Sub Form_Load()
Set xl = New Excel.Application
xl.Workbooks.Open (App.Path & "\myfile.xls")
This works *great* on systems with Excel 10, but not on systems that have Excel 97 or 2k. Is there a way I can make this reference and ensure backward compatibility between my app and various versions of Excel? Do I need to install Excel 97 and make a reference to that instead? Hmmm.... Is there a way to make a generic reference to Excel without specifying a version?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|