[AccessD] Creating New Spreadsheet with Automation

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Fri May 6 10:05:29 CDT 2005


Dear List:

I have been manipulating existing spreadsheet from Access:

' Object variables for Automation stuff
Dim objXLApp As Excel.Application

Set objXLApp = New Excel.Application
objXLApp.Workbooks.Open "C:\Clients\Placement22"

Now I want to create a new spreadsheet instead of opening one that already exists.  But I can't seem to find the method.  

Does anyone know the right syntax?

MTIA

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334



More information about the AccessD mailing list