Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Sub xcelFromAccess() Dim exApp As Excel.Application Dim exWB As Excel.Workbook Set exApp = New Excel.Application exApp.Visible = True Workbooks.Open "C:\tst_a.xls" exApp.Run ("ThisWorkbook.trnsData") Workbooks("tst_a.xls").Close exApp.Quit Set exWB = Nothing Set exApp = Nothing End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Stop macro from going to a different sheet in Excel||18||47|
|Combo box with two columns question||7||34|
|Access 2003, find all instances of database ODBC||3||43|
|Need macro to assign two digit numbers to selected cells in Excel 2016||3||31|
Join the community of 500,000 technology professionals and ask your questions.