Last seen: Jul 3, 2025
If it's just the file existence you want to check, use: Sub Macro1() Dim TextString As String, FilePath As String, Pos As Long TextString ...
I guess you want to rebuild the Power Query Intellisense in VBA, to test if the syntax is correct before running the query? It's not realistic, thi...
If you only need the variables to be associated to the workbook where you import the code then you should be fine with the way you have it set now. ...
Can't tell which one is the best, as I don't know all details you have in mind. If you want to make some variables associated to any workbooks, how...
Hi Mark, Use this adjusted query: let Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content], #"Changed Type" = Table.TransformColumnTypes(S...
Can you clarify what exactly you need? What do you need to export?
Indeed, it's not possible to assign values in the declaration area, if they are not constants. You can use the Worksheet_open event to assign the v...
File attached.
Try another method: Sub GetWebPageLinks() Dim appIE As Object, itm As Variant Dim objCollection As Object Dim i As Long, LastRow As Long Dim sURL...
Have you studied the printed response from those websites?
Use Debug.Print to see the response, after the line: HTML.body.innerHTML = http.responseText Debug.Print http.responseText You'll have an idea of...
How can that person B have 2 Entry and only 1 Exit ? Sounds like magic... More, that Exit is before both entries. The function is looking for an...
Here is the updated code: Option Explicit Sub Create_and_Email_PDF() ' Author - Philip Treacy ::'' Date - 14 Oct 2013 ' Create a PDF from th...
Hi Nur, Cutting optimization is a complex problem, it's not just a formula. A complex algorithm is needed, see a problem description here: There ...
Try to encode the entire string: Uri.EscapeDataString("http://localhost:8080/BundleService-1.0.0/v1/bundles/Master/data/name:excel/derived/1.0.0/TabNa...