Apr
29
answered SSIS Package returning less rows with MDX query
Apr
28
comment SSIS Package returning less rows with MDX query
Timeout is set as 0 so I don't think we are timing out, also the package executes without any errors at all. Query takes around 30 - 35 min to run in SSMS. Same user is running the queries in SSMS and in the SSIS package.
Apr
28
comment SSIS Package returning less rows with MDX query
Here are the connection string details Provider=MSOLAP.5;Integrated Security=SSPI;format=tabular; and I'm using a OLEDB data flow task.
Apr
28
asked SSIS Package returning less rows with MDX query
Jun
11
awarded Popular Question
Sep
26
awarded Famous Question
Feb
23
awarded Notable Question
Sep
24
accepted Problems when using RANKX on PowerPivot
Sep
19
accepted Keep excel table formatting after refreshing the table
Sep
14
comment Convert text to columns in Excel using VBA
Thanks a lot Chris :)
Sep
14
comment Convert text to columns in Excel using VBA
Got it, one more thing and I'll leave you alone, this is only working when I'm in sheet2, (but the buttong is on sheet1), is there way to make it work if I click the buttong on Sheet1?
Sep
14
comment Convert text to columns in Excel using VBA
It seems that when I try to assing the new cell range and last column it crashes, Set rngCRM = [O6] Set rngCRM = Sheets("Sheet2").Range(rngCRM, Cells(Rows.Count, rngCRM.Column).End(xlUp)) rngCRM.TextToColumns Destination:=rngCRM, DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1), TrailingMinusNumbers:=True Issue comes exaclty on the part where we get the last column
Sep
14
comment Convert text to columns in Excel using VBA
I tried to add another block of code but now with rng2 = [D], and it's not able to do it :(, it wont let me capture the range of the new column
Sep
14
comment Convert text to columns in Excel using VBA
One more questions, if I needed to do this for 2 columns, let's say column A and B, could I do it in a cycle or I should run this procedure 2 times?
Sep
14
accepted Convert text to columns in Excel using VBA
Sep
14
comment Convert text to columns in Excel using VBA
That worked like a charm I just added the Worksheet("Sheet") no the range :), Thanks Chris
Sep
14
comment Convert text to columns in Excel using VBA
Hello CHris, I tried your solution but I got this error, "Microsoft Excel can only convert one column at one time ... ". Any ideas?
Sep
14
comment Convert text to columns in Excel using VBA
I have tried, but it only works if I only have something selected, I want to make the selection dynamic (A7:A50000? or even better A7:lastnonempty cell?)
Sep
14
revised Convert text to columns in Excel using VBA
added 392 characters in body
Sep
14
asked Convert text to columns in Excel using VBA
1 2 3