RE: excel object

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
.