Setting File Attributes and Windows versions
 

I am having trouble with a routine in Excel vba on Windows 2000
machines. I reset the attributes of the files I want to hide to
vbHidden, using SetAttr, before opening the getopenfile dialogue box(
special filtering means I can't use the file filter in this). It works
well on everything except win 2000 where it takes 30 seconds as
against 0.7 sec in 98 and XP. Any offers? Is it possible to tell which
version of windows is running using excel vba.
Thanks for any help
John Robinson

Setting File Attributes and Windows versions
 

After doing a search using google I found this site that looks like i
has what you are after

http://www.oreillynet.com/pub/a/orei...sions_0899.htm

--
Message posted from http://www.ExcelForum.com

Setting File Attributes and Windows versions
 

Possibly

? application.OperatingSystem
Windows (32-bit) 4.10

--
Regards,
Tom Ogilvy


"John Robinson" wrote in message
om...
I am having trouble with a routine in Excel vba on Windows 2000
machines. I reset the attributes of the files I want to hide to
vbHidden, using SetAttr, before opening the getopenfile dialogue box(
special filtering means I can't use the file filter in this). It works
well on everything except win 2000 where it takes 30 seconds as
against 0.7 sec in 98 and XP. Any offers? Is it possible to tell which
version of windows is running using excel vba.
Thanks for any help
John Robinson