vandel212
09-15-2008, 01:21 PM
I'm familiar with Visual Basic because I've taken classes at my school for it so i know the basic terminologies, but I have never edited a macro before and need some help.
With that said... What I am trying to do is to take cells from a excel 2007 spreadsheet, say A1 - G1, and copy them into a .txt file. Then I need to create a loop so that it copies the next 7 columns in row 1. So What I'm trying to figgure out is how to get the text in the cell from excel to a .txt file. Also what I can't figure out is how to increase the value of the columns because they are represented by letters so I don't think I can +1 to column A.
What may even work better is to just do 1 cell at a time, but none the less I would need to know how to increase the column letter for each pass.
If you need any more info I will be happy to reply. Thanks in advance.
With that said... What I am trying to do is to take cells from a excel 2007 spreadsheet, say A1 - G1, and copy them into a .txt file. Then I need to create a loop so that it copies the next 7 columns in row 1. So What I'm trying to figgure out is how to get the text in the cell from excel to a .txt file. Also what I can't figure out is how to increase the value of the columns because they are represented by letters so I don't think I can +1 to column A.
What may even work better is to just do 1 cell at a time, but none the less I would need to know how to increase the column letter for each pass.
If you need any more info I will be happy to reply. Thanks in advance.