Collins, Darryl
Darryl.Collins at anz.com
Thu Mar 18 21:13:56 CDT 2010
John, Coding in Excel in my bread and butter. Feel free to ask on or off line. The VBE is very similar to MS Access - if you can code in VBE Access you will pick up Excel very quickly. Open Excel, and press F11 to open the VBE In the VBE goto the View option on the menu Ensure you can view 1: Project Explorer (Ctrl+R) 2: Code Window (F7) 3: Properties (F4) 4: Locals Window (not absolutely necessary but very handy I find). In the explorer window you will only the sheet modules. You can code directly into these, but I usually put everything in modules. Insert Module will create a standard Module just like in Access. You can also insert Class modules (I know you like to play with those classes). "Option Private Module" up the top of the module will keep the code hidden from the user. I nearly always use this along with "Option Explicit" (just like Access). An Excellent mailing list for Excel help are: http://peach.ease.lsoft.com/scripts/wa.exe?A0=EXCEL-G <for general stuff> http://peach.ease.lsoft.com/scripts/wa.exe?A0=EXCEL-L <coding and more advanced stuff> X-posting is usually not necessary as most folks (including me) are subbed to both lists. I hope this helps. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, 19 March 2010 12:47 PM To: Access Developers discussion and problem solving Subject: [AccessD] Excel - HOW TO SEE MY MODULES COLLECTION I want to do some coding DIRECTLY in Excel. I know nothing about how to move around in the editor, see a list of all of the modules, rename a module, create a new class, save it, see that class and open it again etc. I am having a heck of a time finding anything using Google. Everything assumes I already know this basic stuff. HELP! -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com "This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."