ms-excel-vba
File Open Shell VBA
This video is a response to a comment on another video at https://www.youtube.com/watch?v=98t1yLUwmEo&lc=z13oevyrxxiyjpjdd221jthigmnmghv3l “Hello, where can I add code to open a specific excel document?” There is a more useful option to the Shell function, because I don’t have to name the file to open, and it’s already built in to Microsoft Office. You can […]
Resolution – VBA Error 49 – Bad DLL Calling Convention
So everything in this particular database was working for a client of mine, until just last night I get notified that he can’t open the database because of some error. I was able to view his screen using T.V. and after clicking on a command button, I would get the following error: “Error 49 – […]
Shell VBA function
Did you know that you can use the Shell VBA function to launch external applications? Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Private Sub btnLaunchExcel_Click() Dim strPath As String Dim strFile As String strPath = "C:\Program Files\Microsoft Office\Office14" strFile = "EXCEL.EXE" Shell strPath […]
Access Import Of Spreadsheet Or Table
I received an email question about the difference in importing an Access object versus an Excel spreadsheet. In this video you are going to find out how to import your spreadsheet or table using the access import feature and vba. Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: […]
How Do I Import An Excel Spreadsheet
How Do I Import An Excel Spreadsheet In this video you will find the answer to the question “How do I import an excel spreadsheet into my Access database?” Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Dim m_strFileName As String Private Sub btnImport_Click() […]