Hi,

I was wondering if anyone can guide me on how create a new workbook from
Access for excel using VBA.

I tried the following, but it gives me an error: Run Time error - 2302 -
Microsoft Access can't save the output data to the file you've selected

DoCmd.OutputTo acOutputTable, "TBL_USERS", acFormatXLS, FileNameArray(index)

FileNameArray is an array with the names of the file. Initially i thought
the array could be empty, but it isn't.

Will appreciate an idea, or an alternate code that might be helpful.

Thanks,

Ali