File folders
File folders
(OP)
Is there anyway to get folders' name and file name into spreadsheet automaticly? like this.
MyDoc
Pics
Colleagues
Remond.jpg
Steve.jpg
Family
Friends
Memos
Kids
Lucy
Business
Meeting
There may be a file in Windows System, but I don't know which one.
MyDoc
Pics
Colleagues
Remond.jpg
Steve.jpg
Family
Friends
Memos
Kids
Lucy
Business
Meeting
There may be a file in Windows System, but I don't know which one.





RE: File folders
MsgBox ActiveWorkbook.Name
MsgBox ActiveWorkbook.Path
End Sub
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: File folders
RE: File folders
h
Scroll down to the Utilities and download List and Print Excel Files.
RE: File folders
handleman, I just can use VBA to write some functions which I can not get it from Excel. I don't know much about VBA. I made one like this:
Public Function VSearch(index1 As Variant, ar1 As Range, col1, col2 As Integer) As Variant
'to improve function of Vlookup, can search the other column - col1 is the column you want to search
t = 1
rows1 = ar1.Rows.Count
LineBack:
If t = rows1 + 1 Then
VSearch = "#N/A"
GoTo LineOut
Else: End If
If index1 = ar1(t, col1) Then
VSearch = ar1(t, col2)
Else
t = t + 1
GoTo LineBack
End If
LineOut:
End Function
RE: File folders
http:
You should be able to figure out how to do what you want to do from there.
RE: File folders
RE: File folders
Anyhow, thanks guys, I will try more.