Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Excel and Navigate Worksheets
Hi Kevin and All Thanks for your code, but can you please help me how to apply this code because my knowledge of using VB in Excel is zero Should I apply this code on the Excel VB editor or what?? I would be very very appreciate if you can give me a brief step-by-step guide.....many many thanks!! :) Apart from the question I posted in my first thread, I would like to provide more information about thescenario. Kevin, yes you are right. These worksheets are linked. A new data input on those 5 main worksheets will also effect the rest 75 worksheets. Once all worksheets have be updated mannully, all essential data will be stored onto their My SQL database via Microsoft Access. Please anyone give me a brief guide to manage this problem because I am zero to VB and Excel . Thanks in advance!! Best Regards Violaplayer -- Violaplayer ------------------------------------------------------------------------ Violaplayer's Profile: http://www.excelforum.com/member.php...o&userid=16211 View this thread: http://www.excelforum.com/showthread...hreadid=276277 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a shortcut to view a list of all worksheets and navigate | Excel Discussion (Misc queries) | |||
Navigate between worksheets | Excel Worksheet Functions | |||
Is there a keystoke to navigate between worksheets? | Excel Worksheet Functions | |||
Is there a keystoke to navigate between worksheets in a workbook? | Excel Discussion (Misc queries) | |||
How do I navigate on a click between linked worksheets in Excel? | Excel Worksheet Functions |