To open excel file from the code...

[polina]

The user wants that after the data is being exported into the excel file, the file opens up automatically.

I export data using this code:

DoCmd.OutputTo acOutputTable, "Wbt_Orders", acFormatXLS, strDb & datExst & ".xls"


Please suggest if I could open excel file from the code?

Thanks

 

[CCIDBMNG]

Create a macro

you can create a macro using the output to as the action and then at the bottom select table as the object type, Wbt_Orders as the object name, for the output format choose excel and where it says auto start select YES. And place "DoCmd.RunMacro stDocName" where your other code used to be. stDocName is the name of your macro.