Just a few questions...

[NickNick]

I'm kinda new to programming (did a fair bit of HTML many years ago.... ) and would like to learn a bit of Visual Basic which would help with some of the projects I'm trying to do at work. I think that maybe I'm being a bit ambitious, but would appreciate any help with a few questions!

The first one is sales related which will record things like name/address, products required and card details. This form is then printed off and the details that were input to the form then need to be saved to a seperate workbook (for auditing purposes).
- Will the printed version of the form appear the same as form the person inputs to, or can a more aesthetic version be created?
- When the data is transferred to the workbook, does the file have to be open or can it remain 'closed' in a shared directory?
- If the above is possible, can more than one person post to the same file?

The next one's a bit easier! Can you recommend any Visual Basic (for use in Excel) books?? - Preferably ones available in the UK.

Thanks for your help,

Nick

[Nigel]

Try using Outlook as your address manager.....

There are several books on VBA try searching :-

http://www.amazon.co.uk/
search term: Excel VBA



--
Cheers
Nigel



"NickNick" <[email protected]> wrote in
message news:[email protected]...
>
> I'm kinda new to programming (did a fair bit of HTML many years ago....
> ) and would like to learn a bit of Visual Basic which would help with
> some of the projects I'm trying to do at work. I think that maybe I'm
> being a bit ambitious, but would appreciate any help with a few
> questions!
>
> The first one is sales related which will record things like
> name/address, products required and card details. This form is then
> printed off and the details that were input to the form then need to be
> saved to a seperate workbook (for auditing purposes).
> - Will the printed version of the form appear the same as form the
> person inputs to, or can a more aesthetic version be created?
> - When the data is transferred to the workbook, does the file have to
> be open or can it remain 'closed' in a shared directory?
> - If the above is possible, can more than one person post to the same
> file?
>
> The next one's a bit easier! Can you recommend any Visual Basic (for
> use in Excel) books?? - Preferably ones available in the UK.
>
> Thanks for your help,
>
> Nick
>
>
> --
> NickNick
> ------------------------------------------------------------------------
> NickNick's Profile:
http://www.excelforum.com/member.php...o&userid=25520
> View this thread: http://www.excelforum.com/showthread...hreadid=389789
>

[NickNick]

Thanks for the reply Nigel but that's not quite what I'm looking for...

The information we collect and kept is:
- Name of person taking the call, date, time, department to receive the order.
- Customer's name, address, contact number, credit/debit card type, card number, expiry date.
- Details of tickets required (including number of adults, children) dates they are required for and the cost; any reservations with dates, times, seat numbers and resevation references.

I've already had a look at Amazon and I don't find it particularly helpful when coming to selecting reference books...

Nick

[Tim Williams]

Books:
http://j-walk.com/ss/books/bookxl19.htm
http://www.amazon.com/exec/obidos/IS...779537-9426463

Tim


"NickNick" <[email protected]>
wrote in message
news:[email protected]...
>
> I'm kinda new to programming (did a fair bit of HTML many years
> ago....
> ) and would like to learn a bit of Visual Basic which would help
> with
> some of the projects I'm trying to do at work. I think that maybe
> I'm
> being a bit ambitious, but would appreciate any help with a few
> questions!
>
> The first one is sales related which will record things like
> name/address, products required and card details. This form is then
> printed off and the details that were input to the form then need to
> be
> saved to a seperate workbook (for auditing purposes).
> - Will the printed version of the form appear the same as form the
> person inputs to, or can a more aesthetic version be created?
> - When the data is transferred to the workbook, does the file have
> to
> be open or can it remain 'closed' in a shared directory?
> - If the above is possible, can more than one person post to the
> same
> file?
>
> The next one's a bit easier! Can you recommend any Visual Basic (for
> use in Excel) books?? - Preferably ones available in the UK.
>
> Thanks for your help,
>
> Nick
>
>
> --
> NickNick
> ------------------------------------------------------------------------
> NickNick's Profile:
> http://www.excelforum.com/member.php...o&userid=25520
> View this thread:
> http://www.excelforum.com/showthread...hreadid=389789
>