L L.A. Lawyer Dec 29, 2003 #1 I want to print the result of report (call it "Output.txt") to a txt file using VBA. How is that done?
I want to print the result of report (call it "Output.txt") to a txt file using VBA. How is that done?
F fredg Dec 29, 2003 #2 L.A. Lawyer said: I want to print the result of report (call it "Output.txt") to a txt file using VBA. How is that done? Click to expand... Look up the OutputTo method in VBA help: DoCmd.OutputTo acOutputReport, "TheReportName", acFormatTXT, "c:\YourPathHere\SomeName.txt" Check the different results using the various acFormat options: acFormatRTF, acFormatHTML, acFormatSNP, etc.
L.A. Lawyer said: I want to print the result of report (call it "Output.txt") to a txt file using VBA. How is that done? Click to expand... Look up the OutputTo method in VBA help: DoCmd.OutputTo acOutputReport, "TheReportName", acFormatTXT, "c:\YourPathHere\SomeName.txt" Check the different results using the various acFormat options: acFormatRTF, acFormatHTML, acFormatSNP, etc.
