terrypin Posted January 16, 2018 Report Share Posted January 16, 2018 Before I get going seriously on this macro I'd appreciate knowing whether - it's impossible? - It's possibe and someone's already done something similar and happy to share code? I have a macro (with several submacros) working in a couple of mapping applications, operating on walks/hikes/trips etc, call them all 'tracks'. For each track I capture about 50 text strings. I could get each to the clipboard immediately after they are captured. Or I could generate a list as I proceed and save a file (TXT or CSV) at the end of all the captures. I want to get them all into 50 specified (not consecutive) cells of a single Excel worksheet. If I choose the 'copy one at a time' method, I'd have to repeatedly return to my macro after pasting each one into Excel. If instead I go for the 'accumulate in text file' method I'd have to switch to Excel, import the text file and paste each of its 50 entries into their corresponding cells. My preference is for the first method. 1. it's less extra code to add to my macro and 2. if I make a mistake in the capturing at some point, I don't lose everything. But is that possible with Excel staying in the background, not flashing up 50 times, using Controls? Terry, East Grinstead, UK 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.