converting

[jarrett]

Not to happy about this. Client has four agencies out of 400 that are using
Excel version 2.1. I am e-mailing wages in a excel spreadsheet to the agencies
in a newer version. To make a long story short I need to convert the newer
versions of excel to 2.1. I am not sure how to do this. Copy to will not
work and if I save as xls it saves as the newest version on that machine.
I know 5 can be saved as .Xl5.

[Nancy Folsom]

On 1 Mar 2002 14:04:30 -0800, "jarrett" <cooley222@excite.com> wrote:

>
> Not to happy about this. Client has four agencies out of 400 that are using
> Excel version 2.1. I am e-mailing wages in a excel spreadsheet to the agencies
> in a newer version. To make a long story short I need to convert the newer
> versions of excel to 2.1. I am not sure how to do this. Copy to will not
> work and if I save as xls it saves as the newest version on that machine.
> I know 5 can be saved as .Xl5.

Could you sent it as a CSV file and have the other end import it? (I
don't know if 2.1 can import CSV but I'd sure guess it might).

IOW, use an intermediate format that both ends can use.

[jarrett]

>Could you sent it as a CSV file and have the other end import it? (I
>don't know if 2.1 can import CSV but I'd sure guess it might).
>
>IOW, use an intermediate format that both ends can use.
**** Good Idea ****

The only thing we want them to do is open from their e-mail punch their
wages and send them back. The worksheet is formatted so importing will not
work. Does anyone know where I can find the code for the copy to? I am sure
it is using Excel's save as, but that will work to.

[Wolfgang Schmale]

Hi Jarrett!

Try this to save the actual sheet of the excel workbook
#define co_xlExcel2 16
xlApp=createobject("Excel.Application")
XLApp.Visible = .t. && not necessary
cd "myPathToOriginal"
XLApp.WorkBooks.open("myPathToOriginal\File.XLS")
XLSheet = XLApp.activeWorkbook
xlSheet.SaveAs ("myPathToConvertedFile\Version21WS.xls", co_xlExcel2, "","",
..f.)
xlApp.quit()

hth

--


Mit freundliche Grüßen aus der Zigarrenstadt Bünde

Wolfgang



"jarrett" <cooley222@excite.com> schrieb im Newsbeitrag
news:3c837ef4$1@10.1.10.29...
>
>
> >Could you sent it as a CSV file and have the other end import it? (I
> >don't know if 2.1 can import CSV but I'd sure guess it might).
> >
> >IOW, use an intermediate format that both ends can use.
> **** Good Idea ****
>
> The only thing we want them to do is open from their e-mail punch their
> wages and send them back. The worksheet is formatted so importing will not
> work. Does anyone know where I can find the code for the copy to? I am
sure
> it is using Excel's save as, but that will work to.
>