Automation, MS Excel.

Durand

Hello,
I make report for transfer a data in a Excel file with some sheet. I have a problem.
I do not reach to find the method to select a sheets of this file.
Thank you, Benoît Durand

Luc_VanDyck

Have a look at this topic

http://213.119.140.220:38001/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=5;t=000001

in the Tips & Tricks forum.

Durand

Hello, I make a report which feeds a file Excel (with several Sheets), according to different criteria, with a monthly frequency. The data are sent to follow.
I should so get back the address of the last cell. In VBA I use the following code:
ActiveSheet.SpecialCells(xlLastCell).activate
SLigne = Activecell.Address
I do not reach in C / AL with the previous answers, Thank you for the help.
Benoît Durand
<img border="0" title="" alt="[Confused]" src="images/smiles/icon_confused.gif" />

John_Tegelaar

Selecting the last active cell in VBA is done with:

ActiveCell.SpecialCells(xlLastCell).Select

In C/AL thris translates to:

XlApplication.ActiveCell.SpecialCells(11).Select;

Tip to find the numeric value for the xlConstants: Create a VBA macro where the same function is used, put the cursor on the xlConstant and press ctrl-I (I as in Isaac).

John