Set xlapp = GetObject(, "Excel. 'Checks if excel is open, and names the current instance as xlapp, if not opens it and names it xlapp 'This runs the relevant create table and append queriesĭoCmd.OpenQuery "Query 4002 Grouped Data for Summary Comp Ladders", acViewNormal, acEdit 'Change these 2 if the Comp Ladder Summary spreadsheet is movedĮxcelLocation = "M:\Pricing\Products and Pricing\Archive Pricing Papers\" Private Sub updatecompetitorsladderssummary_Click() We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. I am having problems with Access opening an excel file and running a macro, it seems to open excel in a non visible format but I have no idea why?, I am sure I am missing something simple, and would appreciate it if some one could point me in the right direction. Dim d As Double Dim r As Double d 0.5 r (d) Regards.
0 Comments
Leave a Reply. |