excel automation

Stone

Hello,

I have two problems;

1) How complete the instruction "ExcelApplication.Workbooks.Close" for saving the file whith no prompt question ?
2) How complete the instruction "wdApp.ActiveDocument.MailMerge.OpenDataSource(MergeFileName)" to specify the plage of cells ?

many thanks for your help

<img border="0" title="" alt="[Confused]" src="images/smiles/icon_confused.gif" />

M@rtin

Hi,

ad1)
You must close all worbook in worbooks and then close worbooks.
This way for close workbook with no promt:

workbook .Close(SaveChanges, FileName, RouteWorkbook)

SaveChanges (False / True)
Filename (String)
RouteWorkbook (False - Doesn't send the workbook/ True - the workbook to the nex)

ad2) I'dnt now <img border="0" title="" alt="[Frown]" src="images/smiles/icon_sad.gif" />

M@rtin

M@rtin

Hi Stone,

I'm sending example for you, when I described how to use method Close for workbook.

---

Another way:

If you want work with Excel automation with out any promt you can use this command:

Excel.DisplayAlerts := FALSE;

(this command you type on begin codeunit after create excel object).

This is will may be adequate for you.

Martin

Sorry: my englisch is not good <img border="0" title="" alt="[Wink]" src="images/smiles/icon_wink.gif" />

Stone

Thanks Martin !

But when i try to compile the code-unit, i receive a navision error message:

"A maximum of 0 parameters must be used when calling the function"

<img border="0" title="" alt="[Eek!]" src="images/smiles/icon_eek.gif" />