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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Alternate Between Excel Files
Hi All, Can anyone please show me how to alternate between two or three excel files using VBA... For instance Open Files File A, File B, File C, and File D THEN copy from File A, then paste into File X, then close File A copy from File B, then paste into File X, then close File B copy from...- Hamyatta
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
TRYING TO OPEN "ANY" EXCEL FILE in given folder
-- I am using the following string to open "ANY" excel file in a specific folder.. Workbooks.Open Filename:= _ "C:\Excel Data Extract\AnyFile.xls" -- Would it be better to use this one? "C:\Excel Data Extract\ &''"& '.xls'" Any ideas..?? THANKS!!!!- Hamyatta
- Thread
- Replies: 15
- Forum: VBA Visual Basic for Applications (Microsoft)
