Problems with vb and excel 
Author Message
 Problems with vb and excel
Hi

I am developing a vb project using ado and access
database. The development machine is windows 2000. I have
opened an excel spread sheet using ole container. My
application needs to run on 95,nt and 2000 machines. The
trouble i am facing is all of them will have different
excel versions. Can i embed an excel worksheet in my
application and it will run on the client machine no
matter what version of excel is installed or if excel is
not installed at all. Any start ups for such a custom vb
control.

Thank You

Jimmy



Fri, 29 Oct 2004 16:12:45 GMT
 Problems with vb and excel

Hi Jimmy,

You can use later binding in your program. For example:

Dim o As Object
Set o = CreateObject("excel.application")
o.Workbooks.Open "c:\C_Book1.xls"

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)



Sat, 30 Oct 2004 17:12:56 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problem with VB to Excel

2. Getting data from Excel to VB using ADO problem

3. Help: Problem w/ VB/Excel Automation Error

4. Problems Updating Excel Spreadsheet using ADO and VB 6.0

5. problem with excel 4 file in VB

6. Excel + VB.NET + task will not be closed + UNIQUE insance problem

7. Lock problem reading Excel data from VB

8. Lock problem reading Excel data from VB

9. Problem with redisplaying Excel for a 2nd time using VB 5.0

10. Problems Updating Excel Spreadsheet using ADO and VB 6.0

11. Interface for VB--> VB for excel

12. Excel to Excel problem


 
Powered by phpBB® Forum Software