-
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.
wookbooks
-
Barking up the wrong tree
Hi is it possible I have seven wookbooks stored in numbered week folders each workbook is dated sun01.11.19 to sat07.11.19 . I need to be able to enter the folder name week 45 and each of the seven wookbooks within opened and sheet1 from each be combined into a new wookbook.- HappyChappy
- Thread
- Replies: 14
- Forum: Excel Questions
-
A
combine data from multiple workbooks to existing worksheet in existing workbook
I need to combine data from multiple workbooks into an existing worksheet in an existing workbook. I have tried many solutions from past posts vba but none work. Select All rows with data starting from A6:G6 down until it hits an empty row at which point the vba will goto a different...- Apple2_1979
- Thread
- Replies: 3
- Forum: Excel Questions
-
D
Custom Toolbar With 'Window' Open Wookbooks List Needed
Hi I am creating a custom toolbar with some basic functions like open, save, etc. on. I need to hide the worksheet menu bar which I have done. I would like to put a toolbar icon on the custom toolbar which displays a list of the currently open workbooks similar to that found under the...- derekpegg
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Finding issue in If elseif else with For each Loop
- Started by Arunachaljois
- Replies: 57
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please... -
VBA to copy certain columns from multiple workbooks with multiple worksheet based on criteria into master workbook
- Started by nathanmav
- Replies: 51
Hi everyone, I would like to ask for help about the code I found and I tried to modify it but I'm not lucky to make it work. I have a total of... -
Frequent Text - Duplicates
- Started by SaraWitch
- Replies: 30
Hello all, I'm using the Index, Mode and Match array formula to show the most frequently repeated text. However, I wonder if there's a formula... -
Timer in VBA - Stop, Start, Pause and Reset
- Started by Anton1999
- Replies: 28
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub... -
how to updates multiple rows in muliselect listbox
- Started by jaym6939
- Replies: 26
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code... -
Multiple Case statements
- Started by davidausten
- Replies: 26
Im using a combo box to select the option. The thing I am having trouble with is that if you select the second case statement from the list (they...