getfolder

  1. F

    Adobe XFDF to Excel VBA

    Good Afternoon, I'm using the following code to scan a folder of all *.XFDF files and inport the results in excel. The macro works on a single file, but will not work in a loop. I'm open to suggestions. Thanks. Sub GetFormData() Dim XDoc As MSXML2.DOMDocument Dim xEmpDetails As...
  2. M

    Extracting data in Word textboxes to Excel

    Hello, I have a large amount of word documents (1000+) that have data stored in textboxes. I need to extract this data to individual cells in excel. Ideally, each word document would be recorded with a hyperlink to its path and a line for each data entry. I have found the following code written...
  3. M

    Word Form Data to Excel Worksheet

    I see some old post to this for table data, but not form data. I also have tried some of the internet solutions, the "closest solution" I saw for macro to do what I wanted was as follows, and for some unknown reason to me , its not working? Error message is "Run-time Error '438': Object...
  4. C

    VBA loop to get data from files - need speed improvement

    Hey everyone. This is the first time I've written something that goes out onto a server and pulls data from multiple files. Basically I have multiple file folders, over 130, that may or may not have a sub-dir that is called "restatement reports" where inside that sub-dir multiple excel files...
  5. V

    Code explanation

    FolderLoc = FolderLoc & "" & "Jan" & ". " & Year 'Inside the Folderloc there are ten's of file and each and every files has atleast three more files in it. Set FSobj = CreateObject("Scripting.FileSystemObject") Set ProjectsFolderObj = FSobj.GetFolder(FolderLoc) For Each BCFolderObj In...
  6. trishcollins

    Populating a table with a list of all folders and subfolders

    Okay, I have managed to almost get this cracked, but currently I am only getting the immediate subfolder names. I am trying to figure out how to get all the subfolder and their subfolder names into a list, so it can be used in a drop down menu on another sheet, so someone can generate a list of...
  7. O

    Textbox.text to .getfolder(Path)

    Hi, makro2 is my folders name. i want to replace the folders' name every time when i write a folder name (only folder name / the folders will be inside the same path) in a textbox on the sheet. For example: If i write Nov-12 to textbox the red lighted part will be Nov-12, if I write Oct-12 to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top