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.
|