Extracting Data from another excel file and transfer it to another excel file

[clz003]

Hi, I'm pretty new to excel and looked up for solutions on extracting data from another excel file and transfer it to another.
But they are all referring to the name of the sheet as "Sheet1". My issue is that the origin excel file is an autogenerated file from a CRM and it also autogenerates the sheet name and the name of the file.

So my issue is how can you rename a sheet without even specifying the original name of the sheet?
If there's any way to do this more efficiently, please let me know how

 

[Logit]

Worksheets have two nomenclatures.

Ex:
Sheet1("Sheet1")
Sheet2("Sheet2")
Sheet3("Sheet3")

Sheet1 can be referred to as its numerical name or position in relation to all the other sheets in the workbook.
("Sheet1") is Sheet1's name. Sheet1 can remain as such and its name could be anything: "Inventory"; "Paint Colors"; "Dogs - Female", etc.

Is the autogenerated sheet name always for Sheet1 or Sheet2 or Sheet3 (note the absence of quotation marks) ?

 

[clz003]

Worksheets have two nomenclatures.

Ex:
Sheet1("Sheet1")
Sheet2("Sheet2")
Sheet3("Sheet3")

Sheet1 can be referred to as its numerical name or position in relation to all the other sheets in the workbook.
("Sheet1") is Sheet1's name. Sheet1 can remain as such and its name could be anything: "Inventory"; "Paint Colors"; "Dogs - Female", etc.

Is the autogenerated sheet name always for Sheet1 or Sheet2 or Sheet3 (note the absence of quotation marks) ?

yes, it is autogenerated everytime

 

[clz003]

It is autogenerated without quotation marks. From what i have tested, if i rename the excel file, it will also rename the sheet inside.

 

[Logit]

Does it follow a set pattern ? For example ... all workbooks begin with three worksheets. So .... is this autogenerated sheet always Sheet 4 ?

Or is the autogenerated sheet always one more after the last existing sheet in the workbook ?

 

[clz003]

Does it follow a set pattern ? For example ... all workbooks begin with three worksheets. So .... is this autogenerated sheet always Sheet 4 ?

Or is the autogenerated sheet always one more after the last existing sheet in the workbook ?

the file will be always autogenerated with 1 sheet. As for pattern it is impossible to predict since the name of the sheet will always be like this "LEAD_10142023_ebfp1a5xpd"

 

[Logit]

If it is always generated with only one sheet ... I presume that sheet "position name" is Sheet1 (note absence of quotation marks) ?

 

[clz003]

If it is always generated with only one sheet ... I presume that sheet "position name" is Sheet1 (note absence of quotation marks) ?

yes

 

[Logit]

Great. You can refer to the "position name" > Sheet1 < in your macro code.