workbooks.add("c:\path\file.xls") creates a NEW (unsaved) workbook
based on the template specified by filename.

how do you want to share a workbook that hasn't been saved?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


VadimT wrote :

Hello,
I have recently attempted to fix a problem with Excel processes not
going away when run through automation, by replacing calls to
Excel.Workbooks.Open(filename)
with
Excel.Workbooks.Add(filename)
I have now run into a problem using this code for a shared workbook,
because a "Save As..." dialog pops up when the call to Add is made.
Can anyone explain the fundamental differences between Add and Open
methods on the Workbooks object, and how that interacts with the
sharing of a Workbook?

Thanks.