Hi all,
I have have a code that will copy information from one workbook to the other. I have the Source workbook open, and it will show in VBA editor.
When I check out a file (from a program at work) it will be saved in a local checkout folder on my computer and the file opens in Excel automatically. I need to run the code on this workbook, but it doesn't work as somehow Excel doesn't "know" the workbook is open, and it will not show in VBA Editor.
If I close the workbook without checking it in, and then open it manually from the checkout folder, it will show in VBA Editor.
However, if I open VBA editor from the checked out file VBA editor will open, but there the Source workbook is not shown. So now I have 2 different VBA editors open, with 1 workbook in each of them. Somehow they are not connected.
Any ideas what is going on here
I have have a code that will copy information from one workbook to the other. I have the Source workbook open, and it will show in VBA editor.
When I check out a file (from a program at work) it will be saved in a local checkout folder on my computer and the file opens in Excel automatically. I need to run the code on this workbook, but it doesn't work as somehow Excel doesn't "know" the workbook is open, and it will not show in VBA Editor.
If I close the workbook without checking it in, and then open it manually from the checkout folder, it will show in VBA Editor.
However, if I open VBA editor from the checked out file VBA editor will open, but there the Source workbook is not shown. So now I have 2 different VBA editors open, with 1 workbook in each of them. Somehow they are not connected.
Any ideas what is going on here
