Save to New version : problem with VBA and Excel OLE Automation

Save to New version : problem with VBA and Excel OLE Automation

Post by Marcel de Haa » Fri, 06 Dec 1996 04:00:00

Does anybody know HOW to save an excel sheet version 4.0 to version 5.0?
If you have a SHORT piece of sample code for me i would be very thankful.      

(WhErE eVeR yOu GO, gO MiCrOsOFt)

Ing. Marcel Pieter de Haan

Application programmer
Randstad Automatiseringsdiensten bv
Amsterdam, The Netherlands


1. Need help with OLE Automation and Access from VBA

I am trying use visual basic to run queries and reports I wrote in
Access.  I am trying to use OLE Automation to do so.  I am practicing on
the Northwind database until I understand what I am doing.  I have added
in the Access object Library.  I used some Dim statements to identify the
database and used the getObject command to identify Northwind.  The
program continually crashes when I try to execute the query though.  The
offending line is below.  What do I need to do in the way of declares or
other to get this to work?  The error generated is  "Object required,
error 424.  Thanks for any help.

 objAccess.DoCmd.OpenQuery "Invoices", acNormal, acEdit

2. PR Tracker: A great program for tracking application errors

3. Saving and retrieving Ole-Automation objects from Dao and MFC using CLongBinary class

4. Inner Join

5. OLE Automation. Save As question

6. Call for platforms

7. How to save a Excel worksheet interactively to SQL from VBA/DTS

8. Spurious Login Failures - RDO

9. little OLE automation with Excel 97 and Forms 4.5

10. OLE Automation and Excel

11. SOLUTION: Excel 5.0, VB4.0, Access 2.0, OLE Automation, Recordset to Spreadsheet population

12. VB5 OLE Automation: MS Access Data into Excel

13. VFP OLE Automation (Excel)