Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 open and close a file

Author  Topic 

dringi
Starting Member

7 Posts

Posted - 2005-11-28 : 16:19:58
hi, i would like to open, save and close an excel file from access...how can i do??

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2005-11-29 : 17:09:14
Wrong forum, but check out the Office automation objects available in VBA. You should be able to do anything to Excel files you want from there.
Might help if you told us exactly what you were trying to do....

Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-12-04 : 07:49:32
Open an access aplication and then in the file type menu, choose excell and point to your excell file.
Go to Top of Page
   

- Advertisement -