I am taking data from a AB PLC and recorded it in excel. When a certain time is reached the macro prints to pdf and then should close out pdfcreator and clear all the data collected from the PLC. This whole time the PLC will be running. My problem occurs when it tries to close PDFCreator, it will freeze and when I end task it it gives me "Runtime error: 440; Automation error"
I have gotten the print to pdf to work for a excel sheet that isn't gathering data from a PLC, but I can't get it to work for the real thing. Some help would be nice, thank you.
I have gotten the print to pdf to work for a excel sheet that isn't gathering data from a PLC, but I can't get it to work for the real thing. Some help would be nice, thank you.
