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

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top