-
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.
path1
-
M
Is there a way to trigger a sub from inside another sub?
I have a commandbutton_click sub that I would like to code so that a folder is created. Is there a way to call on a function/sub and to have it run its code and then go back to the commandbutton_click sub to finish? The function is below... Function MkDir(strDir As String, strPath As String)...- MistakesWereMade
- Thread
- function path1 strdir string strpath
- Replies: 16
- Forum: Excel Questions
-
R
Open File Dialog box - VBA
I'm losing my mind and need some help. I might just be missing something having stared at my screen for way too long today. I have some code that puts a formula in a cell which references a closed workbook, spits out the result, and then pastes it as a value. What I can't figure it is: 1) Why...- rilzniak
- Thread
- i.value path1 path3 public string
- Replies: 5
- Forum: Excel Questions
-
V
Workbook open not working
The below code is not working..can any one guide..- VBABEGINER
- Thread
- book1 dim path1 string working
- Replies: 9
- Forum: Excel Questions
-
F
loop through folders
I have set paths to 3 specific files. I cannot figure how to loop through them dim path1, path2, path3 as string dim counter as integer dim WB as workbook path1 ="...\a.xls" path2 ="...\b.xls" path3 ="...\c.xls" for counter = 1 to 3 set WB = workbooks.open("Path" & Counter) counter = counter...- fraufreda
- Thread
- counter dim loop path1 path3
- Replies: 8
- Forum: Excel Questions
