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 3 1653
"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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Allison Bailey |
last post by:
Hi Folks,
I'm a brand new Python programmer, so please point me in the right
direction if this is not the best forum for this question....
I would like to open an existing MS Excel spreadsheet...
|
by: Otie |
last post by:
I found the following under the GetObject help notes and in the
example for GetObject:
"This example uses the GetObject function to get a reference to a
specific Microsoft Excel worksheet...
|
by: Matthew Wieder |
last post by:
I have the following requirements:
Build a stand-alone C# application that asks the user to click in a cell
in an Excel spreadsheet, and then displays the address of that cell in
the C#...
|
by: pmud |
last post by:
Hi,
I need to use an Excel Sheet in ASP.NET application so that the users can
enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever
the USER ENETRS needs to go to the...
|
by: Howard Kaikow |
last post by:
There's a significant problem in automating Excel from VB .NET.
Reminds me of a problem I encountered almost 3 years ago that was caused by
the Norton Auntie Virus Office plug-in.
Can anybody...
|
by: Anthony |
last post by:
To me, creating Excel 2003 spreadsheets programmatically via VB.NET hasn't
really changed since the days of VB6.
That is, I'd do something similar to this
Code:
Dim ExcelApp As...
|
by: Alain \Mbuna\ |
last post by:
Hi everybody.
In my program I have some data that is calculated after some input from the
user. I have written some code that opens an Excel workbook, with 5
worksheets and the calculated data...
|
by: alexia.bee |
last post by:
Hi all,
In some weird reason, excel instance won;t die if i remove the comment
from 4 lines of setting values into struct.
here is a snipcode
public...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |