Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.scripting.vbscript,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.scripting.vbscript,microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I tell Excel that I am the administrator? | Excel Discussion (Misc queries) | |||
Administrator | New Users to Excel | |||
Administrator rights | Excel Discussion (Misc queries) | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
I do not have access to a folder and I am the administrator how d. | Excel Discussion (Misc queries) |