Contact Me

Please feel free to contact me about anything on this blog @


16 thoughts on “Contact Me

  1. Hello Paul,
    while searching my issue with excel slicer macro, I came across your post and thought to ask you if you can help me on this. I’m trying to create a macro to copy a chart from excel to power point (2010). Very easy right? But, excel sheet has a slicer with 14 different region and has to click each one to populate the chart! Please help my job depends on this and I’m very new with vba and for loop. Thanks and will be waiting for your response.


  2. Hi Paul , your article ‘Creating Tables in Excel with VBA and External Data ‘ helped mein resolving a requirment for my develoment. Thanks a lot.

  3. Hi Paul,

    For finding out how items are selected in a slicer I used your solution below:
    I get a error in line :
    Set sl = sc.SlicerCacheLevels(1)
    “run-time error 1004
    Application defined/object defined error”

    Tried a lot of things but it does not do any good…
    Hope you can help me out …

    Thanks in advance,

    Function SelectedCount() As Integer
    Dim sc As SlicerCache
    Dim sl As SlicerCacheLevel
    Set sc = ActiveWorkbook.SlicerCaches(“Slicer_Country”)
    Set sl = sc.SlicerCacheLevels(1)
    For i = 1 To sl.SlicerItems.Count
    If sl.SlicerItems(i).Selected = True Then SelectedCount = SelectedCount + 1
    End Function

  4. Hi Paul,

    I was wondering if you could help me with an issue. I’m importing data from a CSV flat file to OLEDB destination, Problem is, the CSV TextQualifier is “, a speech mark, but I can’t find the appropriate value / attribute to use in the FlatFileFormat element. I’ve tried TextQualifier in the FlatFileFormat, and i’ve tried using it in the child Column element. BIML refuses to recognise it.
    What am I doing wrong?

  5. Hi Paul, you’re a genious, just figured it out…

    Typo, TextQualifier is actually called TextQualifer, no I before the E!!!! Its spelt with an extra I on the Varigence site

  6. Paul do you know how to disable the shortcutmenu when you right click a pivot table slicer (generated by powerpivot). So I do not want people to be able to right click on the slicer. Thanks in advance.

    • Hi Troy,
      I do but its not something I’ll willingly give out (sorry). The basic principles though are that you flag the table for incremental load and identify columns which identify the process (assuming there is always only one this can be part of the table meta-data but i prefer to use the column meta data to manage that).
      Then, if the table is marked for incremental load, you do the same thing that you’d do in SSIS -> store the max value from the column in a variable and only select data from the source which is > the variable value.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s