Can I build a sentance from data tables in Excel?
 

I'd like to take data from different tables and create a sentance.
I've built a program to quote my companys products. Each quote is typed by a
secretary. If I could program the variables to create the sentances, it woud
streamline the process.

Can I build a sentance from data tables in Excel?
 

msg = "the pieman bought " & Range("A1").Text & _
" pies at the fair. Each pie had a retail value of " & _
Range("A2").Text & vbNewLine & "but our pieman" _
& " only paid " & Range("A3").Text & " per pie."
msgbox msg

--
Regards,
Tom Ogilvy


"dbizek" wrote in message
...
I'd like to take data from different tables and create a sentance.
I've built a program to quote my companys products. Each quote is typed by
a
secretary. If I could program the variables to create the sentances, it
woud
streamline the process.

Can I build a sentance from data tables in Excel?
 

Thanks, but I'm new to this and I don't understand all of it yet. I typed
that in but it didn't do anything. Is there someplace I can read up on the
subject, possibly showing examples?


"Tom Ogilvy" wrote:

msg = "the pieman bought " & Range("A1").Text & _
" pies at the fair. Each pie had a retail value of " & _
Range("A2").Text & vbNewLine & "but our pieman" _
& " only paid " & Range("A3").Text & " per pie."
msgbox msg

--
Regards,
Tom Ogilvy


"dbizek" wrote in message
...
I'd like to take data from different tables and create a sentance.
I've built a program to quote my companys products. Each quote is typed by
a
secretary. If I could program the variables to create the sentances, it
woud
streamline the process.

Can I build a sentance from data tables in Excel?
 

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Regards,
Tom Ogilvy

"dbizek" wrote in message
...
Thanks, but I'm new to this and I don't understand all of it yet. I typed
that in but it didn't do anything. Is there someplace I can read up on the
subject, possibly showing examples?


"Tom Ogilvy" wrote:

msg = "the pieman bought " & Range("A1").Text & _
" pies at the fair. Each pie had a retail value of " & _
Range("A2").Text & vbNewLine & "but our pieman" _
& " only paid " & Range("A3").Text & " per pie."
msgbox msg

--
Regards,
Tom Ogilvy


"dbizek" wrote in message
...
I'd like to take data from different tables and create a sentance.
I've built a program to quote my companys products. Each quote is
typed by
a
secretary. If I could program the variables to create the sentances,
it
woud
streamline the process.