Close workbook

O

Oldjay

I want to close Tempdata.xls if it is open

If ActiveWorkbook = "Tempdate.xls" Then
ActiveWorkbook.Close

The above doesn't work
 
B

Bob Greenblatt

I want to close Tempdata.xls if it is open

If ActiveWorkbook = "Tempdate.xls" Then
ActiveWorkbook.Close

The above doesn't work
Click to expand...
Looks like you spelled tempdate wrong. Or is it tempdata that is wrong.
 

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

Close workbook 7
Close workbook 4
Turning off automatic calculation 0
Table of content - format does not get saved 2
Hyperlink fails to open on the first click 0
While working with word 2010, closed itself! 0
Syntax to close Workbook 5
Check for open workbook 3

Top