+ Reply to Thread
Results 1 to 3 of 3

Need to save workbook on cell changed by hot link.

Hybrid View

  1. #1
    Registered User
    Join Date
    07-12-2014
    Location
    Davidsville, PA
    MS-Off Ver
    2002
    Posts
    2

    Question Need to save workbook on cell changed by hot link.

    I am working on a project where a spreadsheet gets data from a PLC via RSLinx OPC. Any way that part works, and I have a macro that will save the workbook
    with a name from a cell, but i need to trigger the macro by changing a certain cell.

    This should be easy for somebody. Not me.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: Need to save workbook on cell changed by hot link.

    What cell do you want the macro to tr5igger on/

  3. #3
    Registered User
    Join Date
    07-12-2014
    Location
    Davidsville, PA
    MS-Off Ver
    2002
    Posts
    2

    Re: Need to save workbook on cell changed by hot link.

    I can write from the PLC to any cell. The problem is that change() doesn't work unless the change is entered from the sheet and not by the link.

    calculate() could work, but I don't know how to make it look at only one cell. do You??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to save the value of a cell everytime it is changed?
    By kemechev in forum Excel General
    Replies: 15
    Last Post: 06-19-2014, 07:46 AM
  2. Code to do Save as a specific cell value anytime the sheet is changed
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2014, 12:14 PM
  3. Run Macro if cell value changes auto because another workbook changed ?
    By dungeps in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 10:49 AM
  4. Save when cell is changed?
    By JP Romano in forum Excel General
    Replies: 2
    Last Post: 07-24-2009, 12:55 PM
  5. workbook changed by other user since last save...!
    By Cumberland in forum Excel General
    Replies: 1
    Last Post: 11-30-2006, 02:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1