Patrick O'Dea
asked on
Exporting to Excel Datasheet Contents (and More)
Hi,
I have a datasheet (within the frame of a larger form - for presentation purposes).
I may filter the 20,000 rows in the datasheet down to a couple of hundred (using standard Acess Datasheet functionality).
My Question Part One: What is the best (with easy VBA is poss) way to export the (filtered) contents of my datasheet to Excel.
My Question Part Two: I will want to expand the export to include other (related) data other that what is displayed on the datasheet. How do I do this (via a query I presume)
I have a datasheet (within the frame of a larger form - for presentation purposes).
I may filter the 20,000 rows in the datasheet down to a couple of hundred (using standard Acess Datasheet functionality).
My Question Part One: What is the best (with easy VBA is poss) way to export the (filtered) contents of my datasheet to Excel.
My Question Part Two: I will want to expand the export to include other (related) data other that what is displayed on the datasheet. How do I do this (via a query I presume)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER