OutputTo form name change

[barrhaven01]

I would like to use the outputTo funtion to export form information as an Excel file. The problem is that I also want to run this same operation for 80 different offices, and the only file name it wants to out put to is that of the form. I tried using vb to change the caption to the form prior to the export, but that makes no difference in the default file name it tries to save as.

any suggestions??

[ChipR]

What is the code you are using specifically with the OutputTo function? Documentation I found said if you don't specify the output filename, it will prompt you for it.