Export Report Automated

  • Thread starter Thread starter tomrector
  • Start date Start date
T

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
 
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
Click to expand...
Export to where? And, if the user does not select the report to export, how
do you decide which report needs exporting?
 
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
 
Back
Top