filesystemobject

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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