XLSM File opens duplicate copies?

[RJQMAN]

I have a large workbook - 8 megs in xls. I saved it as an XLSM file,
and it reduced the size to 2 m. Cool, I thought. I opened and ran
the workbook without difficulty in Excel 97, 2003, and 2007. Then I
send it out to others. When some of them opened it, the start-up
macros crashed, and the program would not run. After long telephone
conversations, it appears as though there are 2 copies active, both
with the same name? Not sure. In any event, the type of error
messages that pop up are the kind that happen when there are two
workbooks open. I had protected the macros by tying the statements to
'thisworkbook.sheets..." throughout, and thought I was running safe.

Those same people (there are 5 of them using it this weekend) all are
having intermittent problems - sometimes it opens and runs fine -
sometimes it does not open properly and those error messages pop up,
and the program displays the VBA sections.

I could set the macros to ignore errors, but I may be causing even
more problems. I just do not know, and my time clock is ticking, as
the program is used every weekend between now and Thanksgiving, so I
do not have much time for trial and error work.

So, today I sent the program out in XLS 2003 workbook format to see if
that solves it, but I do not grasp what is happening. I do not yet
know if that solution is what I should do or not. Can anyone tell me
what could be wrong?

 

[Barb Reinhardt]

It would help to know what lines were displayed when the errors occur.
Please post the relevant lines of code.

 

[RJQMAN]

It would help to know what lines were displayed when the errors occur.    
Please post the relevant lines of code.








- Show quoted text -

Hello

I am not sure what is causing the problem, so I do not know what lines
of code to post? the problem is occuring with one of the users, who
is 1000 miles away from me physically, and corresponds by e-mail. She
sent me a screen shot of one of the error messages;

it reads Run time Error 1004
Unable to set visible property of the worksheet class

the program has a workbook file that causes the workbook to open to
the same introduction page every time. It instructs the user to click
on a button that takes the user to a series of userforms that end up
on a userform menu. This 'Main Menu' has about 10 options on it, all
controlled with buttons. When the user selects a button, the program
opens one of about 12 spreadsheets (or in some cases, it opens other
menus).

In this case the user opens 3 spreadsheets. On those spreadsheet
(titled user instructions, FAQ;s, and How To...), which are locked,
there is a button on each that drives a subroutine that is designed to
return the user to the main menu. The subroutine hides all open
spreadsheets, minimizes the screen, then displays the Main Menu
again. This is when the errors start to happen.

She loaded it on two more computers. On one computer, she had the
same difficulty.. On the second computer, it ran perfectly!

I have run this same program repeatedly on Exel 97, 2993, and 2007
with Windows vista and an earlier windows viersion without
diffiiculty. Last weekend I sent out 6 copies. One copy had this
difficulty,4 ran perfectly, and one other user said he had to start
the program twice, as the first time he had a problem with it locking
up - a problem that sounded very similar to the one I am describing,
but I do not have enough details to know for sure. Tthe other 4 ran
perfectly.

HOWEVER another weird thing happened. All six users sent the programs
back to me this morning with the data filled in. I was able to open 4
of them - but on two of them I got an error message that said the file
converter was not able to convert them from xlsm and open them! I am
at a loss for sure now.

Is it possible that the program was so large that some of the users
ran out of memory? It is large - 8400 kb

What should I send you? I need help and I am up against a wall, as the
program is used every weekend for the next six weekends, and I do not
even know where to start to trouble shoot, as it seems to run just
fine on all of my computers and with every combninationI can
fabricate. Plus I cannot open two of the six that came back to me!
Aargh.

 

[RJQMAN]

Hello

I am not sure what is causing the problem, so I do not know what lines
of code to post?  the problem is occuring with one of the users, who
is 1000 miles away from me physically, and corresponds by e-mail.  She
sent me a screen shot of one of the error messages;

it reads Run time Error 1004
Unable to set visible property of the worksheet class

the program has a workbook file that causes the workbook to open to
the same introduction page every time.  It instructs the user to click
on a button that takes the user to a series of userforms that end up
on a userform menu.  This 'Main Menu' has about 10 options on it, all
controlled with buttons.  When the user selects a button, the program
opens one of about 12 spreadsheets (or in some cases, it opens other
menus).

In this case the user opens 3 spreadsheets.  On those spreadsheet
(titled user instructions, FAQ;s, and How To...), which are locked,
there is a button on each that drives a subroutine that is designed to
return the user to the main menu.  The subroutine hides all open
spreadsheets, minimizes the screen, then displays the Main Menu
again.  This is when the errors start to happen.

She loaded it on two more computers.  On one computer, she had the
same difficulty..  On the second computer, it ran perfectly!

I have run this same program repeatedly on Exel 97, 2993, and 2007
with Windows vista and an earlier windows viersion without
diffiiculty.  Last weekend I sent out 6 copies.  One copy had this
difficulty,4 ran perfectly, and one other user said he had to start
the program twice, as the first time he had a problem with it locking
up - a problem that sounded very similar to the one I am describing,
but I do not have enough details to know for sure.  Tthe other 4 ran
perfectly.

HOWEVER another weird thing happened. All six users sent the programs
back to me this morning with the data filled in.  I was able to open 4
of them - but on two of them I got an error message that said the file
converter was not able to convert them from xlsm and open them!  I am
at a loss for sure now.

Is it possible that the program was so large that some of the users
ran out of memory?  It is large - 8400 kb

What should I send you? I need help and I am up against a wall, as the
program is used every weekend for the next six weekends, and I do not
even know where to start to trouble shoot, as it seems to run just
fine on all of my computers and with every combninationI can
fabricate. Plus I cannot open two of the six that came back to me!
Aargh.- Hide quoted text -

- Show quoted text -

MORE INFO - I was finally able to open the last two that came back to
me. I noticed that the file size was too small when I was checking
out the properties of the two files that I had downloaded and was
unable to open. I guess the entire file did not download - I have no
idea why not, as it dowloaded fine with the other four I received
back. By trial and error, I found that if I downloaded them on Google
with a right click, 'save as' rather than a single click download, I
got the whole file. I do not know why, but it solved my problem, so I
mention it here in case others have the same problem. If someone
understands why, it would be nice to know. Perhaps that would help me
understand why one of the people who received the program from me had
problems.

 

[RJQMAN]

MORE INFO - I was finally able to open  the last two that came back to
me.  I noticed that the file size was too small when I was checking
out the properties of the two files that I had downloaded and was
unable to open.  I guess the entire file did not download - I have no
idea why not, as it dowloaded fine with the other four I received
back.  By trial and error, I found that if I downloaded them on Google
with a right click, 'save as' rather than a single click download, I
got the whole file.  I do not know why, but it solved my problem, so I
mention it here in case others have the same problem.  If someone
understands why, it would be nice to know.  Perhaps that would help me
understand why one of the people who received the program from me had
problems.- Hide quoted text -

- Show quoted text -

I am becoming more and more convinced that the operational problems
this user had with my excel program were due to memory limitations on
the user's computer(s). I have no proof of this, but I cannot reason
out anything else, since the problems are so intermittent. However,
that still does not explain why, on one computer only, the computer
appeared to open two copies of the program. Perhaps it really did not
do that - perhaps the error messages led me down the wrong path in
trying to analyze the problem over the phone. This was the one
computer that had a problem,and one user. And the same user had moved
the program to a second computer and experienced the same problem.

Today, after the weekend event is over, she has run the program
without difficulty over and over again on her computers and her
daughters' computers. I cannot imagine what else could be causing
it. I think it was the author of the Sherlock Holmes novels who said
(paraphrasing) that 'after you have elminated all other 'causes' -
" (when speaking of a murderer), "the only remaining 'cause', no
matter how unlikely, must be the one."