Search:

Type: Posts; User: bx51dtu

Search: Search took 0.02 seconds.

  1. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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...
  2. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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 :-)
  3. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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...
  4. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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...
  5. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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...
  6. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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)....
  7. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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
  8. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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...
  9. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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.
  10. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    Zip file attached
  11. Re: Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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...
  12. Excel 2013. Creating a Pivot Table based on data in another worksheet using VBA.

    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...
  13. Re: Method not valid without a suitable object error

    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...
  14. Re: Method not valid without a suitable object error

    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...
  15. Re: Method not valid without a suitable object error

    Hi Techgnome,

    Many thanks for your very prompt reply. I shall try this tomorrow morning. Thanks again
  16. [RESOLVED] Method not valid without a suitable object error

    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...
Results 1 to 16 of 16



Click Here to Expand Forum to Full Width