View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Need help with code to save/open

Looks like a typo

bk.Close SaveChange:=False
should be

bk.Close SaveChanges:=False

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Tom: when I used yours, it produced an error - a 1040, I think - and in
the debugger, that last line, "bk.Close SaveChange:=False":" was
highlighted.

Ron