Save As FileFormat Question

[wjsullivan]

I have been looking here and throught the excel helpfile for the command that is the equivalent of Save As using FileFormat = Current Excel version.

I already have sucessfully used CSV, xlExcel5, xlNormal, xlExcel9795 in this file. My concern is that if I save a CSV and then try and save using xlNormal, that xlNormal will refer to CSV and thus I will get another CSV and not an Excel XP/2002 file.

wbTemp.SaveAs Filename:=rExportFile, FileFormat:=??? for Excel XP/2002?

 

[BrainB]

Seems a strange question because all you need to do is to do the Save As when you will find it will do what you want.


Regards
BrianB
Use CupOfCoffee to speed up all windows applications.
It is easy until you know how.
================================

 

[PHV]

Has rExportFile a .xls extension ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wjsullivan]

rExportFile has an .xls extension as it was just created as a blank workbook and then data was copied to it. So if I xlNormal to the new book I should be ok because it will be in the current excel format?