Search:

Type: Posts; User: Kyle123; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    9
    Views
    966

    Re: User forms and keeping array variables

    You're going about it the wrong way, don't use the global/public variables at all.

    Let's fix the issue, not look for a workaround and take this back to basics. You pass variables to userforms (or...
  2. Replies
    9
    Views
    237

    Re: Runtime error 424 Object Required

    There isn't a shData sheet in your workbook, nor do you have a shInvoiceTemplate
  3. Replies
    9
    Views
    966

    Re: User forms and keeping array variables

    Don't use public variables if you can avoid it, pass variables to where they are needed
  4. Replies
    9
    Views
    966

    Re: User forms and keeping array variables

    It's because you aren't passing allData to the userform - you just need to pass it as a property (probably along with WeightData) - something like:

    Form:

    Private p_allData() As Variant
    Private...
  5. Replies
    9
    Views
    966

    Re: User forms and keeping array variables

    Why wouldn't the code in Module 2 be in the userform?
  6. Replies
    9
    Views
    966

    Re: User forms and keeping array variables

    It's very hard from your post to understand exactly what code you have where and it matters are we're looking at scope issues.

    Please post all the code from the module that is initializing the...
  7. Replies
    1
    Views
    68

    Re: Moving ToggleButtons

    The honest answer, though you may not like it is to simply not use ActiveX controls on worksheets. They're a common source of disgruntlement as they're very buggy on worksheets.

    You're better off...
  8. Re: VBA for Displaying Multiple Records based on row & columns

    Why not index match?
  9. Replies
    14
    Views
    485

    Re: VBA Looping pulling from web

    You aren't returning anything from your function, all it will do is overwrite the same 2 cells for every url in your list. You're also resizing a range to 17 columns, where I think you're only...
  10. Replies
    7
    Views
    184

    Re: VBA: Get value by Class name

    SomeWorksheet.Range("A1").value2 = html.querySelector(".price-details--wrapper .value").innerText
  11. Re: Any Excel VBA or Excel functions that can help with general lottery forecasting?

    xposted here: https://www.excelforum.com/excel-general/1285440-know-of-any-formulas-or-vba-for-some-lottery-prediction-tasks.html
  12. Replies
    7
    Views
    184

    Re: VBA: Get value by Class name

    Like this:

    Dim http As New XMLHTTP60, html As New HTMLDocument
    Dim source As Object


    With http
    .Open "GET", "https://www.tesco.com/groceries/en-GB/products/303105747",...
  13. Replies
    1
    Views
    568

    Re: Test Plan FOR Excel Workbook

    It’s not really clear what you are asking for, are you asking for advice on how to write automated/unit code tests in Excel?
  14. Re: Publishing in the internet via 'On line' excel version

    Hi Martin,

    No, there isn't. ActiveX controls and macros are not supported in Excel online
  15. Re: Macro buttons are gone after downloading workbook from website

    What type of buttons are you using?
  16. Replies
    2
    Views
    100

    Re: How save/use Subs from central storage

    Sounds like you should be using an addin
  17. Re: VBA HTTP request to scrape webpage links for a URL

    You could simplify the selection to the below


    Set WinHttpReq = CreateObject("MSXML2.XMLHTTP")
    WinHttpReq.Open "GET", File, False
    WinHttpReq.send

    html.body.innerHTML =...
  18. Re: VBA HTTP request to scrape webpage links for a URL

    You need to call this url, rather than the parent:
    https://www.theice.com/CommitmentOfTradersReports.shtml?rcMode=1&reportId=122

    The page you are calling is calling the url above, so in your...
  19. Re: Selecting another network printer vba - Office 365

    Don't iterate printer ports, you can read it from the registry very easily:


    Public Function GetPrinterPort(strPrinterName As String) As String
    Dim objReg As Object, strRegVal As String,...
  20. Re: SQL to multiply value from previous record ? How ?

    No, you can't use that SQL in Access, it doesn't support Common Table Expressions.

    You're quite right on using the primary key, the work around is to use the ROW_NUMBER function to create a new...
  21. Re: SQL to multiply value from previous record ? How ?

    In MSSQL it would be like this:

    ;WITH x AS
    (
    SELECT id, rate, RunningTotal = rate
    FROM test
    WHERE id = 1
    UNION ALL
    SELECT y.id, y.rate, convert(decimal(18,2),x.RunningTotal...
  22. Replies
    3
    Views
    235

    Re: Getting numbers from Random.org

    Note the different url in my code compared to yours, specifically https
  23. Re: SQL to multiply value from previous record ? How ?

    Are you actually using Access? THis is pretty straightforward in other dialects of SQL
  24. Replies
    3
    Views
    235

    Re: Getting numbers from Random.org

    You want this:

    Sub BattingRoll()


    Dim dsXMLObj As Object
    Dim dsURL As String
    Dim dsRespText
    Dim I As Long
    Dim dsBattingCol As Long
  25. Replies
    23
    Views
    1,060

    Re: VBA automate IE actions

    Yes, like this:

    Public Function IsVatNumberValid(ByVal countryCode As String, ByVal vatNumber As String) As Variant

    Static req As Object
    If req Is Nothing Then Set req =...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4