saving a READ ONLY file

[vzachin]

hi
i have a read-only file that i'm trying to save but i'm getting an error message
"object value is set to nothing"

        Dim xl As Object, xl_workbook As Object, xl_sheet As Object
        Set xl = CreateObject("excel.application")
        xl.Visible = True
        xl.Workbooks.Open Filename:="xxx.CSV"
        [blue]xl_Workbook.saveas "C:\TestFile\test.xls"[/blue]

any ideas?

thanks
zach

 

[SkipVought]

Zach,

Why not write this procedure in Excel VBA?

I would not OPEN a .csv file directly.

Rather, I would IMPORT into an empty sheet in a workbook, using Data > Import External Data....

You will have much more control over PARSING the data properly, especially if you have dates, or text columns containing some numbers.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}