terrypin Posted July 30, 2019 Report Share Posted July 30, 2019 Anyone here using VBA with ME/MEP please? I'm wondering if there's a better method than I'm presently using to get data out of Excel and into an MEP variable. For example my VBA to copy cell B3 in Excel to the existing MEP variable looks like this: Sub CopyTrackDescrToClipbrd() ' Copies contents of B3 in active TrackDataSheet to clipboard ' Remains on clipboard after macro finishes Range("B3").Copy End Sub And my MEP macro includes this: // Source is ACTIVE trackdata worksheet. Window Activate: .xlsm Wait for Window Title: .xlsm Delay: 0.2 seconds Text Type (Simulate Keystrokes): <ALT><F8> // Opens Excel's Macro dialog. Delay: 0.2 seconds Text Type (Use Clipboard and Paste Text): PERSONAL.xlsb!CopyTrackDescrToClipbrd Delay: 0.2 seconds Text Type (Simulate Keystrokes): <ENTER> Delay: 0.2 seconds Variable Set String %tTrackDescr% from the clipboard contents Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.