R
Razor
Hi,
I have an Excel spreadsheet with several tabs, one for
each Region. Each tab contains a list of applications
relavant to that region.
I want to do the following at the click of a button on my
form:
1. Import all the tabs into an Access table,
2. create a new column called "Region" and populate it
using the names of the tab,
3. Run a crosstab query on the table with Region as
ColumnHeading,
4. Export the resultset of the crosstab query back to
Excel and
5. save this Excel file
Can someone suggest the code to do this?
I have written the crosstab query, but the process still
needs user intervention (steps 1 through 5)
The lists of apps for each region keep getting updated
and I would like the entire process to be
operationalized, so the user thinks of generating the
crosstab simply as running a "script" on the latest cut
of the data.
Thanks for your help!
Regards,
Razor
I have an Excel spreadsheet with several tabs, one for
each Region. Each tab contains a list of applications
relavant to that region.
I want to do the following at the click of a button on my
form:
1. Import all the tabs into an Access table,
2. create a new column called "Region" and populate it
using the names of the tab,
3. Run a crosstab query on the table with Region as
ColumnHeading,
4. Export the resultset of the crosstab query back to
Excel and
5. save this Excel file
Can someone suggest the code to do this?
I have written the crosstab query, but the process still
needs user intervention (steps 1 through 5)
The lists of apps for each region keep getting updated
and I would like the entire process to be
operationalized, so the user thinks of generating the
crosstab simply as running a "script" on the latest cut
of the data.
Thanks for your help!
Regards,
Razor