Newbie needs major guidance PLEASE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rudyeb - 04 Mar 2005 02:28 GMT

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

Reply to this Message

Jezebel - 04 Mar 2005 02:42 GMT

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.

> Here we go; I want to be able to Enter a name and address of a company,
> the
[quoted text clipped - 11 lines]
> Many, many thanks,
> Rudy

Reply to this Message

rudyeb - 04 Mar 2005 12:30 GMT

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.

> 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
[quoted text clipped - 26 lines]
> > Many, many thanks,
> > Rudy

Reply to this Message