Newbie needs major guidance PLEASE

[rudyeb]

Here we go; I want to be able to Enter a name and address of a company, the
square footage of their roof and have this information go to my excel
spreadsheet and arrive at a cost to replace the roof. Then I want that
figure to go to a letter that will put in the name address, etc and also the
square footage and type of roof in a specific area of the proposal and at
the end enter the price from the excel spreadsheet. Then I want to be able
to print this completed document. Is this something that can be done using
VBA or am I dreaming? If it is do-able can you please guide me in any way
possible to get the information I will need to make this all happen. I want
to thank you in advance for any help anyone can provide.
Many, many thanks,
Rudy

 

[Jezebel]

It's certainly do-able, but if you're starting completely from scratch
you're throwing yourself in the deep end and you'll drown. Start by writing
this specification in detail: what are all the steps, and what happens if
the user changes their mind or discovers they made a mistake at a previous
step?

Why start with Word? -- You could do all the data entry in Excel, and use
Word only for the output. Eliminates a step, anyway.

But the basic problem is that there is a lot of devil in the detail with
this kind of programming. These are not questions to which you can get
reasonable answers from forum posts. You'll end up learning by trial and
error, which is VERY SLOW. Go buy a book on VBA programming and start with
that.

 

[rudyeb]

Your positive reply is good to receive and appreciated. I understand that it
won't come easy but to know it can be done and how to start is very helpful.
Thank you.