Author Topic: problem with excel link 2.0  (Read 10044 times)

DLUN

  • Newbie
  • Posts: 18
    • View Profile
problem with excel link 2.0
« on: April 13, 2010, 02:44:37 PM »
I am using excel link to log values that are measured in my PLC.

I have got excel link to work succesfully when loggin data into an excel spreadsheet named "Book1.xls" and stored in the "my documents" folder.

When I try to change the name of the excel spreadsheet, or simply change the folder where the excel spreadsheet being used is saved. I get an error message in my microsoft excel workbook when I run excel link 2.0

The error message states that it can not find "newname.xls". I get this message even if i have already opened the "newname.xls" prior to pressing the run button is excel link.

Is this a common problem? Am I doing something wrong? Does excel link work with the latest version of microsoft excel?

support

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3174
    • View Profile
    • Internet Programmable PLCs
Re:problem with excel link 2.0
« Reply #1 on: April 14, 2010, 06:14:30 AM »
ExcelLink attempts to open the file from the MS Excel default location. It does not know the actual path of the .xls file so the file must be stored in the  default folder defined in MS Excel.
Email: support@triplc.com
Tel: 1-877-TRI-PLCS