folder structure

Hi All Real excel novice here! I need a macro to create folders based on a cell value (A4:A10), this value is the "job reference". This folder needs to be created in locations based on other values within the spreadsheet. These values are: Region (EU or Non-EU) Country (China, France...

I have a powershell script that I run to produce a folder listing & size file text file. I give it a root folder to start in & it goes thru each folder recursively summing up the file sizes within the folder. The end result is like this: Myfolder|5800 Bin|1800 |de|40000 |en|50000...

Hi I had previously posted something about this but I am still having problems, I am a novice with Macros. I have an Excel spreadsheet that I need to save via a Macro, however, I need it to be saved in a specific location, which is compiled in a Cell in Excel I.e. D5 - returning the following...

Dear Forum members,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am desperately looking for some advice from you Excel experts!<o:p></o:p> At work we are using an excel spreadsheet as a project checklist during the project execution phase...

Hi, i currently have a macro that goes though several folders, opens each spreadsheet and saves it as a .xlt to a location as well as .xls to another location. the problem i'm having is its only going through 1 layer of folders. Folder 1 Folder2 Folder3 Folder4 and Folder 2 might have another...

I'm trying to produce a folder hierachy in Excel showing all Folders & Files, in exactly the same order Windows Explorer would. My Code brings the Folders & Files back, but not in the exact order (it puts the files in a root folder first, rather than at the bottom of the list) and I also want to...