int64.type

There's a Web Query in my workbook created on Windows that doesn't work if the workbook is opened on MAC and results in an error if trying to refresh it via vba and does nothing otherwise. I came across a variant of the following code on stack overflow which works to import the data from the...

Hello All, I am working on creating a VBA that takes a data set that has one row with multiple date columns and converts it to a a row for each date column. The Power Query function has worked great for this. The issue I am having is that since the VBA is looking at specific column names, this...

I'm wanting to import a CSV file into an excel workbook, and previously had just recorded this operation and tweaked the code generated from the recorder. Now with the PowerQuery / Get Data features in excel it wants to create a query connection which seems like overkill for my needs. Is it...

Hi i have made a date input variable as below(query Name DATETABLE which returns correct result eg 10 Apr 2018 let Source = Excel.CurrentWorkbook(){[Name="DATE"]}[Content], #"Changed Type1" = Table.TransformColumnTypes(Source,{{"ReportDate", type datetime}}), #"Changed Type2" =...

Hi I have the following code that - produces gives a single cell result and it works well with one exception The number of records in the data source varies, so the number of columns needing to be merged varies - and as these are hard wired they get missed if more columns added and query fails...