Access this solution immediately by signing up as a member of excelanswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Excel VBA find sheet with partial name
Hi there,
I use the VBA line of code listed below that finds and copies sheets named "My_Schedule" in multiple workbooks, into one collective workbook. Problem is that some sheets names are appended (for example: "My_Schedule (day2)", of which the line of code below skips over these workbook sheets. I tried adding an asterisk, but that didn't work. any suggestions on how to make the adjustment to copy sheets that have "My_Schedule" as part of an existing sheet's name?
Many thanks
Set ws = wb.Worksheets("My_Schedule
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- Participating Experts
- 1
- Solution Grade
- A
Log In
Stay Connected
Top Experts
-
mlmcc
10,880
0 points yesterday
Profile -
dlc110161
3,500
0 points yesterday
Profile -
jimpen
3,500
0 points yesterday
Profile -
rowanscott
2,200
0 points yesterday
Profile -
billprew
2,000
0 points yesterday
Profile -
imnorie
2,000
0 points yesterday
Profile -
kgreene
1,820
0 points yesterday
Profile -
harfang
1,800
0 points yesterday
Profile -
Netminder
1,000
0 points yesterday
Profile -
GRayL
1,000
0 points yesterday
Profile -
eeshahidt
868
0 points yesterday
Profile -
patrickab
668
0 points yesterday
Profile -
tilsant
664
0 points yesterday
Profile -
redrumkev
400
0 points yesterday
Profile -
dave4dl
400
0 points yesterday
Profile -
byundt
200
0 points yesterday
Profile -
CORBETTMJ
200
0 points yesterday
Profile -
pari123
200
0 points yesterday
Profile -
tagit
200
0 points yesterday
Profile -
broomee9
200
0 points yesterday
Profile -
Dave96
200
0 points yesterday
Profile
Posted on 2010-12-25 at 22:15:57ID: 34557169
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.