Creating multiple variables from a single copy action (MS Excel)

[herrevjan]

I think you may run into an issue with how Excel ends up in the clipboard which potentially makes it a bit more complicated to split the data (depending on the content).

I think running this part as part of your Macro to “clean-up” the clipboard before starting to split:

Creating file from Clipboard results in incorrect Tabs and Lineshifts

Hey @herrevjan, Da. You're running into an unexpected consequence of working with Excel's proprietary clipboard. I'm a bit surprised that Keyboard Maestro's Remove-Styles filter doesn't solve this, but it's easy enough to work around. -Chris Microsoft Excel -- Write Clipboard to Text File.kmmacros (5.6 KB) [image]