This works but I am having a lot of problems with the output.
the input file has 470 variables in a csv file so I can't use 2003.
but the only thing I can get is an xls file with the first 255
variables ....

I thought maybe a direct path to the 2007 install would help but it is
still saving as a 2003 output xls file
changing the extension to xlsx only makes the save not open becasue of
incorrect naming.

how can I make this save as a full xlsx file with all of the
variables?

thanks for any help I am stumped.

NOT SURE ABOUT THE PATH
it runs but like I said I only get xls type of output so I don't know
if 2003 or 2007 is running...how do I tell?



Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object

oXLPath = """C:\Program Files\Microsoft Office\Office12"" " &
"/automation -Embedding"

Set oExcel = CreateObject("Excel.Application")

Set oBook = oExcel.Workbooks.Open("C:\20pagetest.csv")
Debug.Print xlCurrentPlatformText

oBook.SaveAs "c:\booktest.xlsx", xlWorkbookNormal

oExcel.Quit