>>>>Hello,
>>>>
>>>>Can anyone refer me to where I can find more information on what the passing parameters are for opening files in Excel? For example, oExcel.Workbooks.Open(lcXLSfile,?,?,?,?,?,?, etc...?)
>>>>
>>>>TIA...
>>>
>>>Dodi,
>>>
>>>
>>>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/xlmthOpen.asp>>
>>Thanks.
>>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/xlmthOpen.asp>>
>>Says that txtCodePage is not used in English Excel. It would be nice if we can just specify code page.
>
>I don't find any ref to txtCodePage. What do you mean ?
SaveAs Method
Saves changes to the sheet (Syntax 1) or workbook (Syntax 2) in a different file.
Syntax 1
expression.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AddToMru, TextCodePage, TextVisualLayout)
Syntax 2
expression.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodePage, TextVisualLayout)
If it's not broken, fix it until it is.
My Blog