-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
objwb.name
-
A
Issue Opening Multiple Workbooks in Folder using Loop and FileSystemObject
Hello all, I have a macro that uses a For Each loop and a FileSystemObject to open six files that are placed in a certain folder. The names of the files are similar, except for a number at the end of the filename. For example, Alex Report - 104 Alex Report - 105 Alex Report - 106 Alex Report...- AlexB123
- Thread
- Replies: 5
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Unprotecting a sheet once a text box is selected
- Started by dpaton05
- Replies: 49
Can you unprotect a sheet once a text box is selected and then reprotect it again when it is unselected? I do not want to use active x text... -
OFFSET function with multiple table
- Started by xdenama
- Replies: 43
I have 100++ sheet (table) with same format with difference high (total row not fix, will change). How to combine all table (sheet) in one sheet... -
Question about Data Validation.
- Started by omairhe
- Replies: 24
Hello all, I find data validation to be a useful tool in excel 2019. In cell A2 if the value = A then allow both positive and negative integers... -
VLookup Or Other To Match Data.
- Started by fintail99
- Replies: 23
Hi there, I have data, as follows: Sheet1 A1: Name B1: 0.5 (this relates to total time, see Sheet2 below) C1: £25.00 (this relates to the total... -
Split a year range into one row per year
- Started by rameez788
- Replies: 21
Hi all, I am new on this forum. I have attached sample data, i need someone to help me convert the left side to how the data looks on the right... -
Combine 2 var into 1 string with & in between
- Started by bumbum2812
- Replies: 21
Hi Experts Please help me combine 2 var into 1 string with & in between. My data is from A1:A2 & i have below code to put in MsgBox...