.xlsx is already open...

Robert_Conklin

Board Regular
Joined
Jun 19, 2017
Messages
120
I have a large workbook with many worksheets within it. The end users fill in the user-forms and email the workbook back to me. There is a "SUBMIT" button in the workbook that uses VBA code to transfers the data submitted to another workbook that is used as a repository. I do not have any issues with this process, but my co-workers get the following error message when clicking the "SUBMIT" button.

SPAR LOAD PROCESS WORKSHEET 2018.xlsx is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen SPAR LOAD PROCESS WORKSHEET 2018.xlsx?

The destination file in the error message is not open when they click the "SUBMIT" button. Like I mentioned above I do not have any issues when I run the process on my computer.

Are there any suggestions as to why this would be happening? I am not convinced that it is the VBA code that is the problem.
 

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
How many people are responding? is there a chance they are clashing?

A few simple questions to look at.

Does the code try and open the workbook twice? Does the macro close the workbook after it has done what it needs to so it is closed for the next?
 

Robert_Conklin

Board Regular
Joined
Jun 19, 2017
Messages
120
You are the first to respond. I am not 100%, but I do not think the code tries to open it twice. Like I mentioned in the post, My co-workers get the error message, I do not. They receive the same sheets from the end users that I do. I do know that I have to manually save and close the destination file so that the data will save.
 
Last edited:

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
So an outside Macro opens the file and transfers data then you have to manually save and close it, so if one person opens it and you are not at the PC it stays open does it not?
 

Robert_Conklin

Board Regular
Joined
Jun 19, 2017
Messages
120
Yes, code from one Excel workbook opens the destination file, and I have to manually save and close it. No, I personally always save it and close it after the transfer. Also, if I am the one taking care of the transfers, none of my co-workers are. We have looked into that scenario, but we have all made sure that the destination file is closed on everyone's laptops, but they still receive the error message and I do not.

Would it be beneficial to add code to automatically save and close the destination file?
 

Forum statistics

Threads
1,081,618
Messages
5,360,055
Members
400,565
Latest member
Tommy O

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top