I am working for a company where we send out a lot of documents to suppliers and etc. All of this is saved in folders like (C:\Transmittals\Company name\transmittalXXX\transmittalXXX.pdf). As this becomes a lot of work typing in manually, I want to create a macro that does it for me.
However, it's been several years since last time I did any programming and now all I can get is "File name" and "Date created". Another problem is that within these folders, the drawings/documents sent with the transmittal are there as well. I don't want these to be listed in the excel sheet.
Can anyone help me with this?
The information I want in the excel sheet is:
Column A: Company name
Column B: Date Created
Column C: Transmittal number(XXX)
Column D: Transmittal name (their filename will be (0183-XXX "company name") without file extension.
and if possible
Column E, F, G, H...: Other documents in the folder, but without the file extension.
The script will be repeated many times so including a "clear" command in the beginning might be a good idea.
Help would be much appreciated!!!
Best regards
Andreas
However, it's been several years since last time I did any programming and now all I can get is "File name" and "Date created". Another problem is that within these folders, the drawings/documents sent with the transmittal are there as well. I don't want these to be listed in the excel sheet.
Can anyone help me with this?
The information I want in the excel sheet is:
Column A: Company name
Column B: Date Created
Column C: Transmittal number(XXX)
Column D: Transmittal name (their filename will be (0183-XXX "company name") without file extension.
and if possible
Column E, F, G, H...: Other documents in the folder, but without the file extension.
The script will be repeated many times so including a "clear" command in the beginning might be a good idea.
Help would be much appreciated!!!
Best regards
Andreas