MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Private Sub Command0_Click() Dim x2 As Object Dim x3 As Object DoCmd.RunMacro "Export Sales Update2" ' Export sales data excel workbook (SalesUpdateNew.xlsx) to c:\ Call WaitFor(5) ' Wait 5 seconds Set x2 = CreateObject("Excel.Application") x2.Workbooks.Open ("C:\Documents and Settings\USER\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB") x2.Visible = True Call WaitFor(5) ' Wait 5 seconds Set x3 = CreateObject("Excel.Application") x3.Workbooks.Open ("C:\SalesUpdateNew.xlsx") x3.Visible = True x3.Application.Run "Personal.xlsb:SalesUpdate" End Sub
|Access on Mouse move||5||29|
|Access check if a table is open||4||38|
|Access Open Report with SQL Parameter||11||28|
|Setting Macro in Access to Automate Running an Append at a Certain Time||2||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!