Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Adelina Fischer on Nov 15 In MS Office Category.

Closing worksheets without saving them

Question Answered By: Madiha Malik on Nov 15

Here is the code to close without saving
ActiveWorkbook.Close False
and,
To save newly open excel sheet with name
ActiveWorkbook.SaveAs Filename:="Your Desired Name"

This Question has 1 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Closing worksheets without saving them Or get search suggestion and latest updates.

Related Topics:

Select a value from a specified worksheet in a closed workbook
How to insert some worksheets to a closed workbook
Need help coping images (gif pictures) from worksheet to worksheet
Need help coping images (gif pictures) from worksheet to worksheet
Excel data transfer automatically from master worksheet to other worksheets
saving a worksheet with the name read from a text file
vba for save and close
Can't save/close workbook opened with GetObject using VBA
saving data without database
Run Macor in a closed workbook and refer to the closed workbook
How does the Worksheets function work?
INITIALIZE Worksheet
command button in Excel worksheet with email and attachment
inserting custom template into worksheet
Count the number of rows on a worksheet, divide the count by 15
Activate a worksheet or workbook with a variable name
Print data from combo box at worksheet
Toggle images on a worksheet?
Problem with Length of the worksheet name
How to store user input in a worksheet?

Tagged:closing worksheets without saving them

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us