View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David P[_3_] David P[_3_] is offline
external usenet poster
 
Posts: 1
Default Accessing file extensions

Hi All,
I have a workbook containing a dozen or so macro's that i
need to distribute to around 220 people.
The macro's run OK, only if people have the "Hide file
extensions for know file types" dis-abled.
Is there any coding, that i can put into, say a WorkBook
Open event, that can change this setting on each machine?
(I know i could just tell people to turn it off, but many
either can't(due to other macros), won't, or have no idea
what i'd be talking about.)
I've had a look at FileSystemObject, but i dont think that
change this option.

Any coding assistance would be greatly appreciated.

Thanks