Path/File Access Close this error then Run-time '75' Error

  • Thread starter Thread starter Rod R
  • Start date Start date
R

Rod R

Code:

Private Sub Workbook_Open()

UserForm1.Show
Workbooks.Open Filename:= _
"C:\Sales Documents\Quote System\Integrated Bid Sheet.xlsm"

End Sub

Background:
This code worked fine in 2003, updating Code for 2007. This code lives in
one Workbook and calls the Integrated Bid Sheet.xlms to allow for
dependancies in user forms.

Both Workbooks open fine seperatly without the:
Workbooks.Open Filename:= _
"C:\Sales Documents\Quote System\Integrated Bid Sheet.xlsm"

Problem: As soon as I add this code, the first workbook opens as expected,
shows its UserForm1, Opens the "Integrated Bid Sheet" as expected and then
Excel throws a "Path/File Acess" error with no explination, closing this
error window then causes Excel to throw a Run-Time '75' error and any action
from this error causes Excel to Crash and attempt to recover.

Funny part is if I Open the "Integrated Bid Sheet" First then start what
should be the first worksheet(with Code) to open, it simply throws the file
is already open would you like to reopen dialog and clicking "NO" Breaks the
macro and throws debug/end dialog box, select end and both sheets than work
completly fine

Looking for error free method

Thank you in Advance
 
Back
Top