Contact Me

Please feel free to contact me about anything on this blog @ ptebraak@insightdm.net

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.

    Mash

  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.
    Regards,
    Shiv

  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,
    Olav

    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
    Next
    End Function
    Regards,
    Paul

  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.
      HTH,
      Paul

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s