Message box pop up asking if I want to run a macro which pulls data from another SS

Hello All,
I would first like to tell everybody how much I appreciate this forum. I have gotten the best help and I have learned so much by looking at other post. The experts on this site are the best!!!

My question or plead for help is... I have a master spreadsheet (sheet1) that I have a popup box that asks if I want to run the macro. The macro is deleting all from example 1 then goes to example2 and copies data and paste the data on example1. I am getting an error when it gets to this code

Please Login or Register  to view this content.

Hello Sbarro79. Thank you for the help. I tried the macro and I am getting the error workbook example2.xlsx not found.
Not found.JPG

I have attached a print screen of the example2 is open in the background and the error

Can you check, if the path to example2.xlsx is correct (no misspelling etc.)?

Hello Sbarro79, It looks like the spelling is correct. I did the print screen with the example2.xlsx is open in the background showing the spelling looked correct.

Hello Sbarro79, thanks for coming back to help me. I understand now what you are saying but there is a glitch with naming the path to a persons folder. The spreadsheet (sheet2) is an export from a report that is out on the company's intranet and sheet1 will be shared by several people so the patch is on the desktop of whom every exports sheet2.

Example of how the sheets should work:
Person exports sheet 2 from the intranet
Then person opens sheet1 and the macro pops up to adds the data from sheet2 to sheet1

I really appreciate you helping me with this.

Because of my english is quite rubbish, sometimes I don't understand what people are trying to say to me, so could you correct if I'm wrong:
I understand, that every person is downloading sheet2 file from intranet onto local disc on the PC, but how exactly sheet1 file is shared - every person uses its own copy of this file, or you all use the same file located on company's server?

Hello Sbarro,
Sheet 1 is located on a company shared drive.
Sheet 2 will be export onto the person desktop.
so both sheets will be located on the person desktop when they are opened. Or more like both sheets will be active on the person computer.

Hi Tammy

I have no experience with shared files (sorry..), but I'll still try to help you somehow.
For now try this:

Please Login or Register  to view this content.

It forces user to choose the exported (shouldn't be imported?) file manually in order to resolve a path glitch you wrote about (or at least I hope it will )
Please be advised that this code may generate an error (error number 52 I think) if you try to use it at the same time when another person be using it (but I'm not sure of that)

Hello Sbarro79,
I have tried the code you gave me. It is wanting me to choose a file on my computer. It had the box "Choose your file" pop up. We won't have example2 saved anywhere because it is just a temporary active file that we just want to pull the data from. We just want to export data from the website and it will open with the name example2 from the website then I will open sheet1 and export the data from the active example2 (open in the background) then pull the data on my main spreadsheet example1.

Thank you so much for helping me with this.

Hi
Sorry for the very late reply.

Because I have no experience with intranet then I couldn't realize that this exported file is a temporary file.
So try this simple code:

Please Login or Register  to view this content.

Because I have no way to test it (no access to intranet), there is no guarantee it will work at all