The Macro tab enables the user to specify the parameters to be used with the current DDE (Dynamic Data Exchange) output format.
What do you want to do?
Work
with the Macro Tab for Word
Work
with the Macro Tab for Excel
The Macro tab enables the user to specify the parameters to be used with the current DDE (Dynamic Data Exchange) output format.
Work with the Macro Tab for Word
For Word 97 or 2000 enter the following information:
Command Line: C:\Program Files\Microsoft Office\Office\WINWORD.EXE
File directory: the file directory for the target files created or used by ClicknDECiDE Builder when exporting data to this format, such as: D:\My Documents\Word\Mailing
Macro New: the Word macro to be used
to create a new document when ClicknDECiDE Builder sends data to a new document,
such as: (macro to be used for any country)
FileNew.Template="Normal"][FileSaveAs.Name="%s"]
Macro Open: the Word macro to be used
to open an existing document when ClicknDECiDE Builder sends data to an existing
document, such as: (macro to be used for any country)
REM _DDE_Direct][FileOpen("%s")]
Work with the Macro Tab for Excel
For Excel 97 or 2000 enter the following information:
Command Line: C:\Program Files\Microsoft Office\Office\EXCEL.EXE
File directory: the file directory for the target files created or used by ClicknDECiDE Builder when exporting data to this format, such as: C:\My Documents\Excel\Statistics
Macro New: the Excel macro to be used to create a new document when ClicknDECiDE Builder sends data to a new document.
For any Excel version in English or in another language: [New(5)][Save.As("%s";1;"";False;"";False)]
For any Excel version in French: [Nouveau.Document(5)][Enregistrer.Sous("%s";1;"";Faux;"";Faux)]
For any Excel version in German: [Neu(5)][Speichern.unter("%s";1;"";Falsch;"";Falsch)]
For any Excel version in Spanish: [Nuevo(5)][Guardar.como("%s";1;"";Falso;"";Falso)]
For any Excel version in Italian: [File.Nuovo(5)][File.Salva.con.nome("%s";1;"";Falso;"";Falso)]
Macro Open: the Excel macro to be used to open an existing document when ClicknDECiDE Builder sends data to an existing document, such as:
For any Excel version in English or in another language: [open("%s")]
For any Excel version in French: [Ouvrir("%s")]
For any Excel version in German: [Öffnen("%s")]
For any Excel version in Spanish: [Abrir("%s")]
For any Excel version in Italian: [File.Apri("%s")]
Macro Insert: the Excel macro to be used to insert data in an existing document when ClicknDECiDE Builder sends data to an existing document, such as:
Note: this macro must be in the same language as the Excel version.
To insert entire rows into an English Excel spreadsheet: [workbook.select("%s")][Select("%s")][insert(3)]
To insert only cells into an English Excel spreadsheet: [workbook.select("%s")][Select("%s")][insert(2)]
To insert entire rows into a French Excel spreadsheet: [sel.classeur("%s")][Selectionner("%s")][inserer(3)]
To insert only cells into a French Excel spreadsheet: [sel.classeur("%s")][Selectionner("%s")][inserer(2)]
To insert entire rows into a German Excel spreadsheet: [Arbeitsmappe.Auswählen("%s")][Auswählen("%s")][Zellen.Einfügen(3)]
To insert only cells into a German Excel spreadsheet: [Arbeitsmappe.Auswählen("%s")][Auswählen("%s")][Zellen.Einfügen(2)]
To insert entire rows into a Spanish Excel spreadsheet: [Libro.seleccionar("%s")][Seleccionar("%s")][insertar(3)]
To insert only cells into a Spanish Excel spreadsheet: [Libro.seleccionar("%s")][Seleccionar("%s")][insertar(2)]
To insert entire rows into an Italian Excel spreadsheet: [cartella.di.lavoro.seleziona("%s")][seleziona("%s")][inserisci(3)]
To insert only cells into an Italian Excel spreadsheet: [cartella.di.lavoro.seleziona("%s")][seleziona("%s")][inserisci(2)]
