Recent content by reillj

Figured it out. real easy. just added a ':' and it works. Thanks for all the help; i never would have used the 6 if not for you guys.

No, just tried it; "SaveAs method of workbook class failed"

Thanks Bob. So should I explicitly set the value to 6? or do i need to declare this earlier?

Sorry for the lack of specifics, didn't want to bore anyone :) The export to the xls file works fine; I am making a copy of the template, saving it as the correct name, and copying the data from the temp file into the new xls file. the CSV says that it is working, but when I try to open it as...

Thanks for replying; I am exporting the data to a temp file and copying it to a template file via the excel automation. The header on the template is kind of weird, and unfortunately it has to be in there. I thought the easier thing to do was to get the exported data into the correct format...

Hello, I am exporting individual xls files out of my access database, and during the process i would like to also save a copy as a csv file. every time i run the code shown below it incorrectly exports the csv. any help would be appreciated, thanks. the code that is not working is bolded.