|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
December 29th, 2009, 08:17 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Macro or VB code to Export data to an Excel file?
I have a query that assembles the data that I would like to routinely
export as an Excel file to a specific file location. I would like it such that various users can 'just press a button' so to speak and get the most current data from the database for use in an Excel Pivot Table. I would like either or both a Macro or VB code to do this. When I looked at the Macro options this was not obvious? Bob 
|
|
#2
December 29th, 2009, 08:55 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
Take a look at the TransferSpreadsheet function in the Help file.
Steve "BobC" wrote in message ... I have a query that assembles the data that I would like to routinely export as an Excel file to a specific file location. I would like it such that various users can 'just press a button' so to speak and get the most current data from the database for use in an Excel Pivot Table. I would like either or both a Macro or VB code to do this. When I looked at the Macro options this was not obvious? Bob
|
|
#3
December 29th, 2009, 09:34 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
Looks promising! ... I wonder what else have I missed?
Steve wrote: TransferSpreadsheet function
|
|
#4
December 29th, 2009, 10:51 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
Bob,
Take a look at Ken Snell's page. http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm Richard "BobC" wrote: I have a query that assembles the data that I would like to routinely export as an Excel file to a specific file location. I would like it such that various users can 'just press a button' so to speak and get the most current data from the database for use in an Excel Pivot Table. I would like either or both a Macro or VB code to do this. When I looked at the Macro options this was not obvious? Bob .
|
|
#5
December 29th, 2009, 11:37 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
Before proceding, post your relevant tables and I will analyze and comment.
Steve "BobC" wrote in message ... Looks promising! ... I wonder what else have I missed? Steve wrote: TransferSpreadsheet function
|
|
#6
December 30th, 2009, 12:03 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
"Steve" schreef in bericht ... Before proceding, post your relevant tables and I will analyze and comment. Steve And afterwards you will give your quote ??? -- Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 10.500 pageloads... it's a shame !!) Arno R
|
|
#7
December 30th, 2009, 12:41 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
Richard,
Wow! ... Thanks Much!!! Bob Richard wrote: Bob, Take a look at Ken Snell's page. http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm Richard "BobC" wrote: I have a query that assembles the data that I would like to routinely export as an Excel file to a specific file location. I would like it such that various users can 'just press a button' so to speak and get the most current data from the database for use in an Excel Pivot Table. I would like either or both a Macro or VB code to do this. When I looked at the Macro options this was not obvious? Bob .
|
|
#8
December 30th, 2009, 12:45 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
I suspect I am mission out on something here?
StopThisAdvertising wrote: schreef in bericht ... Before proceding, post your relevant tables and I will analyze and comment. Steve And afterwards you will give your quote ???
|
|
#9
December 30th, 2009, 01:14 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
Steve Santus basically haunts these newsgroups looking for business. He was
caught by the poster who answered him. Good professional quality help is here for free. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "BobC" wrote in message ... I suspect I am mission out on something here? StopThisAdvertising wrote: schreef in bericht ... Before proceding, post your relevant tables and I will analyze and comment. Steve And afterwards you will give your quote ???
|
|
#10
December 30th, 2009, 01:21 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Macro or VB code to Export data to an Excel file?
On Tue, 29 Dec 2009 19:45:13 -0500, BobC wrote:
I suspect I am mission out on something here? Steve is notorious for using these groups to troll for unsuspecting potential customers. Unlike 99+% of the other volunteers who answer here, he considers it appropriate to solicit paid business. John (and a few other people) post responses to these solicitations to warn folks that Steve's proposals should be carefully examined. -- John W. Vinson [MVP]
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
