Exporting a pivot table using a macro

Exporting a pivot table using a macro

Post by Sm9kaW » Thu, 29 Oct 2009 03:21:01

How can I set a macro to export a pivot table from Access to Excel? I have
tried exporting the table (not pivot) and doing the pivot in Excel, but I
can't get the format the same as it is when I export the pivot from Access.
Any help would be appreciated.
Thank you, Jodie

1. Counting A's in a table column 1, F's in column 2, etc...

2. Printing report b after report a prints using report a's variables

I have a report (Report A). When it runs, it ask a question which selects
what report to run. This works fine.

I have another report (Report B). When it runs, it doens't ask questions by
design and returns all "inventory". There is a table in Report B that
references Report A.

I need to run Report A, inputing what report I want to run... (ex. 200).
From there, on print, need to run Report B with the selection variables from
Report A(ex. 200) if there were matching records.

So, Report A would print #200's information. If there were "inventory"
items that referenced #200, it would print the Inventory information included
in Report B.

Do I use Macros? If so, what do I build it on? Do I have to use custom code?

Thank you in advance!

3. using "if" but omitting the #n/a's

4. Why does Form-A's instance fire Form-B's event??

5. Copy all data from a:Class A's fields to the namesake fields of b:Class B.

6. Capture image of App#A's window from App#B

7. equation that will filter out #N/A's

8. lookup only finds #n/a's

9. Quick A's to easy(?) Q's appreciated...

10. #n/a's

11. How do I only get valid "answers" in a VLOOKUP function (no #N/A's

12. how to hide #N/A's?

13. best way to sum a column with #N/a's?

14. 'Send As' messages stay in User A's sent folder.

15. Scottie A's Hall of Flame