-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
strfolder
-
Converting all files that can be read by MS Word into TXT files
The goal is to convert any file that can be read by MS Word and convert it directly (and hopefully quickly) into a text file. I swear I had this working at one point but it's certainly not working anymore. I don't recall where I got the text in blue, but I don't know if I have the syntax wrong...- Dr. Demento
- Thread
- dim strfolder string var variant
- Replies: 1
- Forum: Excel Questions
-
I
Cannot make this script work!!!!!
Good Saturday to everyone! I have been trying to tweak this script for days, but I am no expert. This script automatically kicks in every time the main Excel file is closed. It should: 1 - Export a sheet called "Master" from the closing Excel file by creating a new one called Master(Progressive...- iRobert
- Thread
- dim masters script strfile strfolder
- Replies: 2
- Forum: Excel Questions
-
G
VBA Recursive Folder search for specific Folder and File combo
Hi I'm trying to find a set of files that contain data I want to manipulate. End goal is to collate all the data from each file matching my criteria. However, I'm struggling at the moment as the function I'm using to search is crashing out. I believe that it's failing due to either a file...- Gojira
- Thread
- debug.print dim end strfolder strtemp
- Replies: 5
- Forum: Excel Questions
-
A
VBA to Combine Differently Formatted Word Files into 1 while Preserving Layouts
Dear Mr. Excel, Would like to request your kind assistance on my codes below... I have codes that will allow me to select multiple files and combine them into 1 Word (then exports into 1 PDF). Problem is: Headers/Footers: The header/footer from the first file is used for the entire combined...- agent_maxine
- Thread
- dim file set strfolder word
- Replies: 18
- Forum: General Discussion & Other Applications
-
Renaming Userform within VBA
Ok so I'm working to launch a subroutine from one workbook (Test2), then have it open another workbook (Test1) and replace a module and userform on Test2 with a module and userform from Test1. I got the module part to work but I'm having trouble with the Userform. Probably because of where and...- Roderick_E
- Thread
- dim function strfolder userform workbook
- Replies: 9
- Forum: Excel Questions
