View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wal wal is offline
external usenet poster
 
Posts: 19
Default Test if workbook is not yet named

Excel 2003

I have a simple SaveAll macro using For Each...Next. It loops through
open workbooks and saves them.

If a new, as-yet-unnamed workbook is open, the macro will save that as
Book1.xls in My Documents, without a prompt. (Of course, if you hit
Ctrl-S when that workbook is active, you get the Save dialog.)

How can you test whether a workbook has been unnamed or never-been-
saved? I would include that code to skip that workbook in the For
Each loop.

Thanks.