EXCEL TO ACCESS
Posted by DAN POWELL on January 04, 2001 11:44 AM
Using Office 97, I would like a macro in excel to open an Access file and close the present Excel file. Is this possible?
Thanks Dan
Posted by Jim on January 06, 2001 7:48 AM
If you will use a VBA subroutine like this I think it will do what you need.
Sub Get_Access()
ActiveWorkbook.Save
Call Shell("C:\Office97\Office\MsAccess.exe C:\EDRN_4_of_4.mdb", 1)
ActiveWindow.Close
Set sys = Nothing
Application.Quit
End sub
