Saturday, February 18, 2012

[VBA Excel] Connect the Access database and Show the data on Output Sheet

Simple to connect as M$ Acess Database via VBA Excel code and get this to sheet and range target, the code is advantage about one function name ConAccess and you can call this function pass format below

1:  Sub Con()  
2:    Call ConAccess("SELECT * FROM JobDetail", "Sheet1", "A1")  
3:    Call ConAccess("SELECT * FROM Machine", "Sheet1", "D1")  
4:    Call ConAccess("SELECT * FROM ReqDept", "Sheet1", "F1")  
5:    Call ConAccess("SELECT * FROM ReqSection", "Sheet1", "H1")  
6:    Call ConAccess("SELECT JobNo FROM JobDetail ORDER BY JobNo DESC", "Sheet1", "J1")  
7:  End Sub  

Saturday, October 25, 2008

Blogger Mod : Excerpt Articles and Read More Link..Part 2

5. Choose Edit > Find in 2 nd NotePad windows input only red text into the Find What's feild

"/b:skin"




Friday, October 24, 2008

Blogger Mod : Excerpt Articles and Read More Link..Part 1

1. Choose Template > Edit HTML > check Expand Widget Template in red marked.


Split String so simple and easy by VB function [vb split string]

1. Format of Raw Data for split You should know about data format for your spliting, such as 1.1 what delimiter ? space(” “) or slash(”/”) or mix format
1.2 what data type to convert
2. Function to use
Use Split Function for split data

Visual Basic Do It Yourself [vb diy]

Welcome to my Visual Basic Do It Yourself's blog.Here you will learn about Visual Basic Do It Yourself's tips and how to find good information.