| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
| Setting character attributes in a text string | Excel Worksheet Functions | |||
| Setting attributes for controls | Excel Programming | |||
| Windows versions diff | Excel Programming | |||
| setting procedure attributes | Excel Programming | |||
![John Robinson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
