By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

Access to excel...

P: n/a
What I am trying to do is create a Form in Access, when the information is
entered in the form it is sent to an Excel spreadsheet where it can be saved
as a different file name and printed. Thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

May 23 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 23 May 2007 19:05:09 GMT, "stephendeloach via
AccessMonster.com" <u32891@uwewrote:

The simplest way to export data to Excel is using
DoCmd.TransferSpreadsheet. One line does it all. Look it up in the
Help file.
Beyond that is Automation, which requires moderate VBA skills.

-Tom.
>What I am trying to do is create a Form in Access, when the information is
entered in the form it is sent to an Excel spreadsheet where it can be saved
as a different file name and printed. Thanks.
May 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.