hi,
i have macro that works on 2003, in run time, it opens an excel file, made
some changes and should save. i need the same macro to run on 2003 and 2007,
and save the file in .xls(in 2003) or .xlm(in 2007).
how should i recognize if i'm in 2007 or 2003 via the code?
and how should i re write the following code that was only for 2003:
ActiveSheet.SaveAs FileName:=ModelPath & "\" & "Service Request " & ".xls"
thanks,



--
Miri Tz.

> i have macro that works on 2003, in run time, it opens an excel file, made
> some changes and should save. i need the same macro to run on 2003 and
> 2007,
> and save the file in .xls(in 2003) or .xlm(in 2007).
> how should i recognize if i'm in 2007 or 2003 via the code?

If Application.Version = "11.0" Then
MsgBox "Using XL2003
ElseIf Application.Version = "12.0" Then
MsgBox "Using XL2007"
Else
MsgBox "Not using either XL2003 nor XL2007"
End If

Rick

Can I just use that to say if version 11 save as xls else if version save as
xlm (or xlsm?)?

"Rick Rothstein (MVP - VB)" wrote:

> > i have macro that works on 2003, in run time, it opens an excel file, made
> > some changes and should save. i need the same macro to run on 2003 and
> > 2007,
> > and save the file in .xls(in 2003) or .xlm(in 2007).
> > how should i recognize if i'm in 2007 or 2003 via the code?
>
> If Application.Version = "11.0" Then
> MsgBox "Using XL2003
> ElseIf Application.Version = "12.0" Then
> MsgBox "Using XL2007"
> Else
> MsgBox "Not using either XL2003 nor XL2007"
> End If
>
> Rick
>
>

Hi Debbie

See
http://www.rondebruin.nl/saveas.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Debbie Horner" <(E-Mail Removed)> wrote in message news:6F84ED5E-E16F-4DFC-AFDE-(E-Mail Removed)...
> Can I just use that to say if version 11 save as xls else if version save as
> xlm (or xlsm?)?
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> > i have macro that works on 2003, in run time, it opens an excel file, made
>> > some changes and should save. i need the same macro to run on 2003 and
>> > 2007,
>> > and save the file in .xls(in 2003) or .xlm(in 2007).
>> > how should i recognize if i'm in 2007 or 2003 via the code?
>>
>> If Application.Version = "11.0" Then
>> MsgBox "Using XL2003
>> ElseIf Application.Version = "12.0" Then
>> MsgBox "Using XL2007"
>> Else
>> MsgBox "Not using either XL2003 nor XL2007"
>> End If
>>
>> Rick
>>
>>