Active workbook selection

Hi Althaf,

I guess, anyhow you need to type the name of the workbook or get it stored in a variable as the name will keep on changing.

To type the name of the workbook, you can use a input box as i = inputbox("workbook name") and then you can use that further in the code as windows(i).activate. You can also type the workbook name in a cell and get that value stored in i.

Regards,
DILIPandey

<click on below 'star' if this helps>

Instead of using the Sheet Name, just use the Sheet# i.e.:

If it is Sheet 2 that is named "abc2.xlsx", then use only the Sheet #

Please Login or Register  to view this content.

Now you may change the name of Sheet2 as many times you like, the Code will allways take you to Sheet2.

If you want to keep track of a WorkBook of which the Name changes often, then in that same WorkBook, go to the WorkBook Before Close Event and in there you enter Code to update say Cell C10 of the other open WorkBook, which in turn you could use to find the new name.


Hope that helps.

Hi, Althaf,

it would be best to avoid jumping in between windows or workbooks by opening the workbook and setting an object on that:

Please Login or Register  to view this content.

Later on you can fulfill any action by using wbToOpen for the new workbook and ThisWorkbook for the workbook with the code.

Please Login or Register  to view this content.

assuming in cell A1 is drive, folder and name of workbook like C:\Temp\NewBook120923.xlsx.

Ciao,
Holger

Hi, Althaf,

in your very first thread in this Forum I pointed out to use Application.GetOpenFilename - and I repeat this again. The value retained from there can be used to set an object - if you really need 6 open workbooks to switch around any collection could handle the name of these instead of questioning these via (according to my opinion) the weakest possibility of all InputBox (open to typos like I´m master on ).

Please Login or Register  to view this content.

HTH
Holger <-- that´s my name