Exporting data to Excel Let’s Start Programming! › Forums › CATIA Macro Programming › Exporting data to Excel This topic contains 2 replies, has 2 voices, and was last updated by lal 2 years, 10 months ago. Log In Register Lost Password Viewing 3 posts - 1 through 3 (of 3 total) Author Posts February 16, 2015 at 2:21 pm #1546 lalParticipant Hi! I am now able to get data with my macro and I would like to export them to Excel but I have a problem. The main problem is to export a formula. Into Emmett Ross’s book it is written to use .Formula ex: Excel.Cells(2,13).Formula= “=NOW()” But when I try to do so, my column is empty: ExcelSheet1.Application.Cells(1, 1).Formula = “=RECHERCHEV(B1;export_articles.csv!$A:$B;2;FAUX)” (the formula works fine on Excel) By the way, I would like to change B1 by Bi with i the number of the row. Do you have any idea to help me ? 🙂 February 17, 2015 at 4:12 pm #1547 Emmett RossKeymaster So you’ve tried this exact code and nothing happens: oExcel.Cells(1,1) = "UPDATE" oExcel.Cells(1,3).Formula="NOW()" oExcel.Cells(1,3).NumberFormate="m/d/yyy" 123 oExcel.Cells(1,1) = "UPDATE"oExcel.Cells(1,3).Formula="NOW()"oExcel.Cells(1,3).NumberFormate="m/d/yyy" If you use the code above, do you get the text in cell A1 but nothing in cell C1? February 24, 2015 at 7:26 am #1551 lalParticipant Hum, in fact I resolved my problem (which wasn’t one). I’m French but it is not possible to use Excel Macro in French. So I have to use VLOOKUP (instead of RECHERCHEV) and use , and . instead of ; and , Author Posts Log In Register Lost Password Viewing 3 posts - 1 through 3 (of 3 total) The forum ‘CATIA Macro Programming’ is closed to new topics and replies.