Simple Macro's

[Nathan]

Hi,

I need some help creating 2 excel macros.

Macro 1: Convert an Excel spreadsheet held on an NT Server
from "normal" XLS format to CSV format via an Excel macro

Macro 2: Convert the CSV file back to XLS format via an
Excel macro

Any help would be great
Ta very much
Nath

 

[Bob Greenblatt]

Hi,

I need some help creating 2 excel macros.

Macro 1: Convert an Excel spreadsheet held on an NT Server
from "normal" XLS format to CSV format via an Excel macro

Macro 2: Convert the CSV file back to XLS format via an
Excel macro

Any help would be great
Ta very much
Nath

You can't actually convert the file, but you can save the file as a csv
file. Then I guess if you want you can delete the original.

To save as CSV: workbooks("whateveritsnameis.xls").saveas _
filename:=path\newname.csv fileformat:=xlcsv

To save the file as a normal Excel workbook: workbooks("name.csv").saveas _
filename:=path\newname.xls fileformat:=xlnormal