without opening

I have an excel file that needs to reference another excel workbook that is in another location (directory) so file path needs to be included. I do not want to have to open this external workbook as it is in constant use by another user and it is a large file and slow to open and close etc. But...

Dear All, I have a destination workbook which is protected and as well as the worksheets in it. I have source workbook with only one worksheet (which is also protected) which will be updated by someone else. Source file is saved in such a way that I have only READ access. I want my formula in...

I am trying to set up a button to press have a specific range be copied out of my current workbook and placed into another workbook not open in my computer. The problem I'm having is every time I press the button, the information replaces my last entry. In need to be able to copy it into the...

Hello there, Some advice please. I have a workbook with two sheets: Master and Profile. I want to create a button in Master which opens a dialogue box that allows users to browse to other Excel files. The user chooses their file and the contents are automatically copied and pasted into the...