 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
08-30-2008, 04:06 AM
|
|||
|
|||
|
Re: Exporting data to excel
hi Anthony
when you use TransferSpreadsheet to export a query without specifying a worksheet name in the Range argument, and the workbook already contains a worksheet with the same name as the query, the new data will replace the data on the existing sheet. If you want to export a query with the same name multiple times so it creates multiple worksheets in the same workbook, you have to specify the worksheet name each time you call TranferSpreadsheet (or change the name of the query each time). Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Anthony Lisanti" <ajlisanti@optonline.net> wrote in message news:gslgb4dfri8k0ic50jklg1mde90rg07jkm@4ax.com... > > > I have an access database that breaks a table up and dumps it to 3 > spreadsheets. I need to make 1 spreadsheet with 3 tabs, not 3 > different spreadsheets. Can this be done with a macro? > > Thanks > > Tony 
|
|
08-30-2008, 01:11 PM
|
|||
|
|||
|
Re: Exporting data to excel
So, what you're saying is if I have a template, with tabs that say "Affiliate, Domestic, International" the queries from each of those names will populate the tabs, with the same name, right? On Sat, 30 Aug 2008 13:06:36 +1000, "Jeanette Cunningham" <nnn@discussions.microsoft.com> wrote: >hi Anthony > >when you use TransferSpreadsheet to export a query without specifying a >worksheet name in the Range argument, and the workbook already contains a >worksheet with the same name as the query, the new data will replace the >data on the existing sheet. If you want to export a query with the same >name multiple times so it creates multiple worksheets in the same >workbook, you have to specify the worksheet name each time you call >TranferSpreadsheet (or change the name of the query each time). > > >Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia > > >"Anthony Lisanti" <ajlisanti@optonline.net> wrote in message >news:gslgb4dfri8k0ic50jklg1mde90rg07jkm@4ax.com.. . >> >> >> I have an access database that breaks a table up and dumps it to 3 >> spreadsheets. I need to make 1 spreadsheet with 3 tabs, not 3 >> different spreadsheets. Can this be done with a macro? >> >> Thanks >> >> Tony >
|
|
08-30-2008, 10:50 PM
|
|||
|
|||
|
Re: Exporting data to excel
Did you try it? What did you find?
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Anthony Lisanti" <ajlisanti@optonline.net> wrote in message news:34eib4h5k86bk3mve1q3e7mleiac9eltic@4ax.com... > > So, what you're saying is if I have a template, with tabs that say > "Affiliate, Domestic, International" the queries from each of those > names will populate the tabs, with the same name, right? > > > > > > > On Sat, 30 Aug 2008 13:06:36 +1000, "Jeanette Cunningham" > <nnn@discussions.microsoft.com> wrote: > >>hi Anthony >> >>when you use TransferSpreadsheet to export a query without specifying a >>worksheet name in the Range argument, and the workbook already contains a >>worksheet with the same name as the query, the new data will replace the >>data on the existing sheet. If you want to export a query with the same >>name multiple times so it creates multiple worksheets in the same >>workbook, you have to specify the worksheet name each time you call >>TranferSpreadsheet (or change the name of the query each time). >> >> >>Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia >> >> >>"Anthony Lisanti" <ajlisanti@optonline.net> wrote in message >>news:gslgb4dfri8k0ic50jklg1mde90rg07jkm@4ax.com. .. >>> >>> >>> I have an access database that breaks a table up and dumps it to 3 >>> spreadsheets. I need to make 1 spreadsheet with 3 tabs, not 3 >>> different spreadsheets. Can this be done with a macro? >>> >>> Thanks >>> >>> Tony >>
|
|
09-01-2008, 04:02 PM
|
|||
|
|||
|
Re: Exporting data to excel
I dont see the option in the macros Transferspreadsheet. Is this a VB function? On Sun, 31 Aug 2008 07:50:20 +1000, "Jeanette Cunningham" <nnn@discussions.microsoft.com> wrote: >Did you try it? What did you find? > > >Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia > > >"Anthony Lisanti" <ajlisanti@optonline.net> wrote in message >news:34eib4h5k86bk3mve1q3e7mleiac9eltic@4ax.com.. . >> >> So, what you're saying is if I have a template, with tabs that say >> "Affiliate, Domestic, International" the queries from each of those >> names will populate the tabs, with the same name, right? >> >> >> >> >> >> >> On Sat, 30 Aug 2008 13:06:36 +1000, "Jeanette Cunningham" >> <nnn@discussions.microsoft.com> wrote: >> >>>hi Anthony >>> >>>when you use TransferSpreadsheet to export a query without specifying a >>>worksheet name in the Range argument, and the workbook already contains a >>>worksheet with the same name as the query, the new data will replace the >>>data on the existing sheet. If you want to export a query with the same >>>name multiple times so it creates multiple worksheets in the same >>>workbook, you have to specify the worksheet name each time you call >>>TranferSpreadsheet (or change the name of the query each time). >>> >>> >>>Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia >>> >>> >>>"Anthony Lisanti" <ajlisanti@optonline.net> wrote in message >>>news:gslgb4dfri8k0ic50jklg1mde90rg07jkm@4ax.com ... >>>> >>>> >>>> I have an access database that breaks a table up and dumps it to 3 >>>> spreadsheets. I need to make 1 spreadsheet with 3 tabs, not 3 >>>> different spreadsheets. Can this be done with a macro? >>>> >>>> Thanks >>>> >>>> Tony >>> >
|
|
09-02-2008, 04:47 AM
|
|||
|
|||
|
Re: Exporting data to excel
All the options are there in the macro - transfer type, spreadsheet type,
table name, file name and range. If it doesn't work for you, which is the bit that doesn't work? Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Anthony Lisanti" <ajlisanti@optonline.net> wrote in message news:fu0ob4p5q9lp6l20t4scm0u3hh58n8l47q@4ax.com... > > I dont see the option in the macros Transferspreadsheet. Is this a VB > function? > > On Sun, 31 Aug 2008 07:50:20 +1000, "Jeanette Cunningham" > <nnn@discussions.microsoft.com> wrote: > >>Did you try it? What did you find? >> >> >>Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia >> >> >>"Anthony Lisanti" <ajlisanti@optonline.net> wrote in message >>news:34eib4h5k86bk3mve1q3e7mleiac9eltic@4ax.com. .. >>> >>> So, what you're saying is if I have a template, with tabs that say >>> "Affiliate, Domestic, International" the queries from each of those >>> names will populate the tabs, with the same name, right? >>> >>> >>> >>> >>> >>> >>> On Sat, 30 Aug 2008 13:06:36 +1000, "Jeanette Cunningham" >>> <nnn@discussions.microsoft.com> wrote: >>> >>>>hi Anthony >>>> >>>>when you use TransferSpreadsheet to export a query without specifying a >>>>worksheet name in the Range argument, and the workbook already contains >>>>a >>>>worksheet with the same name as the query, the new data will replace the >>>>data on the existing sheet. If you want to export a query with the same >>>>name multiple times so it creates multiple worksheets in the same >>>>workbook, you have to specify the worksheet name each time you call >>>>TranferSpreadsheet (or change the name of the query each time). >>>> >>>> >>>>Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia >>>> >>>> >>>>"Anthony Lisanti" <ajlisanti@optonline.net> wrote in message >>>>news:gslgb4dfri8k0ic50jklg1mde90rg07jkm@4ax.co m... >>>>> >>>>> >>>>> I have an access database that breaks a table up and dumps it to 3 >>>>> spreadsheets. I need to make 1 spreadsheet with 3 tabs, not 3 >>>>> different spreadsheets. Can this be done with a macro? >>>>> >>>>> Thanks >>>>> >>>>> Tony >>>> >>
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
