1. O

    Move to next empty row when copying from next subfolder

    Hello, I have the below code that is copying specific cells from excel files in a directory of subfolders, however each time it moves to a new subfolder, it copies over the data from the files in the previous subfolders. How would I get the code to always find the next empty row in the...
  2. O

    Extract Specific cell data from Worksbooks in all subfolders

    Hello, I need some help getting specific cell information into my report worksheet from all excel files in the folder and all subfolders. I have managed to get the code to open all the files in the directory but whenever I try to extract the cell information I get an error. I am wanting it to...
  3. M

    Last row variable not incrementing because For Loop is not populating the table.

    Why does my code run without errors and loop through the files in the selected folder, as planned, but the values from the source workbooks don't display in the summary table (table remains blank). Because no text is displayed in the summary table, the "find last row" variable (y) does not...
  4. wsnyder

    Get PDF Page Count

    Hi all, Trying to get page count for all pdf files. My current code at the bottom. Error here : Error message: I set references to all of these libraries I see available that appear to be Adobe related libraries: Acrobat Access 3.0 Type Library Adobe Acrobat Browser Control Type Library 1.0...
  5. J

    How do I ignore hidden files?

    Hi, I currently have the below code to pull a list from a file path every time the worksheet is activated. Sub worksheet_Activate() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder =...
  6. M

    VBA Excel find a file (partial file name) in a set of folders (doesn't return a value and doesn't exit function)

    Good Morning/Afternoon/Evening, I'm normally ok with VBA in Excel but i'm really struggling to understand what I have done wrong here. My end goal is to search for a file (using only the first part of the file name) in a set of folders and then send back to the calling function the full file...
  7. S

    Fast file search for most recently modified file

    Greetings, I recently threw together a bit of code that parses text from the most recently modified file in a selected folder. However, the folder keeps track of job tickets at my work, and it can fill up fairly quickly. Right now, 889 .txt files are in the folder to be searched. I have...
  8. E

    Using Excel VBA to copy one file and save it under a different folder with a different name

    Guys, I want to automate a redundant task that I do every day as a part of my work. Let's say I have a file with a standard name in a Source location, then I have a destination location. I want to copy this one file and save it as let's say 10 files with different names from an excel...
  9. M

    VBA Memory Leak?

    Hi All, Im not sure if I can attach the whole file as an example but I have described my VBA setup below. Any VBA help to identify and correct my memory usage issues would be greatly appreciated! I have a SharePoint site that has hundreds of Excel files stored on it and I interact with them...
  10. B

    where did the files move to?

    I recently made an error, and have found it repeatable in several formats. It happens when renaming file(s) using Excel's hidden method "Name", or Scripting.FileSystemObject's MoveFile, to name a few. When you rename and specify only a destination filename without path, the file(s) simply...
  11. P

    FileSystemObject Error 53 File Not Found

    Hi All, First I would like to say I am blown away by the support and learning I have received since I joined thank you! Second I had this running until today I received the error Original code below this Structure That worked until a user loaded a File name 293 characters Long as they are...
  12. E

    How Can I Only Open Text (.txt) Files When Working With FSO? (FileSystemObject)

    Currently have a working script that uses FSO, but it also opens .xlsm files within my working directory. I would like to to only open .txt files. I found this code that should work, however I can't figure out how to apply it to my situation: Sub test() ' Loop thru all files in the folder...
  13. B

    Change Characterset (Codepage), Scripting.Filesystemobject

    Hi All I've found this code and it's working fine. The function get the last recent (newest) file from a specified folder with a search string. Everything is working fine, but: if a folder contains special character (German, ä, ö, or ü) I get an exception "folder not found" while setting > Set...
  14. V

    List all files in server or folder using Dir

    Hi Excel Experts, This is my first post and sorry if there are any mistakes or not conform to rules while asking question. I thank everyone for making this forum a general one as many people can view the questions and learn excel. I work in excel and I want to extend the discussions of the 2...
  15. trishcollins

    Looping through all folders and subfolders in a drive and listing files

    I need to be able to list all files in all folders and subfolders in a particular drive (I use this macro to populate three different tables depending on the drive, so thus the mytbl and myPath variables. I also have it set to use a named range to determine whether or not to include...
  16. C

    Subfolders collection of FilesystemObject has a count

    Subfolders collection of FilesystemObject has a count but you can't reference it? Subfolders.Count = 12 prefect Folder.Subfolders(11) not allowed - errors Error 5 Invalid procedure call or argument likewise Folder.subfolders.Item(X) Is the Count of any use other than to tell how many there are?
  17. J

    Get last folder from .subfolder return (folders collection)

    I'm trying to find a way to get the last subfolder in a folder object without out using a “For Each” Loop. It seems to me that if the Folders Collection is stored in the memory so that in can be accessed through iteration, than there has to be a way to simply call one without looping through. I...
  18. G

    Problems with FSO.MoveFolder / DeleteFolder. Can't delete

    I have a spreadsheet and some associated documents in a folder and I want to move them into another folder with a macro. I quickly found out I could not use FSO.MoveFolder on the folder containing the excel sheet running the macro (It should have been obvious!). So I opted to saveAs the excel...
  19. S

    FileSystemObject Intellisense

    How can I get the intellisense to show up when working with the FileSystemObject? I went to tools->References and checked the box to include "Microsoft Scripting Runtime". I only need to include it in the references correct? I created a FSO and then tried doing FSO. and no methods or...
  20. J

    Recursive search in nested folders/subfolders and then open file

    Hello, I have been searching for a solution to a problem for quite some times now, and I was hoping one of you have a great idea in this forum. I first like to appreciate any help and any reply to my problem. My problem is, I have an excel macro that does multiple thing for a report purpose...

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