Re: excel object

Thanks for the reply but which one do I use to overwrite an existing file
without a prompt. This script will be scheduled. The other option is to use
fso to delete the file first.

Thanks
Mike



"Dave Patrick" wrote:

> This may help.
>
> http://techsupt.windowware.com/TS/T000001033005F9.html
>
> --
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
>
> "Koda" wrote:
> | one other question. When saving the new file using
> |
> | Const xlSaveChanges = 1
> | xlOutBook.Close xlSaveChanges
> |
> | This prompts if I want to overwrite the file. I always will what is the
> | constant for that?
> |
> | Thanks again
> | Mike
> |
> |
> | "Koda" wrote:
> |
> | > I am working on a script to automate merging excel files but I think I
> ran
> | > into a snag. In order to crete an excel object do I have to have excel
> on
> | > the server? My guess is yes but I can't move yet to a server for
> testing.
> | >
> | >
> | > Set xlApp = CreateObject("Excel.Application")
> | > Set xlOutBook = xlApp.Workbooks.Add
> | >
> | > Thanks
> | > Mike
>
>
>
.

Relevant Pages

  • Re: How do you disable save file dialog?
    ... > Using some sample VB Script code, I've come up with a script that will ... > pull some data and print out the resulting workbook. ... > everytime the script closes the workbook and excel, ... How can I get this prompt to go away? ...
    (microsoft.public.excel)
  • Re: How do you disable save file dialog?
    ... > Using some sample VB Script code, I've come up with a script that will ... > pull some data and print out the resulting workbook. ... > everytime the script closes the workbook and excel, ... How can I get this prompt to go away? ...
    (microsoft.public.vsnet.vstools.office)
  • Re: How do you disable save file dialog?
    ... > Using some sample VB Script code, I've come up with a script that will ... > pull some data and print out the resulting workbook. ... > everytime the script closes the workbook and excel, ... How can I get this prompt to go away? ...
    (microsoft.public.excel.setup)
  • Re: How do you disable save file dialog?
    ... >> Using some sample VB Script code, I've come up with a script that will ... >> everytime the script closes the workbook and excel, ... How can I get this prompt to go away? ... >> Chris Smith ...
    (microsoft.public.excel)
  • Re: How do you disable save file dialog?
    ... >> Using some sample VB Script code, I've come up with a script that will ... >> everytime the script closes the workbook and excel, ... How can I get this prompt to go away? ... >> Chris Smith ...
    (microsoft.public.vsnet.vstools.office)