Excel Macros (VBA) Tutorial
Section 2: Excel VBA Vocabulary 13 lessons. Developing ... Lesson 17: Working with Excel Database and Filters ... Working with Windows and other Microsoft Programs FROM Excel. With VBA ...
http://www.excel-vba.com/excel-vba-contents.htm
-
2/4/2010 10:46:37 AM
Hits:
57
Last Viewed:
2/8/2010
Rating:
No Rating
Votes:
0
|
|
|
Tutorial on Excel Macros (VBA)
Section 2: Excel VBA ... thousand VBA words but you will really need only 100 to talk with Excel about workbooks, worksheets, cells, databases ... with other programs in VBA for Excel
http://excel-vba.com/
-
2/5/2010 9:22:31 PM
Hits:
13
Last Viewed:
2/8/2010
Rating:
No Rating
Votes:
0
|
|
Anthony's Excel VBA Page - VBA Project - Excel Consultant - Excel ...
... VBA code and programs, finance and statistics Modeling, and Excel Consulting. Anthony Sun is an Excel Consultant and data analyst specialized in Excel programming and database ...
http://www.anthony-vba.kefra.com/index_002.htm
-
2/6/2010 12:42:57 AM
Hits:
2
Last Viewed:
12/12/2009
Rating:
No Rating
Votes:
0
|
Visual Basic for Applications - Wikipedia, the free encyclopedia
VBA programs which are written to use the OLE ... Writing Excel Macros with VBA. Sebastopol CA: O'Reilly. ... Office XML formats · Smart tags · Visual Basic for Applications ...
http://en.wikipedia.org/wiki/Visual_Basic_for_Applications
-
2/6/2010 10:08:27 AM
Hits:
116
Last Viewed:
2/4/2010
Rating:
No Rating
Votes:
0
|
INSERT into Access Database from VBA for Excel
You are currently viewing the Excel VBA section of the Wrox Programmer ... sConn = "ODBC;DSN=MS Access 97 Database;" sConn = sConn & "DBQ=C:\Program Files\Microsoft Office\"
http://p2p.wrox.com/excel-vba/58670-insert-into-access-database-vba-excel.html
-
2/5/2010 1:58:42 PM
Hits:
6
Last Viewed:
1/6/2010
Rating:
No Rating
Votes:
0
|
|
Access Automation – VBA compact current database - Excel Help ...
Access Automation – VBA compact current database OPEN SOURCE: Hey! ... "C:\Program Files\Microsoft Office\Office10 ... Excel Help & Excel VBA Help Best Practices Forums ...
http://www.ozgrid.com/forum/showthread.php?t=51272
-
1/30/2010 8:43:42 AM
Hits:
0
Last Viewed:
No Views
Rating:
No Rating
Votes:
0
|
Microsoft Excel - Wikipedia, the free encyclopedia
Since 1993 Excel has included Visual Basic for Applications (VBA), a ... moving data automatically from various programs — and Excel ... save queries on external relational databases ...
http://en.wikipedia.org/wiki/Microsoft_Excel
-
2/5/2010 11:24:13 PM
Hits:
17
Last Viewed:
2/1/2010
Rating:
No Rating
Votes:
0
|
|
Excel - My Excel Pages
Microsoft Knowledge database (MS KB) - VBA; Links to some ... Department TA Training Program (Santa ... Microsoft Excel for Windows -- Visual Basic for Applications 101 [archived copy]«
http://www.mvps.org/dmcritchie/excel/excel.htm
-
2/5/2010 6:06:16 AM
|
Excel Topics
Excel; Word; Database. SQL; Oracle / PLSQL; UNIX. General UNIX ... Excel is a spreadsheet and analysis program released by Microsoft. ... VBA Functions (By Category) Hyperlinks: VBA ...
http://www.techonthenet.com/excel/index.php
-
2/2/2010 9:54:43 PM
|
|
Querying External Data in Excel
Querying External Data in Excel: What is ... Delete a query with VBA Change the SQL with VBA Change the database location ... ODBC;DSN=MS Access 97 Database;DBQ=C:\Program Files ...
http://www.dicks-clicks.com/excel/ExternalData3.htm
-
2/4/2010 1:52:44 PM
Hits:
3
Last Viewed:
1/26/2010
Rating:
No Rating
Votes:
0
|
Querying External Data in Excel
Querying External Data in Excel: What is External Data ... Whenever you change the SQL in VBA, you have to ... ODBC;DSN=MS Access 97 Database;DBQ=C:\Program Files\Microsoft Office ...
http://www.dicks-clicks.com/excel/ExternalData5.htm
-
2/5/2010 12:29:49 AM
Hits:
0
Last Viewed:
No Views
Rating:
No Rating
Votes:
0
|
Programming Excel with VBA and .NET - O'Reilly Media ...
Learning VBA. Chapter 1 Becoming an Excel Programmer Why Program? ... DAO.Database and DAO.Databases ... on Excel VBA, Using Excel Visual Basic for Applications ...
http://oreilly.com/catalog/9780596007669/
-
2/5/2010 6:59:21 PM
Hits:
1
Last Viewed:
12/28/2009
Rating:
No Rating
Votes:
0
|
Advantages And Disadvantages Of Microsoft Excel Database Application ...
Advantages And Disadvantages Of Microsoft Excel Database Application Tips about Microsoft Excel VBA programming ... application into one file it can be huge and will make your program ...
http://msexcelvba.blogspot.com/2008/05/advantages-and-disadvantages-of.html
-
2/5/2010 10:34:06 PM
Hits:
3
Last Viewed:
7/28/2009
Rating:
No Rating
Votes:
0
|
Import data from Access to Excel (ADO) using VBA in Microsoft Excel
» Import data from Access to Excel (ADO) using VBA in Microsoft Excel VBA ... that will allow the user to connect to any data base through a application created in the VBA program.
http://www.exceltip.com/st/Import_data_from_Access_to_Excel_(ADO)_using_VBA_in_Microsoft_Excel/427.html
-
2/4/2010 2:14:12 PM
Hits:
1
Last Viewed:
9/21/2009
Rating:
No Rating
Votes:
0
|
How To Use ADO with Excel Data from Visual Basic or VBA
... How To Use ADOX with Excel Data from Visual Basic or VBA ... makes it possible to treat an Excel workbook as if it were a database. ... compiled version of the program ...
http://support.microsoft.com/kb/257819
-
2/4/2010 8:12:07 PM
Hits:
4
Last Viewed:
2/2/2010
Rating:
No Rating
Votes:
0
|
ExcelUser -- Programming Excel
Using VBA to program Excel. ... UserForm In Microsoft Excel 97, you can use a custom UserForm and a Visual Basic for Applications ... in the ODBC database driver that ...
http://www.exceluser.com/help/vba/long014.htm
-
2/5/2010 4:14:43 PM
Hits:
0
Last Viewed:
No Views
Rating:
No Rating
Votes:
0
|
VBA - The Excel Working Partner
... or change the Sub name so that it is called by an Excel event in a way similar to what we did in our Word VBA program. ... In more advanced applications, we could query a database or ...
http://visualbasic.about.com/od/learnvba/l/aa022203d.htm
-
1/29/2010 11:22:22 AM
Hits:
0
Last Viewed:
No Views
Rating:
No Rating
Votes:
0
|
Is it possible to run an Access query from Excel?
It demonstrates how to use SQL in Excel's VBA to: * create a database, * create a table ... > =SQL.REQUEST("DSN=MS Access Database;DBQ=C:\Program Files\Microsoft > Office ...
http://help.lockergnome.com/office/run-Access-Excel--ftopict880828.html
-
2/1/2010 7:22:35 AM
Hits:
0
Last Viewed:
No Views
Rating:
No Rating
Votes:
0
|
Pro-business Excel VBA Programming
This question is only when the excel database has no records in it. The next time, when ... It always happens to me that whenever I put a password protection in my Excel/VBA program ...
http://msexcelvba.blogspot.com/
-
2/1/2010 12:48:53 AM
Hits:
1
Last Viewed:
9/26/2009
Rating:
No Rating
Votes:
0
|
VBA Tips: Fill a UserForm Combo Box List from a Database
Do you want to learn more about Access, Excel and VBA? Are you ... designed for communicating with databases. Microsoft Access, being a database program, already ...
http://www.fontstuff.com/vba/vbatut10.htm
-
2/6/2010 12:14:19 AM
Hits:
1
Last Viewed:
11/4/2009
Rating:
No Rating
Votes:
0
|
Excel VBA Book - VBA and Macros for Microsoft Excel - from Mr Excel
As the macro language for Microsoft Excel, Visual Basic for Applications ... to being able to write their own useful programs. ... Adding a Record to the Database; Retrieving Records ...
http://www.mrexcel.com/vbabook.html
-
1/22/2010 3:38:13 AM
Hits:
5
Last Viewed:
9/16/2009
Rating:
No Rating
Votes:
0
|
Database connection , retrieve data from database, querying data into ...
The entire VBA program can be downloaded in an excel file at the end of this web page or just copy and paste the code directly from the page! Code Public Sub database_connection ...
http://vbaexcel.eu/vba-macro-code/database-connection-retrieve-data-from-database-querying-data-into-excel-using-vba-dao
-
1/30/2010 11:17:01 PM
Hits:
0
Last Viewed:
No Views
Rating:
No Rating
Votes:
0
|
Excel | Microsoft Excel | Excel Tips from MrExcel
We offer expertise in VBA (Visual Basic for Applications), Lotus to Excel ... Visual training on Excel and other Microsoft Office programs with ... guide to developing Access databases.
http://www.mrexcel.com/
-
2/1/2010 12:05:56 AM
Hits:
11
Last Viewed:
1/12/2010
Rating:
No Rating
Votes:
0
|
ExcelUser -- Excel Databases
Home > Excel Help Portal > Excel Databases ... This article contains a Microsoft Visual Basic for Applications macro for Excel ... Affiliate Program : Excel Help Portal
http://www.exceluser.com/help/data/long001.htm
-
2/6/2010 2:01:41 AM
Hits:
0
Last Viewed:
No Views
Rating:
No Rating
Votes:
0
|