Beyond Excel: VBA and Database Manipulation:

excel

1

March 17, 2015  10:36 AM

Create MS Access Database with Just Excel and VBA

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker
excel

We don't need MS Access to create MS Access databases. Excel's VBA can create them. Here is sample code: Dim oCatalog As Object
Set oCatalog = CreateObject("ADOX.Catalog")
oCatalog.Create "provider='Microsoft.ACE.OLEDB.12.0';" & _
"Data...

October 20, 2014  12:45 PM

Executive Dashboard Must Have Add-in

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker
excel

If you have dreams of developing executive dashboards in Excel, you need this add-in. Bookmark and Share     0 Comments     RSS Feed     Email a friend


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: