Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Just a few questions...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Just a few questions...
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Just a few questions...
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 th 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 particularl helpful when coming to selecting reference books... Nic -- NickNic ----------------------------------------------------------------------- NickNick's Profile: http://www.excelforum.com/member.php...fo&userid=2552 View this thread: http://www.excelforum.com/showthread.php?threadid=38978 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Just a few questions...
Books:
http://j-walk.com/ss/books/bookxl19.htm http://www.amazon.com/exec/obidos/IS...779537-9426463 Tim "NickNick" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Two Questions | Excel Programming | |||
Two Questions. | Excel Programming | |||
2 Questions ? | Excel Programming |