Microsoft Dynamics AX (Archived)

Open only File window

(0) Share

Report

Posted on by Community Member

hi guyz

i want to open only this window

when i click the export select excel button this button is in action pane
and there is my code

void clicked()
{

Dialog _dialog;
DialogField _file;
ExcelSpreadsheetName XLSX;
;
//Prompt to import excel
_dialog = new Dialog("Please select the file to load");
//_dialog.addText("Select file:");
_file = _dialog.addField(ExtendedTypeStr("FilenameOpen"));
_dialog.filenameLookupFilter(["@SYS28576",XLSX,"@SYS100852","*.csv"]);
_dialog.filenameLookupTitle("Upload from EXCEL/CSV");
_dialog.run();
if (_dialog.closedOK())
{
info(_file.value() );
}

super();

}

can any buddy solve this issue

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

window name is Upload from excel/CSV

i want open only Upload from excel/CSV form not microsoft dynamics Ax

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

If you check the Extended Data Type FileNameOpen in the AOT that you are using as well in your code, you would notice that it has a form reference for the SysOpenFileName form.

If you check the source code of that form, the answer is there on how to open the file name selection popup window through a Win32 API call for getOpenFileName.

You could implement similar logic for your case, if you do not want to bind your functionality to a dialog.

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

^ duplicate answer, it has been suggested above. That is indeed what you should check.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Vilmos Kintera and Sukrut Parab can u tell me that how to select work sheet from excel through this code

void clicked()

{

boolean _throw = true;

container conFilter = ["Microsoft Excel 97-2003 Worksheet (.xls)" ,"*.xlsx"];

Filename filename;

Dialog _dialog;

DialogField _file;

str strError;

int a=2;

SysExcelWorksheets worksheets;

SysExcelWorksheet worksheet;

SysExcelWorkbooks workbooks;

SysExcelWorkbook workbook;

CLRObject exc;

CLRObject innerExc;

CLRObject clrExcMessage;

ExcelSpreadsheetName XLSX;

;

//Prompt to import excel

_dialog = new Dialog("Please select the file to load");

//_dialog.addText("Select file:"); Microsoft Excel Worksheet (.xlsx)

_file = _dialog.addField(ExtendedTypeStr("FilenameOpen"));

_dialog.filenameLookupFilter(conFilter);

_dialog.filenameLookupFilter(["Microsoft Excel 97-2003 Worksheet (.xls)" ,"*.xlsx"]);

_dialog.filenameLookupTitle("Upload from EXCEL/CSV");

_dialog.run();

if (_dialog.closedOK())

{

info(_file.value() );

}

}

i want select also Work sheet from excel in dialogue box in lookup

i mean first i select Excel while i select excel then the work sheet is available in lookup

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

Please open a new topic for a new question. Also if you want to paste code select the Rich formatting editor and use the Insert code </> tag for correct formatting.

Was this reply helpful? Yes No

Community site session details

Open only File window

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Open only File window

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates