From VB 6 Form: LaunchExcelFile "MyFile.xls"
In a module:
Sub LaunchExcelFile(FilePath As String)
Dim xlApp As New Excel.Application
Dim xlWkBk As Excel.WorkBoopk
Set xlWkBk = xlApp.Workbooks.Open(FilePath)
Set xlWkBk = Nothing
Set xlApp = Nothing
Because "xlAp.Visible=True" will be removed from above code, I don't want to open a new copy of MyFile.xls with each use.
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.