Links

This blog contains links to some topics.

Google
WWW http://amitmohantybbsrlinks.blogspot.com
Name:
Location: Bangalore, Karnataka, India

Tuesday, October 10, 2006

Microsoft Excel VBA

Browse Folder in Excel VBA
http://www.cpearson.com/excel/BrowseFolder.htm

Excel Tips and Techniques - Everything in Excel
http://www.contextures.com/tiptech.html

Excel To CSV
http://www.thescripts.com/forum/thread532593.html
http://groups.google.com/group/microsoft.public.vb.general.discussion/browse_thread/thread/a67c17706b54c852/b410f39426ae5348?lnk=st&q=convert+Excel+file+to+CSV+using+Visual+Basic&rnum=1&hl=en#b410f39426ae5348
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1425&lngWId=1

Creating Console Applications in Visual Basic
http://www.nirsoft.net/vb/console_application_visual_basic.html

How to look up a value in a list and return multiple corresponding values
http://office.microsoft.com/en-us/excel/HA012260381033.aspx

Using Microsoft Excel to Save a File to an FTP Site
http://www.kbalertz.com/Q211713/Using.Microsoft.Excel.aspx

Save Every Worksheet as its own Workbook
http://www.pcreview.co.uk/forums/thread-1004317.php

Excel
http://www.techonthenet.com/excel/index.php

How can I make sure that duplicate values are not entered?
http://www.mrexcel.com/tip008.shtml

Personal.xls in Excel
http://personal-computer-tutor.com/personalxls.htm

MS Excel How-to Articles
http://www.kayodeok.btinternet.co.uk/favorites/kbofficeexcelhowto.htm

Assigning Keyboard Shortcut
http://www.fontstuff.com/vba/vbatut07.htm

Identifying FaceID Values for CommandBar Images
http://www.j-walk.com/ss/excel/tips/tip67.htm

Does xlSortNormal exsist in Excel 2000 ?
http://www.mrexcel.com/board2/viewtopic.php?p=227844&highlight=&sid=ff0c8e85c2c055cc88a4cbdf8c39c0d3

Display a message on the statusbar using VBA in Microsoft Excel
http://www.exceltip.com/st/Display_a_message_on_the_statusbar_using_VBA_in_Microsoft_Excel/435.html

Managing State in Microsoft Excel VBA
http://www.billdawson.com/Articles/ManagingStateinExcel.html

Creating Custom Menus, Context Menu, Toolbars in Excel using VBA
http://www.ozgrid.com/VBA/custom-menus.htm
http://j-walk.com/ss/excel/tips/tip53.htm
http://www.romanpress.com/Articles/Menus_R/Menus.htm
http://www.fontstuff.com/vba/vbatut07.htm
http://www.mvps.org/dmcritchie/excel/rightclick.htm
http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/2f92cbc212b2480c/742af5ab9e2fe9db#742af5ab9e2fe9db

Working with Files, Folders, and Drives: More VBA Tips and Tricks
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office09072000.asp

Types of Tables in Oracle
http://www.technology-post.com/types-of-tables-in-oracle.html

Overloaded Functions
http://www.fmsinc.com/tpapers/vbaint/index.html

Alternative for CheckBox in an Excel Sheet
http://www.ozgrid.com/News/mar-2005.htm

Enable an Excel AddIn dynamically
http://p2p.wrox.com/topic.asp?TOPIC_ID=35348

Oracle Interview Questions And Answers
http://oracledatabase.tripod.com/

Visual Basic
http://www.vb-helper.com/index_api.html

Scope in VB
http://www.vbwm.com/art_1997/art_scop.htm

VB Performance Tuning
http://vb-helper.com/perform.htmhttp://www.aivosto.com/vbtips/vbtips.html

Index of Icons
http://www.twmu.ac.jp/U/icons/

List of Services
http://www.ozgrid.com/Services/

Excel Spreadsheets
http://buy4cheap.biz/?url=www.exinfm.com/free_spreadsheets.html

Check it out
http://www.microentrepreneur.biz/free-excel.html

Licensing and Deployment
http://edndoc.esri.com/arcobjects/9.0/ArcGISDesktop/DesktopDevGD_Ch4.pdf

File I/O Using VBA
http://www.applecore99.com/gen/gen029.asp

List of Face IDs
http://www.excelforum.com/showthread.php?threadid=470035

15 Microsoft Excel Lessons with Exercises
http://www.educationonlineforcomputers.com/blogs/post/Free_Microsoft_Office_Training_Tutorial_Resources/216/15-Microsoft-Excel-Lessons-with-Exercises

Row Insert Event
http://www.mrexcel.com/archive2/72100/83615.htm

Free Downloads for Microsoft Office
http://www.officearticles.com/misc/free_downloads_for_microsoft_office.htm

HOW TO: Determine When a Shelled Process Ends in Access 2000
http://support.microsoft.com/kb/q209876/

Exporting Excel Data in Special Formats Importing Text Files into Open WorkbookComparison of Three Sort

Methods
http://www.lacher.com/toc/tutvba2.htm

Excel Functions
http://www.meadinkent.co.uk/excel.htm

Build an Excel Add-In
http://www.fontstuff.com/vba/vbatut03.htm

UserForm With ComboBoxes
http://www.contextures.com/xlUserForm02.html

Excel 2002 VBA: Programmers Reference by Rob Bovey, Stephen Bullen, John Green, Robert Rosenberg
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764543717,descCd-download_code.html

Introduction to Pivot Tables
http://www.nacba.net/PDF_FILES/PivotTableIntroduction.pdf

Event for Sheet_Delete
http://www.mrexcel.com/archive/VBA/30066.html

Performance Improvements in Microsoft Excel
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Programming To The Visual Basic Editor
http://www.cpearson.com/excel/vbe.htm

Progress Bar in Excel VBA
http://j-walk.com/ss/excel/tips/tip34.htm

Excel Events
http://www.cpearson.com/excel/events.htm

Beyond Excel Help...check this out
http://ashishmathur.com/default.aspx

Suppress Dialog Messages
http://groups.google.co.in/group/microsoft.public.access.macros/browse_thread/thread/a3c76d060be4ffcc/6be167ac02effbf2%236be167ac02effbf2
http://groups.google.co.in/group/microsoft.public.excel.misc/browse_thread/thread/51c005ce8ddd4ffe/529fd8d217a953fb%23529fd8d217a953fb
http://groups.google.co.in/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/8f78ddc315e1a393/aa24e13b2f153dac%23aa24e13b2f153dac

File Opening in Excel
http://www.ozgrid.com/forum/showthread.php?t=51495
http://digiassn.blogspot.com/2006/03/excel-file-open-from-vba.html
http://www.cpearson.com/excel/BrowseFolder.htm
http://www.ozgrid.com/VBA/ExcelsDialogBoxes.htm
http://www.ozgrid.com/forum/showthread.php?t=17568

Excel Tips and Techniques
http://www.contextures.com/tiptech.html

Microsoft Excel VBA Examples
http://www.mathtools.net/Excel/VBA/
http://www.ozgrid.com/VBA/MiscVBA.htm
http://www.xl-logic.com/pages/vba.html
http://www.mindspring.com/~tflynn/excelvba.html
http://www.ozgrid.com/VBA/ExcelWorkbookEvents.htm
http://www.contextures.com/xlfaqMac.html
http://www.mrexcel.com/archive/VBA/index.html
http://dj.joss.free.fr/cell2.htm
http://www.archive.freeola.com/m.p.e.programming/
http://www.jumper.ch/english/prozeduren.htm

VBA: How To Delete a Sub Procedure After It Runs Once
http://support.microsoft.com/default.aspx?scid=kb;en-us;172109

Button on a worksheet that, when clicked, will email the same worksheet to someone.
http://www.mrexcel.com/tip016.shtml

Labels: , , , ,

0 Comments:

Post a Comment

<< Home