app.run

Hi all Now I have 2 File -VBA_CONTROL_FCO_NEW -FCO_NEW [VBA_CONTROL_FCO_NEW] Run Macro open loop Open [FCO_NEW] file [FCO_NEW] run macro and save as (Change File name) and Close end loop Sub Macro2()Dim i As Integer For i = 1 To 6 Workbooks.Open...

i need to open FILE B and run macro in FILE B My Code Sub Marcodd() Application.Run "C:\Users\THJunsomPa\Desktop\3.Master ok Sell-out Promotion_Mar'16.xlsm!B_Clear" End Sub This Code is open File but cannot run macro[B_Clear] in file This Error

Hi, I'm currently working on a project that requires real-time (or updatable) data to be transferred from the web onto excel. I have a list of flights that are coming in next week. I need excel to pull the flight time, information, gate number, and arrival time of each flight. I also need...

Hi everyone, I'm looking after some huge Excel apps made by someone who has left the organisation, which no-one else knows anything about.. This one simply falls down on an app.run call, custom error message is: "Macro 'sxlReadItems' does not exist." The thing is, i've logged on to the...