LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default File Attributes

Hi,

I am using the FileSystemObject to get a file (objImage), and need to
determine whether is has both its Hidden and System attributes set.
Help says :

To determine which attributes are set, use the And operator to perform
a bitwise comparison (a bit-by-bit comparison between identically
positioned bits in two numeric expressions) of the value returned by
the Attributes function and the value of the individual file attribute
you want. If the result is not zero, that attribute is set for the
named file.

OK. So can someone please help me understand why the first 2 work, but
the last 2 don't?!

If objImage.Attributes And vbHidden Then MsgBox "vbHidden"

If objImage.Attributes And vbSystem Then MsgBox "vbSystem"

If objImage.Attributes And vbHidden And _
objImage.Attributes And vbSystem Then MsgBox "vbHidden &
vbSystem"

If objImage.Attributes And vbHidden = vbHidden And _
objImage.Attributes And vbSystem = vbSystem Then MsgBox
"vbHidden & vbSystem"

Any guidance is much appreciated!

Cheers,

Mark

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data value display attributes linked to table attributes MDT at Paragon Home Inspections, LLC Charts and Charting in Excel 0 November 15th 06 12:53 AM
Getting NTFS file attributes Kiran Excel Discussion (Misc queries) 1 August 4th 05 08:13 PM
Filecopy, file attributes Eric[_28_] Excel Programming 1 February 24th 05 01:31 PM
File Attributes dsti3 Excel Discussion (Misc queries) 1 February 10th 05 05:51 AM
file attributes via macro SUNIL Excel Programming 2 January 14th 04 09:43 AM


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"