B
burl_h
first I have set up folders with pictures that i need to bring into
the spreadsheet. to do this i want to open the correct folder. The
folder to open will be based on two things,
first the folder name based on the content of column B in the active
row.
second a folder within the first folder named as the date that is in
column C in the active row
ex: column B (in active row) might say something like 123456 and
column C (in active row) might have a date as 1/20/12. so the folder
to open would be 123456\01-20-12
The key thing here is column B and C are fixed whereas the row number
has to be the current active row
The entire folder string for example would be similar to the
following:-
C:\users\public\picture\123456\01-20-12
would anyone have a vba solution for this
currently i'm using the following code, but it's not dynamic.
strpath = "C:\Users\Public\Pictures\123456\01-20-12\"
strfile = Dir(strpath & "*.jpg")
Thanks to all
burl_h
the spreadsheet. to do this i want to open the correct folder. The
folder to open will be based on two things,
first the folder name based on the content of column B in the active
row.
second a folder within the first folder named as the date that is in
column C in the active row
ex: column B (in active row) might say something like 123456 and
column C (in active row) might have a date as 1/20/12. so the folder
to open would be 123456\01-20-12
The key thing here is column B and C are fixed whereas the row number
has to be the current active row
The entire folder string for example would be similar to the
following:-
C:\users\public\picture\123456\01-20-12
would anyone have a vba solution for this
currently i'm using the following code, but it's not dynamic.
strpath = "C:\Users\Public\Pictures\123456\01-20-12\"
strfile = Dir(strpath & "*.jpg")
Thanks to all
burl_h