Okay, so I'm a PLC programmer and not well versed in VBA code. What I'm trying to do is update my tables with arrays of data from the PLC and save the sheet as a pdf with the name of the order number. What I'm having trouble with is getting the code to start. We don't want a vba button or anything, I want it to start when the save bit changes from a 0 to 1, save the file, and do the same the next time the bit cycles. I'm unsure on how I get this to constantly look at that bit without needing a button, ideally I would just open the xlsm and have it save as it goes. Any help is appreciated.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!