Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I send some cells to an external text file?
Hello,
I have a spreadsheet in which: Column 1 contains (a number) price per unit. Column 2 contains (a number) quantity. Column 3 contains (a formula) sub-total. (price per unit x quantity) Column 4 contains (a number) sales tax rate. Column 5 contains (a formula) total. (sub-total x sales tax rate) + sub-total I need to give this spreadsheet to a person who has no Excel knowledge. Please help: How can I have the user click a button (or something like that) so that the above information is automatically written to an external text file? This auto generated text file should NOT contain the formulas. This auto generated text file should contain ONLY the values. Such price per unit, quantity, sub-total, sales tax rate and total. The text file will be printed as a "receipt". Thanks, Luther ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I send some cells to an external text file?
The user only has to do File=Saveas and Select "save as type" to be .CSV
That should be simple enough to explain. Why send the .CSV file. Then they have it. -- Regards, Tom Ogilvy lothario wrote in message ... Hello, I have a spreadsheet in which: Column 1 contains (a number) price per unit. Column 2 contains (a number) quantity. Column 3 contains (a formula) sub-total. (price per unit x quantity) Column 4 contains (a number) sales tax rate. Column 5 contains (a formula) total. (sub-total x sales tax rate) + sub-total I need to give this spreadsheet to a person who has no Excel knowledge. Please help: How can I have the user click a button (or something like that) so that the above information is automatically written to an external text file? This auto generated text file should NOT contain the formulas. This auto generated text file should contain ONLY the values. Such price per unit, quantity, sub-total, sales tax rate and total. The text file will be printed as a "receipt". Thanks, Luther ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
absolute cells when linking to an external file | Excel Discussion (Misc queries) | |||
Inserting text from external file into cells. | Excel Discussion (Misc queries) | |||
SAVE & SEND A FILE BASED ON TEXT IN A CELL VIA MACRO | New Users to Excel | |||
Trying to send an email with body text, to a range of cells | Excel Discussion (Misc queries) | |||
Get External Data, Import Text File, File name problem | Excel Programming |