VBA code for combining data - need help updating

jrfarmer2010

New Member
Joined
Jan 18, 2018
Messages
8
Hello there,

I am trying to repurpose coding that is used in another workbook to make it effective for the one I'm trying to create now. Essentially, it combines all the data from dozens of files into a single file where I can extract the data and/or utilize in pivot tables. There's a line in it that determines the file names that it will pickup though, and I must be really off my game today because I can't figure out how to change it to make it pickup the file names that I'll be using.

Here is the line of coding, let me know if you need to see more to answer the questions.

Code:
With mybook.Worksheets(Mid(MyFiles(FNum), 21, Len(MyFiles(FNum)) - 25))

Thanks!
Jessica
 
Last edited:

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
so you are saying look at the worksheet name and with a start point of 21 retrieve the length of the name - 25 letters

This If we really want to get the correct name would produce

get the correct

hope this helps
 
Upvote 0

Forum statistics

Threads
1,223,238
Messages
6,170,939
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top