saved Imports

[DaRTHY]

Hello Friends,

I need a macro to use it Saved Imports.

I created new button and i need to write there a macro to run saved Import Excel Data. But i do not know which macro shall i use...

and 2. thing, after import the data i need to actual date. and for this i created text box but again i do not know how shall i do that.

Can you help me please.

Thanks

 

[namliam]

Yet, to import excel sheets, you do need DoCmd.TransferSpreadsheet....

 

[DaRTHY]

Thanks for your answer. But it wasnt what i needed. I found my solution for first question:

"RunSavedImportExport" it works perfectly.