Writing a range to a text file ?
-
Hello everybody, i'm new to VB and i need to write a macro for Execl with VBA :~ . I'm trying to save a part of table to a text file. I know alreay how to makr this part with the range function, unfortunately there's nothing like range.save() . Can you tell me how to write it to a text file? Thank you very much in advance :-)
-
Hello everybody, i'm new to VB and i need to write a macro for Execl with VBA :~ . I'm trying to save a part of table to a text file. I know alreay how to makr this part with the range function, unfortunately there's nothing like range.save() . Can you tell me how to write it to a text file? Thank you very much in advance :-)
I'm no expert in the Excel object model, but it looks like you'll have to iterate over the cell values in your range, one by one, and write them out to a text file yourself. There's nothing that's going to do it for you. But, I could be wrong. I don't do any Office coding but maybe once every couple of years...
Dave Kreskowiak Microsoft MVP - Visual Basic