Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Aug 30, 2025
Topics: 61 / Replies: 1580
Reply
RE: Connecting Websocket to Excel

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...

5 years ago
Reply
RE: Error in VBA Creating Multi-Select Drop Down List

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

5 years ago
Forum
Reply
RE: How to download XML data using Power Query to Connect to an API

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

5 years ago
Forum
Reply
RE: How to hide viewer bar in my file ?

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 ...

5 years ago
Reply
RE: Connecting to an OAuth API Like PayPal With Power Query

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 ...

5 years ago
Topic
Reply
RE: How do I connect to my email account (POP) using power query please.

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...

5 years ago
Forum
Reply
RE: Custom Column with Repeating Months and Also Consolidate

No worries. If there were prizes for badly formatted data exports then we'd have a contender. Phil

5 years ago
Forum
Reply
RE: How to hide viewer bar in my file ?

Hi Christine, Your image shows the workbook embedded in a web page so I'll need the address of that web page and the embed code you are using from ...

5 years ago
Reply
RE: Modified code to Send mail with two attachment.

Hi Yousef, I've used the code I wrote in this post and modified it slightly to do what you want. I also used the RangetoHTML function from Ro...

5 years ago
Forum
Reply
RE: Sending Mails from Excel

Hi Kaushik, As Purfleet said this has been covered many times, did you use the Search function at the top of the site? Searching for 'email' in th...

5 years ago
Forum
Reply
RE: Currency with decimal comma or point

Hi Miguel, If you know the file is from Spain then import it using the Spanish (Spain) locale es-ES? Likewise for the other countries. Phil

5 years ago
Forum
Reply
RE: VBA Loop for Account Amortization Table

Hi Scott, the workbook doesn't quite match up with the pictures or your description,so it's a little tricky to follow and I don't want to write cod...

5 years ago
Forum
Reply
RE: Custom Column with Repeating Months and Also Consolidate

Hi Florence, That data dump is in a really bad format for working with! I'm sure it's not you fault but it would make lives so much easier if data...

5 years ago
Forum
Page 44 / 110