Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.scripting.vbscript,microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Folder Author/Administrator

Hi

In windows explorer you can change the columns that are displayed so that
you can display more data than Filename, Size Modified Date and File Type.

If you select the View menu and Choose Details. Then you can selected Owner
and the Author fields. This gives you information about who created that
folder or file.

I need to return a folder listing to a spreadsheet. I can do this with no
problems by an having a problem getting information about both the Owner and
Author Columns.

I am sorry for cross posting but i was told that VBScript could be used but
I would like the data displayed by default in Excel.
  #2   Report Post  
Posted to microsoft.public.scripting.vbscript,microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Folder Author/Administrator

You can use script in Excel in conjunction with VBA.

http://www.microsoft.com/technet/scr....mspx?mfr=true

the sample code should work in Excel vba. Just modify it to place the
results in the appropriate cells.

--
Regards,
Tom Ogilvy




"DMc2004" wrote:

Hi

In windows explorer you can change the columns that are displayed so that
you can display more data than Filename, Size Modified Date and File Type.

If you select the View menu and Choose Details. Then you can selected Owner
and the Author fields. This gives you information about who created that
folder or file.

I need to return a folder listing to a spreadsheet. I can do this with no
problems by an having a problem getting information about both the Owner and
Author Columns.

I am sorry for cross posting but i was told that VBScript could be used but
I would like the data displayed by default in Excel.

Reply
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
How do I tell Excel that I am the administrator? Kevin Excel Discussion (Misc queries) 2 August 15th 09 12:20 AM
Administrator Not2Smart New Users to Excel 1 October 1st 08 06:41 PM
Administrator rights whatzzup Excel Discussion (Misc queries) 3 September 22nd 08 02:52 PM
Save file in a new folder, but create folder only if folder doesn't already exist? nbaj2k[_40_] Excel Programming 6 August 11th 06 08:41 PM
I do not have access to a folder and I am the administrator how d. bocathunder Excel Discussion (Misc queries) 4 January 22nd 05 10:53 PM


All times are GMT +1. The time now is 05:01 PM.

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

About Us

"It's about Microsoft Excel"