Let’s Start Programming! Forums CATIA Macro Programming Extract the content of a closed excel file

This topic contains 1 reply, has 2 voices, and was last updated by  Emmett Ross 3 years, 6 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #1084



    I am looking for a simple method to extract the content of a cell in a closed Excel workbook and put it in a message box of a Catia macro.

    What I found:

    Excel.ExecuteExcel4Macro MsgBox (“‘C: \ Users \ Desktop \ [Feedback_Data.xlsx] Sheet1’ $ B $ 2!”)

    It works well when I put it inside a cell in another workbook, but it does not work when I run it from vba catia.

    Any ideas?

    Thank you.


    Emmett Ross

    Hi Ratel. When you try to run your code from CATIA does it give you an error or does it do nothing?


Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘CATIA Macro Programming’ is closed to new topics and replies.