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