Export Report Automated

[tomrector]

Thanks to your guys help, I now have a working report that "exports"
correctly, no blank lines.

However I do not want user to have to select File, Export, select
parameters, or enter file name.

So how do I automate selecting a report, have that report exported
(as right click on report, export), as MS-DOS, assign a
directory/file name, done without the user having to make a choice,
except select "Print Report"from switchboard.

report name is AClass file name is E:\class\Class.txt

Thanks
Tom Rector

 

[dneagle via AccessMonster.com]

Thanks to your guys help, I now have a working report that "exports"
correctly, no blank lines.

However I do not want user to have to select File, Export, select
parameters, or enter file name.

So how do I automate selecting a report, have that report exported
(as right click on report, export), as MS-DOS, assign a
directory/file name, done without the user having to make a choice,
except select "Print Report"from switchboard.

report name is AClass file name is E:\class\Class.txt

Thanks
Tom Rector

Export to where? And, if the user does not select the report to export, how
do you decide which report needs exporting?

 

[tomrector]

David,
Export the report to a text file on the E drive.
The user will select the report thru a switchboard menu item, (open
report).

I want the user to select options from a switchboard, the option would
open a report (named AClass). Then rather than have the user click on
"File", "Export", "Select file type as text" enter the file name to
save the export as ("E:\Class\Class.txt) , select format MSDOS, and
then OK, I am asking how to make all that happen with a macro or with
VB code.

Tom