What type of file is the one not opening?

Templates(*.xlt or *.xltx) do not open automatically from XLSTART folder.

Another thing to look at.............

There may be several XLSTART folders on a user's computer.

Are both files in the correct folder?


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 13:40:02 -0700, VBA-PA
wrote:

Thank you for your response.

There is no error displayed. The one file that does not run would normally
add a menu with several menu items in it. When I start-up Excel, there is no
sign of the file opening (IE. no new menu or menu items, the file is not open
and hidden, I open up VBA and the Project is not present open). It appears
as if there was no attempt to open this second fole on these select PCs.

On the computers where it successfully opens both files:
- The newly created menu and menu items are present in Excel
- the second file appears on the list of hidden files
- the project for the second file appears in the VBA environment.

I will confirm the references but there were no errors indicating a
problem. Would you expect this to be the case?

Thanks again.


"ryguy7272" wrote:

Whenever code works on one computer but not another, you may assume it has to
do with a missing reference. Take a look at this:
http://www.cpearson.com/excel/MissingReferences.aspx

What is the exact error message? When you open the Reference window, does
it say 'MISSING' next to any of the references that you are invoking?

Try that recommendation and if it doesn't work come back with more details
please.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"VBA-PA" wrote:

I have two files containing macros that I placed in XLSTART. These are
distributed to several users on individual PCs

In some cases One file opens and runs...the other does not.

Looking at other posts I checked to see if the file was disabled by excel on
the PCs experiencing the problem. The file was not disabled.

Any suggestions?