Get Window Text

[giddyhead]

Hi everyone,

Please help! I want to find a way to grab the text from the window that shows the location of the file using vba in Access. A picture was uploaded for reference. Thanks in advance.

Thanks

 

[pr2-eugin]

So what have you done so far? Used a FileDialog object?

 

[giddyhead]

Pr2-eugin,

This is what I used

DoCmd.OutputTo acOutputReport, "RESPAY PERSONEL FILE TRACKER", "", "", False, "", 0, acExportQualityPrint

and the attachment shows the box that comes up. I want to be able to allow the user to pick a location and want to ask them if they want to open up the file after export. THanks

 

[vbaInet]

The answer is here...

Used a FileDialog object?