Search:
Type: Posts; User: bx51dtu
Search:
Search took 0.02 seconds.
-
Hi Westconn
I have almost reached the end. I have done a fair bit more work and it is looking pretty good. I have attached the sample work book together with a "what I am getting" image and "what...
-
Hi Westconn
I will do that tomorrow. I am making very slow progress. But, at the end of this, we will know an awful lot more about VBA based pivot tables than we did a week ago :-)
-
Hi Westconn,
Using the tabular layout, I am slowly getting there. The details being shown make sense though I still have to reduce the number of values. The screen is currently displayed as...
-
Hi Westconn,
Thank you very much for your response.
I have put the code in as you suggested and was over the moon to see that the pivot table was populated. I will have to look at the...
-
Hi again,
Am making a lot of progress thanks to your help.
I now have the three pivot table blocks being displayed but no content.
If I click anywhere in the block and look at the field...
-
Hi Westconn,
Yes, I found those when I noticed the commented out lines :-). I have made the adjustments to the original code and have the pivot table area showing for the first time (many thanks)....
-
Hi Westconn
I have just spotted a typo error in the workbook name further down the original code. I will dig around there.
Thanks for the guidance
-
Hi Westconn,
I made the changes but still not generating the pivot table.
The two changes I made were the following. Have I missed any?
Set HandoverPVTWorkbook = ThisWorkbook ' much more...
-
Hi Westconn
Thank you so much for your help, I will test this out and get back.
It is so frustrating getting 99% there but i guess the 1% is the fun part.
-
-
Hi Westconn1,
I have attached a zip file with the code and data in it. The contents can go from a handful of rows up to several thousand in any one day.
The contents of the file are :
XXXXX...
-
Hi again,
I hope you can help. I am trying to create a Pivot Table using Excel 2013 and VBA. The code appears to be error free but does not produce anything.
I use Msgbox (stripped out) to map...
-
Hi Techgnome, westconn1,
I did exactly what you said. I removed the range and stripped the SQL statement all the way back to "Select *" and it worked thereby proving the connection was ok.
I...
-
Hi Techgnome,
I made the changes as you suggested but it is still coming up with the same error.
The code is now:
sqlstring4 = "SELECT [xxxx_X], [xxxx_Y], [xxxx_Canx], Sum ([xxxx_Total_1]) As...
-
Hi Techgnome,
Many thanks for your very prompt reply. I shall try this tomorrow morning. Thanks again
-
Hi all,
This is a first time post and am using VBA to access a worksheet built in Excel 2013, extract information and group according to three fields.
The current version of the SQL string I am...
|
Click Here to Expand Forum to Full Width
|