Forum

Hi Chris, Yes I saw that in the workbook so if that is what you want as a result, I don't understand what you are asking for help with as you've al...

Hi Chris, That query is throwing an error because you don't have a Column named QTY but I think that may be beside the point. You've only got 2 ...

You're welcome.

Hi Lionel, I wasn't sure if you wanted the results grouped by caller number or not. The example result in the post (above) isn't the same as the e...

Hi Francis, Do you want the cumulative total grouped by something, like Account? Regards Phil

Hi Bob, Use DisplayFormat.Interior.Color to get the color set by CF e.g. Debug.Print Range("A1").DisplayFormat.Interior.Color see attached fi...

Hi Bob, This works fine for me Sub xxxx() Dim finalcol As Long finalcol = 2 Range(Cells(1, 1), Cells(20, finalcol)).Select End Sub s...

Hi Jamie, That code as you've pasted it works if there is a named range called DataC4 on the ActiveSheet - see attached file. The code will allo...

Hi Steven, I can't get this to work because every time I try to authenticate with Polygon I just get the message back "authentication failed". I...

Hi Jamie, Please supply your workbook, impossible to debug without it! Phil

Hi Faiz, Fruugo uses Basic Authentication (not OAuth). Their documentation states Authentication is handled with HTTP Basic - method. The cred...

Hi Christine, Did you try putting that code into the example HTML file I provided here because it worked right away to hide the viewer bar ...

Hi Zeeshan, As I explained in my email, I don't understand how you can't 'extract' the query. Just open the PQ Editor and it's there. Below is ...

Hi Chris, I'm not aware of a way to connect PQ to read from your PST file. If your email was connected to Exchange that would be a different matte...