Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lucas Silva   on Dec 04 In MS Office Category.

  
Question Answered By: Clinton Edwards   on Dec 04

I am sorry, I should have been more descriptive in my post. I am
getting #53 "File Not Found" when I run frmBook.Show. I even tried it
with NO workbooks open, other than the personal.xls workbook, which is
where the form is stored, using the immediate pane.

I am thinking it has to be something on that particular pc though,
because i have this very same setup successfully running on several
other computers in my department.

As I said, I swapped out a prior version for the new one; I normally
export the old version to the user's PC, in case something weird like
this happens. So when this did happen, I was able to remove and delete
the newer version, re-import the older version that I stored on the
users pc, and it worked just fine.

I thought maybe something happened when I exported the new version out
of the test workbook I built it in, so I tried grabbing another
instance of it from another pc where it is working just fine, but I
get the same message when I import that instance of the form as well.

It seems just unable to 'see' this updated version on this one pc? I
suppose I could just copy and paste all the new code tied to the new
form into the old one, and make the form control modifications by
hand, but this seemed so strange. Whenever stuff like this happens, I
have to ask myself, 'is there something here that I am not aware I
should be doing?'

My code does live in the form, as was suggested, what doesn't is the
'show the form' code. This is in a regular module in the personal.xls
workbook, and is tied to a button on the users toolbar...

The personal.xls file does have several standard modules in it, but
this form is the only form on the pc.

Hmmm. I did not 'Load' the form. My open form code is just the .Show
line. Should I always load the form first? I have not been doing this
if so (but i can still bring up the form on all the other pc's)...

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Cannot .Show a form that was imported? Or get search suggestion and latest updates.


Tagged: