LinkBack URL
About LinkBacks
Let's say I wanted to export some data into plaintext in a certain format. For example;
[A1] {B1} (C1)
[A2] {B2} (C2)
[A3] {B3} (C3)
Where A1, B1 etc would have their respective values of course. How would I go about doing that?
Let's say I wanted to export some data into plaintext in a certain format. For example;
[A1] {B1} (C1)
[A2] {B2} (C2)
[A3] {B3} (C3)
Where A1, B1 etc would have their respective values of course. How would I go about doing that?
Post a dummy workbook, it will make it easier to make a suggestion.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Here you go. How would I have the plain text equivalent in the format I posted in the first post?
Where are you exporting to? And I am not quite sure how you want the text to be formatted. Can you show a before and after?
Anywhere even just a cell. It should be:
"[1] {Cat} (435)
[2] {Pizza} (24.2)
[3] {Girl} (86)"
Just that string in a single cell. But obviously it would be dynamic so it would update if I added another row to the table.
Ok, try this,
Last edited by JapanDave; 12-18-2011 at 05:39 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks