Search:

Hi!

I run the code again and received these:

The table spreadsheet data must be in the same table
160069
160071

Here is my Power Query Macro, and this works:



ActiveWorkbook.Queries.Add Name:="Result03052018", Formula:= _
"let" & Chr(13) & "" & Chr(10) & " Lähde =...

Let's clarify the means I am trying to get here.
1. I have csv-file.
2. I have Power Query code from previous query.
3. I want to import the csv-file through the Power Query code to workbook.
...

strPath includes full path,
strName should include filename without extension.

On this line


With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _
"OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=strName;Extended Properties=""""" _
...

Here is the updated code:


Private Sub Workbook_Open()
Dim intChoice As Integer
Dim strPath As String
Dim strName As String

'change the display name of the open file dialog...

I edited the code so it now has the strname assigned with something :)

I'am open for any kind of help, so that i get this working.

Hi!

I have made working excel workbook but now I want to change it.
I have imported data from csv-file with Power Query, removing few rows from top and bottom, and reformat few values in the...