fso

I have a set of code written to update some cells in a number of excel files that all share the same general format. I am able to get this code to work on all files within a folder but we literally have a directory of hundreds of subfolders organizing our files. I need to be able to loop...

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

【Question#1】 Suppose I create a Excel File to get other ten file record together by a folder. I want user dynamic to give Excel file a path by some method. The first thinking jump out my mine is via inputbox. but I try several time , application.inputbox("Pls paste a file path !", type:=2) ...

I have a folder with 5-6 workbooks and each workbook has multiple worksheets. I am trying a code to loop through the sheets in each workbook in that folder (which ever is selected on running the macro) copying the data from B:H and pasting the data in Mastersheet with Sheet1 name as...

First of all, want to greet all of you at MRExcel community. Your posts and solutions have been a great help to me over the last few yeary, so I want to thank you all! :) I'm not new to VBA but using FSO is little new to me so maybe i'm doing something wrong. And now the problem. I can't...

Please help with solving a macro. I need a routine that will list all Excel files in a specific folder, but exclude the ones that begin with the word "Old". If push comes to shove, I could simply list all files, then use Excel's filtering functionality to accomplish, but I am trying to avoid...

Afternoon all, I have been searching for a way of moving folders (& contents) via an excel macro. The folders are all in the same directory that the excel file is in and I want to make certain folders move to a "removed" folder that is in the same parent directory. The issue I am having is that...

Hi, I am unsuccessfully trying to use a function to return the date modified with the below Sub AKAname. Perhaps I should rename some variable names, but I'm not really sure if that is right, or how to streamline the Function LastModified with the Sub AKAname (listed below). Any help is much...

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

Can someone post code for the following? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Seeking program (script) that would: · Open each Excel file (.xlsb) in a designated folder · Save each · Close each Note: Needs to work even as folder content change...

Hello, I'm using the below code that I copied from another existing workbook, which automatically creates a pdf. file and generates an email in outlook express. It works perfectly on the existing workbook, but when I tried to copy it across to another workbook (changed relevant names) and ran...

I've got a folder full of drawings, over 70,000 of them. They are all drawings in PDF format with the part number as the name. Sometimes. There are half a dozen different ways the files are stored, all with the first 7 chars being the part number, say 12345678.pdf Many of the files do not...

Hi All I am struggling to find methods to delete specific rows and columns from a text file. I have a text file and I would like to create another text file based on the data within. I would like to build a function to delete multiple rows from the text file {1;2;3;4;5;6;7;8;9;11}. I would...