workbooks2

Hi The code below is working. I have 2 workbooks. Workbooks(1) has the code. When the user enter x = 2 the code below will create a worksheet in Workbooks(2) after worksheets(1). It is working but I wonder, in line 4, why I did not have to do this Workbooks(x).Worksheets.Add...

Hello I wrote the code below to activate the second workbook. The code below is work if both workbooks 1, 2 are opened. I minimized workbooks(2) (put it in taskbar) and ran the code below, excel did not try to open workbooks(2)? It did stay in task bar (not opened), why is that? Thank you...

Hi I want to open an closed excel file (abc.xlsx) and then move/copy sheet from the current workbook to that file (abc.xlsx). With your help, I learnt how to do that. But I just found that, when I open the file using open() function, excel will consider that file as workbooks(2). If that is the...