Thread: explicitly name workbook and close without saving
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
laavista laavista is offline
external usenet poster
  
Posts: 50
Default explicitly name workbook and close without saving
This seems like such a simple thing, but I need help!

I have 3 workbooks open. I need to close one of them without saving, and I
want to name the specific workbook to close.

I've tried lots of things. The latest is:

dim wbName as workbook

wbName = ("MyFile.xls")
wbName.Close SaveChanges:=false

Your help would be GREATLY appreciated!
Reply With QuoteReply With Quote