Excel 2007 : Button on Workbook to export data to Text file?

[NewYears1978]

I hope I can explain this properly.

I have a work form we use for keeping track of parts that we need to order. We are trying to streamline the process.

Currently we have a simple worksheet that has several columns, quanity, part #, part description.. etc.

I want to put a button in the worksheet that will take the data in columns 1 and 2 and basically have it format it a certain way and then either copy that to the clipboard or export it to a text file or something?

For reference just say my first two columns are Part # and Quanity
and just say current I have 12-38528 and 5 in those columns respectively.

I want it to export the data like this

[code]
i,12-38528,5
/[code]

The next row would follow below the above line in the same manner

I know this is a bit ..non simple (for me anyways) So even if you just direct me to some helpful information that would be great, thanks in advance for any advise.


(For reference the reason for this is our wholesaler has an online ordering system that we find clunky but they have a text formatted entry where it can load string data from a file..so this is why I need this)

EDIT:
I forgot to mention that I know I can save as CVS file and it will basically work as I want..the problem is this exports all data whereas I only want to export 2 columns... thanks!

[shg]

How about recording a macro that adds a new workbook, copies the data, saves as a text or csv file, then closes the new workbook?

Then someone can help you tweak from there.

[NewYears1978]

Hey that's a pretty nice idea.

I didn't realize you could to that with macros..I've never used them, I will look into that.

I was messing with the CVS or Text file formats and couldn't get it quite right (like it would add quotes before each column etc when all I want is data,data)

Will keep messing with it and try out some macros.

Any other advise appreciated also.

Shg, thanks as always

[NewYears1978]

I actually go tthis working just fine, unfortunately it turned out not to be the best method for what we are doing.

It would be better if we could have the data pulled from excel file and pasted into a webbrowser (like A1 cell pasted in box 1 of the website form)..

But this isn't anything possible is it?