Thread: Excel Versions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default Excel Versions

Sounds like you do not a licensed copy of the software or it is a demo
version?

Try running; this following code

MsgBox Application.Version

Then look up the resulting version number in the following reference

http://www.cpearson.com/excel/versions.htm

--

Regards,
Nigel




"kirkm" wrote in message ...
I sent a friend an xls to help him do some stuff and we had all kinds
of problems as it's a later version.

Can't determine the version as there's no Help -About to see what it
is. There's also no File -Save option.

He did manage to get macro's working but it took 3 days. Again no
Tools menu.

Is there something to describe where these things have gone or what
they're now called?

Also, can you create an xls which will enable macros automatically -
and how do you set a 'Trusted Source' assuming it's still in the later
version ?

Thanks - Kirk