Adding Excel Worksheet to existing Workbook using Access 97 Macro

  • Thread starter Thread starter Mike F via AccessMonster.com
  • Start date Start date
M

Mike F via AccessMonster.com

Does anyone know how (if) you can add worksheet(s) to an existing Excel
workbook using an MS Access 97 macro?
 
Not via a macro in ACCESS, no. But via VBA code in ACCESS, yes.
 
Some generic code:

Dim xlx As Object, xlw As Object, xls As Object
Set xlx = CreateObject("Excel.Application")
xlx.Visible = True
Set xlw = xlx.Workbooks.Open("C:\Filename.xls"), , True
Set xls = xlw.Worksheets.Add
xls.Name = "NameForNewWorksheet"
Set xls = Nothing
xlw.Close
Set xlw = Nothing
xlx.Quit
Set xlx = Nothing
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 0
Output to macro action 1
Excel Protection 2
VBA assistance 0
How to call Excel add-in macro from a button… 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Pasting infomation into worksheet with macro 2
Macros to extract data frommultiple workbooks to a master workbook 0

Back
Top