[AccessD] Export to Excel and Open XLS file

Arthur Fuller fuller.artful at gmail.com
Fri May 25 14:01:29 CDT 2012


I'm scouring my old apps for an instance of when I did this, but there are
so many and it takes so much time to open and inspect them all. Here's my
requirement:

A form is in continuous mode.
A filter may or may not be applied to it.
A button invites the user to export the selected (filtered or not) data to
an XLS file.
A dialog opens asking the user to name and locate the output file.
Excel opens automatically, showing the saved file.

Anyone got an example for this? I'm going through ADH2K chapter by chapter
file looking for this, but so far have not located it. Unfortunately, I
think I gave the books away to Value Village, and all I have left is the
disk.

TIA,
-- 
Arthur

If I'd known I was going to live this long, I would have taken better care
of  myself.
- William Burroughs


More information about the AccessD mailing list