Full Version: Saved Export Prompt Window
UtterAccess Discussion Forums > Microsoft® Access > Access Macros
tomfernandez12004
Greetings Gurus!

I have a SavedExport that I want to execute and bypass the SavedExport window. Is there a Macro for acheiving this? I had seen a Macro for running a SavedExport and wondered if I change the Macro to VBA, perhaps I could insert code to bypass the SavedExport window/prompts..

What do you think? I really appreciate your responses!

-Tommy
accesshawaii
Hi Tommy,

I'm not sure exactly what you're trying to do but if it's a matter of some data being exported to something like a spreadsheet and you don't want the prompts, you would just do some VBA like the below in a button's on click event.

CODE
DoCmd.TransferSpreadsheet acExport, , "YourTableorQuery", "C:\YourFolder\YourFile.xls"


This is just a real basic example.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.