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

Trasfer to Excel

P: n/a
I can transfer my data from a table into an Excel Spreaadsheet with

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Whatever",
"Whatever"

This saves the spreadsheet and the user has to open it. I would prefer the
user to have Excel to open automatically with the data in it, then save it
if they want to. I feel it ought to be easy but I may be looking in the
wrong place.

Thanks in advance
Nov 11 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"JohnM" <jo**@jmawer.demon.co.ukschreef in bericht
news:ej*******************@news.demon.co.uk...
>I can transfer my data from a table into an Excel Spreaadsheet with

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Whatever",
"Whatever"

This saves the spreadsheet and the user has to open it. I would prefer
the user to have Excel to open automatically with the data in it, then
save it if they want to. I feel it ought to be easy but I may be
looking in the wrong place.
Not sure this is what you want, but you can make a simple macro that
transfers the data to an Excel-file and automatically opens it. The action
is something like 'execute to', I'm not sure since I only have the Dutch
version. In that action you have an option 'Autostart Yes/No'.

john
Nov 11 '06 #2

P: n/a
On Sat, 11 Nov 2006 07:41:13 -0000, JohnM wrote:
I can transfer my data from a table into an Excel Spreaadsheet with

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Whatever",
"Whatever"

This saves the spreadsheet and the user has to open it. I would prefer the
user to have Excel to open automatically with the data in it, then save it
if they want to. I feel it ought to be easy but I may be looking in the
wrong place.

Thanks in advance
Add one more line of code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8,
"Whatever", "Whatever"
Application.FollowHyperlink "Whatever the Path and name of the file
is.xls"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Nov 11 '06 #3

P: n/a
Thanks .... This is on a network where the database is in an area where the
user can read only. I want the user to be able to save the Excel file in
their own area. Ideally I wan to open an empty excel spreadsheet with the
dat then pasted into it. (I could just allow the user to cut and paste, but
this way I can do all the business of filtering the data foe them.)

"fredg" <fg******@example.invalidwrote in message
news:18*****************************@40tude.net...
On Sat, 11 Nov 2006 07:41:13 -0000, JohnM wrote:
>I can transfer my data from a table into an Excel Spreaadsheet with

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Whatever",
"Whatever"

This saves the spreadsheet and the user has to open it. I would prefer
the
user to have Excel to open automatically with the data in it, then save
it
if they want to. I feel it ought to be easy but I may be looking in
the
wrong place.

Thanks in advance

Add one more line of code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8,
"Whatever", "Whatever"
Application.FollowHyperlink "Whatever the Path and name of the file
is.xls"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Nov 12 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.