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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 1004 close method of windows class failed

Status
Not open for further replies.
LMichel

LMichel

IS-IT--Management
Apr 2, 2001
85
BE
The following Excel 97 macro fails on some (older) computer

ActiveSheet.Paste
Range("A1").Select
ActiveWorkbook.Save
MsgBox "Le nom de la fenetre = " & ActiveWindow.Caption
'Workbooks("récapitulatif.xls").Close SaveChanges:=True
'Application.Windows(2).Close
'Application.Windows("récapitulatif.xls").Close
ActiveWindow.Close
Selection.ClearContents
Range("A1").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("pointage").Select

What do I nedd to update to have this code working on every machine ?

Os is windows NT.

Thanks for your help !
 
Status
Not open for further replies.

Similar threads

Avayacoolstuff
  • Locked
  • Question
Error codes Microsoft office
Replies
1
Views
450
dhookom
dhookom
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
2K
SoftwareRT
SoftwareRT
TrekBiker
  • Locked
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
807
TrekBiker
TrekBiker
D
  • Locked
  • Question
How can i have more than 1 line in the body of an email
Replies
2
Views
437
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
901
bs6600
bs6600

Part and Inventory Search

Sponsor

Back
Top