folder structure

  1. L

    Macro to create folders in various locations based on cell values

    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...
  2. S

    Jagged columns from file & folder totals

    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...
  3. M

    MACRO - Check/Create Folder Structure And Save

    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...
  4. F

    Update existing hyperlinks automatically when changing the folder name linked documents are saved under

    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...
  5. B

    Backup of Excel reports.

    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...
  6. G

    Can someone Check My Code, it works but...

    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...

Some videos you may like

This Week's Hot Topics

Top