Dynamic File names and Sheet Names

Hi,

I am trying to create a macro in my personal workbook to edit two other workbooks, however, I am running into trouble when the script attempts to edit sheet2 in each workbook. I cannot use sheet name because the name changes every day when the data is refreshed.

Please Login or Register  to view this content.

Could you create a userform to list all the sheetnames in a listbox, so that you could then select the correct sheet?