M
Hi folks!
Can anybody tell me, quickly, the best way to save an Excel file using an
external application?
I have a spreadsheet which is logging information from an RSView
application, I need to archive the file automatically on an event triggered
by a PLC, with a filename relating to the current date and time.
I could use Sendkeys, or trigger a VBA script in the workbook, but these
seem a bit complicated. I cannot seem to find the correct DDE command to
use.
Any help will be gratefully recieved.
Regards
Mark
Can anybody tell me, quickly, the best way to save an Excel file using an
external application?
I have a spreadsheet which is logging information from an RSView
application, I need to archive the file automatically on an event triggered
by a PLC, with a filename relating to the current date and time.
I could use Sendkeys, or trigger a VBA script in the workbook, but these
seem a bit complicated. I cannot seem to find the correct DDE command to
use.
Any help will be gratefully recieved.
Regards
Mark