Hi,
i am using sub like:
Sub Test
thisworkbook.refreshall
msgbox "Done"
end sub
but msgbox part is not triggered. Somehow code is stopped on thisWorkbook.refreshall...
Can anybody help?
For power query i am using:
let
Source = Excel.Workbook(File.Contents(fnGetParameter("File Path"))),
t_ips_Table = Source{[Item="t_ips",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(t_ips_Table,{{"ID", type text}, {"IP", type text}, {"Subnet", type text}})
in
#"Changed Type"
and it is working like a charm but i do not have option "Enable query in background".
Please help,
Jacek
Bookmarks