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


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top