Hi
I have 1 Wbk Master with 27 sheets (main sheets), and i have 70 files .xlsx (in folder MymarrecoFolde) each file have 40 tabs (27 tabs that i want).
I need get in ALL files (no file Master) wich has tabs equal tabs in my Master workbook.
So my tabs has tab name equal master workbook then copy data.
I try code below, but display error bad name 52
Please Login or Register to view this content.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi
Someone understand my question?
give me a sec looking now
Set wbData = Workbooks.Open(fPath & fName) should be just Set wbData = Workbooks.Open(fPath) - path includes name
me entendi cara?
I have same errorrun time error '52':
Hi
Someone can help me?
Thank you!!
Hi, I need adapt this code, after look back on my posts I find this, but recentily I wll need use this again and I still without solution.
In this line how change this part of code to see sources sheets with "Sheet1" names?
Please Login or Register to view this content.
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Hi Jindon, thanks.
Look at my image file, I insert what is happening and what I need.
thanks
Are there any other worksheet(s) besides wsSource_1 to 4 in Mater file?
Yes, 2 tabs (Dashboard, utils). If you need more datails let me know.
Thank you!
Untested,
Please Login or Register to view this content.
Last edited by jindon; 08-13-2021 at 10:08 AM.
hi jindon, this work like charm.
Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks