Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by bjaytiamsic26
-
Merge multiple workbooks into one new worksheet
Nothing happened when I execute the code. I tried searching for functions of lines/properties that i do not understand. I opened all the files in the folder I used but nothing changed.- bjaytiamsic26
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Merge multiple workbooks into one new worksheet
Thank you! I will try my best to understand the code. I just got into VBA.- bjaytiamsic26
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Merge multiple workbooks into one new worksheet
I came up with the error "Object doesn't support this property or method" on the line: For Each oFile In oFSO.GetFolder(sPath)- bjaytiamsic26
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Merge multiple workbooks into one new worksheet
Hi! I have tried merging multiple workbooks in the same folder in to one worksheet. here is the link where I got the VBA Code. https://sites.google.com/a/madrocket...s-to-one-sh... I tried editing the code and I came up with Option Explicit Sub Consolidate() 'Author: Jerry...- bjaytiamsic26
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Merge multiple workbooks into one new worksheet
Hi! I have tried merging multiple workbooks in the same folder in to one worksheet. here is the link where I got the VBA Code. https://sites.google.com/a/madrocket...s-to-one-sheet I tried editing the code and I came up with Option Explicit Sub Consolidate() 'Author: Jerry...- bjaytiamsic26
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
