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, 4 months ago.

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

    Ratel
    Participant

    Hi,

    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.

    #1099

    Emmett Ross
    Keymaster

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

    Thanks,
    Emmett

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

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