I'm trying to automate a records export - from FMP 5 to Excel 97 - so that users can easily transfer information by means of a single button.
I can do this with the 'Export' script step - but this leads me into problems with the destination file name. If a user is exporting data on a daily basis to the .slk file, I'll have to come up with a way of deleting the old file before creating the new (every day and for every user).
I think a simpler way to achieve the result desired is to copy the data, then paste it into an Excel file (I think DDE should allow me to make a filename the product of a calculation; so I can make sure each file generated is unique).
I wanted to have Excel run a macro to paste the record data into the file (and another macro before this to paste the title data into the first row, etc).
Now, I can get all this to work - but only occasionally. For some reason, wholly inexplicable to me, the DDE command line
[RUN("macroname")]
works - but only occasionally!
I've tested the copy part of my script (by going to Notepad and pasting; yes, the copied data appears).
I've tested the macro part of the script (by going to the Excel file and running the macro; it, too, pastes the data from the clipboard).
Why, then, is it not working altogether? Or, bizarrely, only sometimes?