Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel projects and macros mess up

Status
Not open for further replies.
acjeff

acjeff

Programmer
Aug 10, 2004
148
US
Hi all,

On a new Excel file named May18.xls, I built some macros. Then I save the file as May19.xls and its projects and macros are kind of messing up.

When I close and open May19.xls again and open VB Editor, it shows VBAProject(May18.xls) as well as VBAProject(May19.xls). I could remove all macros belong to May18 but I found no ways to remove or delete the May18 project.

Every time I open the file, sometimes it shows 2 projects, sometimes it shows May19 only.

Why is that? What to do?
 
Sort by date Sort by votes
Do you have Google desktop search installed ??

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Because it has been known to interfere with the Visual Basic Environment in the way you have described....

Other than that, go Windows>Unhide and see if the file is there. If it is, unhide it and close it. Should get rid of the problem

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
I just copied the file to a new folder and found there is no other hidden or protected file at all. Opened the file again only showed 1 project which was correct. Then I have customized button in a custom menu to run a macro. When I click it, the other project was shown again. What do yo think?
 
Upvote 0 Downvote
Sorry, I forgot to mention that my verions are Excel 97 on Win 2K. Please, any input?
 
Upvote 0 Downvote
Could it be that there is a reference created in your may19 workbook to the may18 workbook, or that you somewhere in your code hardcoded to do something in the workbook may18.xls?

Kind regards,


Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - Dutch supportsite for spreadsheetusers)
 
Upvote 0 Downvote
Certainly seems that way - sounds like you are opening the old version of the workbook but either it is opened in memory only or it has been opened in another version of excel where the application mode has not been set to visible...

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
561
strongm
strongm
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
333
mikrom
mikrom
Andrzejek
  • Question
Copy data between SQL and Oracle 1
Replies
7
Views
287
dhookom
dhookom
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
621
remeng
remeng
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
385
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top