Re: [development-axapta] WinAPI Registry methods

2005-03-16 Thread Amund
ue = conpeek(reg,1); WinAPI::regCloseKey(hRegRead); } info(keyValue); """ The OLAPPivotTable & OLAPServerControlDSO classes also contains some examples. Amund Fri, 25 Feb 2005 15:47:51 +0800 skrev Raal Goff <[EMAIL PROTECTED]>: > > > Hi

Re: [development-axapta] Re: Build-in SysExcel* Class function not enough

2004-10-27 Thread Amund
".currentRegion.Rows.Count" in VBA. Amund Sat, 23 Oct 2004 02:08:49 - skrev kamchung322 <[EMAIL PROTECTED]>: > > > Hi Amund, > > Thank you for your help. > > I want to get the total no of rows in the SysExcelRange, something > like WorkSheets("Sheet1&

Re: [development-axapta] Wierd Excel COM behavior

2004-10-05 Thread Amund
Excel4MacroSheet, or xlWBATWorksheet. If this argument is omitted, Microsoft Excel creates a new workbook with a number of blank sheets (the number of sheets is set by the SheetsInNewWorkbook property). Remarks If the Template argument specifies a file, the file name can include a path. ""&

Re: [development-axapta] Access Outlook Appointments and Tasks through COM

2004-09-29 Thread Amund
help file VBAOUTL?.chm is a good place to start. Amund Wed, 29 Sep 2004 12:28:04 - skrev epg_edine_leroux <[EMAIL PROTECTED]>: > I would like to access the categories field on an Outlook > Appointment or Task from Axapta using the Com component. Does anyone > have any informat

Re 2: [development-axapta] Running Excel macros from Axapta through COM ?

2004-09-17 Thread Amund
instance. In effect this means you'll have to save and close your workbook before running any macro on it. A more elegant solution would probably be to write a VBA ClassModule with public methods which could then be referenced just like any built-in object. Hope this helps.. Amund

Re: [development-axapta] Running Excel macros from Axapta through COM ?

2004-09-16 Thread Amund
Inside VBA this would be something like: Application.Run "Workbook.xls!Macroname" From Axapta you can use: .Run("Workbook.xls!Macroname"); In general you may do what you want inside the macro recorder in Excel (or Word, or..) and use the resulting VBA-code almost as-

Re: [development-axapta] Create Word document from code (2)

2004-08-26 Thread Amund
There are also some code in the DocuActionCOM_Word class that could be useful. Amund Wed, 25 Aug 2004 17:02:34 +0200 skrev Harry Nilsen <[EMAIL PROTECTED]>: > Hi! > > > > I have to create a Word document based on a Word template with bookmarks > from code using dat

Re: [development-axapta] Create Word document from code

2004-08-26 Thread Amund
rfmt("Fax to customer %1.doc", custTable.AccountNum)); //or wd.documentPrint(...); wd.documentClose(); } } Looking at the vba code generated by the macro recorder in MSWord is quite useful for figuring out how to do a specific task. The vba code from MSWord can then easily be

Re: [development-axapta] using COM in-out params from Axapta

2004-05-21 Thread Amund
Hi, have a look at the [optional] parameters to the COMVariant constructor. eg: COMVariant comvar_in = new COMVariant(COMVariantInOut::In, COMVariantType::VT_VARIANT); COMVariant comvar_out = new COMVariant(COMVariantInOut::Out, COMVariantType::VT_VARIANT); Amund On Wed, 19 May