![]() To help you make macros like this, we built a free VBA Developer Kit and wrote the Big Book of Excel VBA Macros full of hundreds of pre-built macros to help you master file I/O, arrays, strings and more - grab your free copy below. It’s easy to copy and paste a macro like this, but it’s harder make one on your own. ![]() Make powerful macros with our free VBA Developer Kit Column Open "C:\Users\Ryan\Documents\wellsr\FundPrices.txt" For Output As # 1 For i = 1 To iLastRow For j = 1 To iLastCol If j iLastCol Then 'keep writing to same line Print # 1, Cells ( i, j ), Else 'end the line Print # 1, Cells ( i, j ) End If Next j Next i 'MsgBox "Failed to transfer "
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |