Scrape Specific Worksheets across all Files in a Folder

**seanclayton** · 08-10-2019, 07:44 PM

Hi all,

New to VBA coding and was wondering if the following was possible:

Attempting to run a macro that will scrape through all files within a folder, searching for specific sheets, copy pasting values in the master sheet. I'm using the following code in order to do so but am getting errors.

Please Login or Register  to view this content.

Any help would be greatly appreciated!

**Kenneth Hobson** · 08-10-2019, 08:23 PM

Welcome to the forum! What line has the error? It could error if you referenced a sheet that does not exist. Use this to check first.

Please Login or Register  to view this content.

**seanclayton** · 08-11-2019, 08:41 PM

Thanks for the reply!

The problem lies on the following line:

Worksheets("OPEX Reader").Range("A4:O224").Copy_

The line prompts the error:
"Object doesn't support property or method"

Thanks in advance for the support!

**jolivanes** · 08-11-2019, 09:56 PM

If you change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

does that make a difference?

This might be an alternative
Change all references as required.

Please Login or Register  to view this content.

**seanclayton** · 08-12-2019, 11:36 AM

Thanks for the reply!

I realized that I should have mentioned that I only need the values to be pasted. I tried adding in .PasteSpecial Paste:=xlPasteValues but am getting errors.

I know I must bed missing something pretty straightforward but I haven't got a clue what else to do.

Thanks again

Scrape Specific Worksheets across all Files in a Folder

LinkBack

Thread Tools

Rate This Thread

Display

Scrape Specific Worksheets across all Files in a Folder

Re: Scrape Specific Worksheets across all Files in a Folder

Re: Scrape Specific Worksheets across all Files in a Folder

Re: Scrape Specific Worksheets across all Files in a Folder

Re: Scrape Specific Worksheets across all Files in a Folder

Thread Information

Users Browsing this Thread

Similar Threads

VBA Copy specific files listed in Excel from folder & subfolders to another folder - FSO

Unzip all files in a specific folder and move CSV files to a different specificed folder

[SOLVED] Moving Files from Source Folder to Specific Folder

Extract specific column data from specific sheet from multiple files in a folder

[SOLVED] how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?

[SOLVED] how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?

[SOLVED] how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions