Scaning folder to create worksheets

[tazz]

Hello all,

It is possible for Excel to create automatic worksheets from files that are in the same folder with an workbook?
In folder “Drawings” I have drawings with extension (.dwg) and an excel Workbook named “GeneralData”. I would like this workbook to create a worksheet with the name of the drawing every time a dwg is created. I use excel 2010.

Thank you for your help.

 

[SirJB7]

Hi, tazz!
Excel can't monitor what Autocad does.
Regards!

 

[tazz]

To be more specific, I don't want excel to look inside the drawing. Only to scan the file name.
Thanks

 

[SirJB7]

Hi, tazz!

It is possible for Excel to create automatic worksheets from files that are in the same folder with an workbook?

Yes, this can be done.

In folder “Drawings” I have drawings with extension (.dwg) and an excel Workbook named “GeneralData”. I would like this workbook to create a worksheet with the name of the drawing every time a dwg is created. I use excel 2010.

(bold is mine)... No, this can't be done, and my previous comment was referred to the file creation from Autocad (or whatever software).
Regards!

 

[tazz]

Thank you for reply.

 

[SirJB7]

Hi, tazz!
What you can do is run a macro, scheduled or manually, to walk thru the folders and update the list of .dwg files, that's the best approach (1st quote).
Give a look at this for folder recursive procedures, maybe you can extract something useful from there:
http://chandoo.org/forum/threads/folders-files-matching.6312
http://chandoo.org/forum/threads/excel-files-documenting-inspector.4715/
Regards!

 

[GFC]

Maybe you want to have a look at
http://www.extendoffice.com/documents/excel/627-excel-list-files.html

 

[Marc L]

Hello !​

I would like this workbook to create a worksheet with the name of the drawing every time a dwg is created.

Possible to list the .dwg files at manual launch or at the opening of a workbook for example …​

 

[tazz]

Thank you for your tip.