9.05.702 - Document Links - Opening Excel to a specific tab and

Here are some examples of how to call excel.  I installed excel on the server to make this work.

 

 

HTH

 

Greg

 

chWorkBook = vchExcelAppl:WorkBooks:Open("E:\EpicorOUT\RFQTemplate.xlsx").

chWorkSheet = vchExcelAppl:Sheets:Item(1).

 

ASSIGN vRow = vRow + 1

chWorkSheet:Range("A" + STRING(vRow)):VALUE = PartNum

chWorkSheet:Range("B" + STRING(vRow)):VALUE = LineDesc

chWorkSheet:Range("C" + STRING(vRow)):VALUE = IUM

chWorkSheet:Range("D" + STRING(vRow)):VALUE = MfgName

chWorkSheet:Range("E" + STRING(vRow)):VALUE = MfgPartNum

 

 

Sample below. I think I got from a progress site.

 

DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO.

DEFINE VARIABLE chWorksheet AS COM-HANDLE NO-UNDO.

DEFINE VARIABLE chWorkbook AS COM-HANDLE NO-UNDO.

def var cMyNewFile as char no-undo init "d:\MyPersonalNewExcelFilexx.xls".

def var cFileToDelete as char no-undo.

 

CREATE "excel.application" chExcel connect no-error.

if error-status:num-messages > 0 then

CREATE "excel.application" chExcel.

 

/* Open an Excel document */

chExcel:Workbooks:Add.

chExcel:visible = yes.

 

/* Add a new workbook */

chWorkbook = chExcel:Workbooks:Add().

 

/* delete eventually existing file*/

os-command silent del value(cMyNewFile).

/*OR*/

chExcel:DisplayAlerts = FALSE.

 

/*SaveAs*/

chWorkbook:SaveAs(cMyNewFile,,,,,,).

 

 

/* Quit Excel */

/*chExcel:quit().*/

 

/* Release Com-handle */

 

RELEASE OBJECT chWorkbook.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 12:58 PM
To: Yahoo Groups - Vantage (vantage@yahoogroups.com)
Subject: [Vantage] 9.05.702 - Document Links - Opening Excel to a specific tab and cell

 

 

I can open excel files linked in Epicor, but can you open to a specific TAB and CELL.

 

../Budgets/Annual/Budget2010.xlsx#'Sheet3'!A1     

Epicor doesn’t like the stuff after the file name,  #’Sheet3’!A1

Kicks a message that is doesn’t like the file path.

Anyone found a way around this? All comments welcome.

 

Patrick

 



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

I can open excel files linked in Epicor, but can you open to a specific TAB and CELL.
 
../Budgets/Annual/Budget2010.xlsx#'Sheet3'!A1     
Epicor doesn’t like the stuff after the file name,  #’Sheet3’!A1
Kicks a message that is doesn’t like the file path.
Anyone found a way around this? All comments welcome.
 
Patrick