"Connection to the 'Transform Sample File from Pipeline Working' query in the workbook." _ "Query - Transform Sample File from Pipeline Working1", _ "OLEDB Provider=.1 Data Source=$Workbook$ Location=""Sample File Parameter1"" Extended Properties=""""" _ "Connection to the 'Sample File Parameter1' query in the workbook.", _ Workbooks("Book1").Connections.Add2 "Query - Sample File Parameter11", _ ListObject.DisplayName = "Table_ExternalData_1" "OLEDB Provider=.1 Data Source=$Workbook$ Location=""Pipeline Working"" Extended Properties=""""" _ "let" & Chr(13) & "" & Chr(10) & " Source = Folder.Files(""\\hofileserver\Accounts\ACCOUNTS\Lettings Stats 2018 Qtr 4\Pipelines\Pipeline Working"")," & Chr(13) & "" & Chr(10) & " #""Filtered Hidden Files1"" = Table.SelectRows(Source, each ? true)," & Chr(13) & "" & Chr(10) & " #""Invoke Custom Function1"" = Table.AddColumn(#""Filtered Hidden Files1"", ""Transform File from Pipeline Working"", each #""Transform File f" & _ ' Import Data from File for Pipeline PredictionsĪ Name:="Pipeline Working", Formula:= _ "Pipeline Working" is the name of the folder in which contains the workbooks to import, from there I'm already lost.Īny help appreciated. Upon running i immediately get a run-time error which when debugged highlights the first section and states "A query with the name 'Pipeline Working' already exists. I recorded the macro using exactly the steps i use if i were doing the task manually which i know works fine Use macro to get data from a folder in our company network containing about 15 workbooks which all have the same internal format and information but relate to different geographic locations
How to get macro recorder free free#
If this isn't the way to do it feel free to say so and i will dismiss the idea for the time being until i can do more research and write the code.Įssentially the steps I'm trying to achieve
How to get macro recorder free code#
I'll start by admitting Macro's are generally not my thing and writing the code certainly isn't - but in the situation and having read about recording macros i thought it could work for me.
0 kommentar(er)
