Ali

It's almost always because the path to the file is invalid. The use of the
array should not be causing a problem. When you get the error, open the
Debug window and type

?Dir(FileNameArray(index))

If you get an empty string, the path isn't right.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Tj wrote:
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