code to open each workbook in folder

[Excelski]

Hi,

I have some code that makes desired changes to my workbooks.

I would like to add to this code so that it opens each workbook in my folder then applies my code

I need the code to open the workbook>my code>next workbook

I hope this makes sense

Thanks
Kevin

[SjonR]

this helps?

https://www.thespreadsheetguru.com/t...a-given-folder

[Excelski]

I think it does.......I am not very good with VBA

I assume I replace

'Change First Worksheet's Background Fill Blue
wb.Worksheets(1).Range("A1:Z1").Interior.Color = RGB(51, 98, 174)

for my code?

[YasserKhalil]

Have a look at this link
https://www.excelforum.com/excel-pro...n-folders.html

[jolivanes]

How are we to know what needs changing and where if we don't have an explanation of your needs except opening all the workbooks.

I assume I replace

'Change First Worksheet's Background Fill Blue

Please Login or Register  to view this content.

for my code?

[Excelski]

I have the code to perform the tasks I need, I needed to know which element of the code provided in #2 was to be replaced with mine