New Workbook through VBA
 

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

New Workbook through VBA
 

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

New Workbook through VBA
 

The syntax is correct. My guess is that your FileNameArray(index) argument
is the issue. It needs to return a string filename such as "MyFile.xls" or
"C:\Temp\MyFile.xls". If not, the DoCmd will fail.

Simple code...
index = 1
FileNameArray(index)="MyFile.xls"
DoCmd.OutputTo acOutputTable, "TBL_USERS", acFormatXLS, FileNameArray(index)

HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.


"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