Jump to content
Macro Express Forums

Capturing each Files Information


johnboy691
 Share

Recommended Posts

I've tried reading the book, previous posts and either it's not clicking and/or I'm just to dense....maybe someone can help me.

 

I want a macro to capture the file name, extension and path to a ALL files say in My Documents. I know the path to My Documents, but how do I get the macro to capture all information for EACH file in My Documents? I want to capture it, in variables, then put it into an excel file.

 

Any ideas would be greatly appreciated.

Link to comment
Share on other sites

Here is something to start with:

// All the macro commands inside the 'Repeat with Folder' will run for each file in the specified folder
Repeat with Folder
 // Here: T1 will contain the file name.
Repeat End

<REM2:All the macro commands inside the 'Repeat with Folder' will run for each file in the specified folder><REP3:07:000001:000001:0001:0:01:C:\Documents and Settings\Kevin Heaton\My Documents><REM2:Here: T1 will contain the file name.><ENDREP>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...