RunTime Error 5

G

Guest

Why would this fail:
ActiveWindow.Close , savechanges:=False

Even if I stick this line before it, I still get a runtime error 5:
On Error Resume Next
I just loaded the workbook, read some data and I want to close it without
saving changes, but I am getting runtime error 5, invalid procedure call or
argument.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba in excel 2007 5
conditional formatting 1
Macro to update pivot table data range 3
invalid procedure call 1
runtime error 2147221005(800401f3) 0
Runtime error 1004 when trying to insert formula in cells 11
Error 5 on Shell Command 12
Invalid procedure call or argument 3

Top