Search:

Type: Posts; User: GBeats

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    506

    Re: Updating formulas for future rows

    AMEN to VBA, i personally never bothered with formulas for this exact reason, they work for basic home finance level calculations but the level of complexity with formulas just seems to exponentially...
  2. Re: Syntax Styles, Shortcuts and binding in VBA

    Does this indirectly point to my problem with arrays that a posted a few days ago regarding variant string arrays and actual string variants?
    ...
  3. Replies
    6
    Views
    555

    Re: Novice Macro Amendment Question

    Both the posts (i didnt check the links but im sure they are good) should be good, the example i also left is basically be the same as what 'westconn1' said (he left the actual way we would code it)...
  4. Re: ByRef type mismatch passing a variant array to a function

    I am think this problem is something ive had before and it is all to do with passing incorrect types through arrays, variant string types im guessing are not string types internally (i am guessing)...
  5. Replies
    6
    Views
    555

    Re: Novice Macro Amendment Question

    Hmm, macro recording is a great way to learn some code on parts of excel lets say that your not familiar with, but it is NOT a place to start learning VBA or any other language for that matter.

    i...
  6. Re: ByRef type mismatch passing a variant array to a function

    AddEmail(Trim(test(i, 2)), lst)


    Private Function AddEmail(eMail As String, lst As EMailList) As EMailList

    the error was occurring on the first part passing test(i, 2), i added the trim part...
  7. [RESOLVED] ByRef type mismatch passing a variant array to a function

    Hi

    i cant figure out and i forgot how this happens.

    im getting a ByRef mismatch when im passing a variant/array to a function, the function fails when its called

    any ideas?


    Data =...
  8. Re: Syntax Styles, Shortcuts and binding in VBA

    Haha, and i try to be so disciplined with my conventions. i think im going to try using this convention for a bit and see if it improves my time coding, it certainly looks faster.
  9. Syntax Styles, Shortcuts and binding in VBA

    I have a questions that i think have obvious answers but i just wanted to ask some of you guys here.

    I come accross every now and then someone who uses a convention in VBA syntax that almost looks...
  10. MsOf13 Re: Is it possible to provide version control of modules?

    You would normally do this from outside, you version a file not part of a file.

    If i had to do this i would either version your entire excel file or import your modules from outside of excel....
  11. Re: XMLHTTP GET, passing API parameters

    Just before i mark the thread resolved. Thanks.

    What tool are you using in your previous post?
  12. Re: XMLHTTP GET, passing API parameters

    Great!!

    This works


    Public Function Profile_Get(APIKey As String, Name As String, Employer As String) As String
    'Dim xmlhttp As Object
    'Set xmlhttp =...
  13. Re: XMLHTTP GET, passing API parameters

    OK, i am going to try a few things here

    ill add the header for the content type
    ill try a single parameter first
    ill try 2 parameters

    i have a question regarding the URLEncoded part, If i use...
  14. Re: XMLHTTP GET, passing API parameters

    Thanks, yes i found that. however i couldnt make it work, i tried alsort of variation in the string and arrays and alsort, i cant find documentation on how to do this either thats not java or python....
  15. [RESOLVED] XMLHTTP GET, passing API parameters

    Hi

    When accessing a Web API using http(s) you can do it a couple of ways i gather, the simplest way is to just put a URL with all the parameters and send it.

    The other way im trying to achieve...
  16. Replies
    3
    Views
    687

    Re: Paint filling/drawing on an Access form?

    Windows API can overlay color onto something i guess but how will you find the boundaries of a random image?

    Maybe use MSPaint as a control and make that work

    a simple 'cheat' i would consider...
  17. MsOf10 Re: Function acts as if it's volatile but it isn't

    I would guess the function is used inside the sheet on a formula, and the calculations are triggering it.
  18. Replies
    2
    Views
    580

    MsOf10 Re: VBA - Transpose?

    Can i add something very critical to the OP statement ''something more elegant than a loop"

    You will find after testing that a VBA loop is faster 90% of the time compared to Excels built in...
  19. Re: Challenges Working with winsock and Ms Access VBA

    Edit: i was sending an example that may help but its VB.ET (i didnt check), im not sure if you can use this, but the code should be almost the same for VBA. My intent was to show a sample to see the...
  20. Replies
    3
    Views
    584

    Re: VBA Get Internet Connection Status Problem

    i just stumbles upon something that might be possible to use

    Possibly something you can use

    its running a ping using shell, now to automate this process your going to have to grab the window...
  21. Replies
    4
    Views
    461

    MsOf10 Re: Invalid Property Value Mystery

    In a nutshell, First change the property of the combobox to allow items not listed, change to your code, instead of running code on the _Change event use the _Keypress event and the _Exit event to...
  22. Replies
    4
    Views
    461

    MsOf10 Re: Invalid Property Value Mystery

    Your selecting an item thats not in the combobox list, your property on the combobox is set not to allow this.
  23. Replies
    7
    Views
    893

    Re: Winsock, what is it?

    @Niya, thanks
    i will have a play with that, its always something i wanted to try a server-client setup but never had the opportunity to.
  24. Re: VBA store data from file in web to matrix

    I was looking at the first post you make and you said it took around 30s to get a months data, downloading day by day, If the website isnt offering API and only offering a day by day basis, 30s isnt...
  25. Replies
    7
    Views
    893

    Re: Winsock, what is it?

    Packets are broken down on the NIS level (my memory fails me) if im not mistaken, but its not wrong to have a packet inside a packet, the entire hardrive is working on packets if you think about it,...
  26. Replies
    7
    Views
    745

    MsOf13 Re: Problem with loop the VBA

    :afrog: mark as resolved, glad you fixed your issue
  27. MsOf07 Re: EXCEL Macros quit working: My Set EXCELWorkBook = Statement fails

    I might be off here but i never entertained the idea of opening and getting a reference through get object etc when you can open and get a reference using excels built in methods. i do remember...
  28. Replies
    7
    Views
    745

    MsOf13 Re: Problem with loop the VBA

    you set i as an object, westconn's example is using i numerically. try changing the type of i to a numerical one or make another variable 'j' maybe and use that instead
  29. Replies
    7
    Views
    893

    Re: Winsock, what is it?

    does this work like an interface might work on .NET, maybe a more broader setup, or more like a router would provide a connection to anything connected to it.
  30. Re: VBA store data from file in web to matrix

    excel is single threaded but i run into a way to multi thread it, its a pretty ingenous idea that i have not used it myself but im aware of it, i cannot point you to the code that was posted it was a...
  31. Replies
    7
    Views
    745

    MsOf13 Re: Problem with loop the VBA

    Since nobody can see your inbox, we can only assume certain things.

    1, The loop is looping through 'Items' in the inbox - What exactly is in the inbox folder

    2 the If statement (Class = 43)is...
  32. Replies
    7
    Views
    873

    Re: Closing a window using VBA

    Please mark the thread Fixed or watever :D

    yes you wil get a prompt to save the file if changes are made turn alerts off using this method

    if you dont care about prompts use kill
  33. Re: VBA store data from file in web to matrix

    possibly that your running a loop calling data over the internet is a problem, im shocked you only have a 3 minute problem and not a 3 hour problem, ive done this only a few times so im not a master...
  34. Replies
    7
    Views
    893

    [RESOLVED] Winsock, what is it?

    I have never used or ever even had anything that brought me near this part of programming. since we have an unanswered post just below this post im very curious about it and what its implementation...
  35. Replies
    4
    Views
    529

    Re: Excel VBA to MAC issue

    i would love to have a VM setup, but i just dont have resources for this kind of thing, and this is the first time i worked on Mac/Office setup. The guy actually stopped replying to me, i was hoping...
  36. Replies
    4
    Views
    529

    Re: Excel VBA to MAC issue

    I am using vbnullstring throughout the code, but it maybe that its just not doing what i think it is. the other times im using it is setting a value, maybe the if statement is affecting it...
  37. MsOf13 Re: [Word] Excluding punctuation from tracked changes counts

    https://docs.microsoft.com/en-us/office/vba/api/Word.Document.Words

    Indeed white space characters and punctuations are counted as words, a workaround could be to add a 'Select case' statement into...
  38. Replies
    10
    Views
    1,435

    Re: VBA Macro gets slower with every execution

    Office is far from perfect, in fact the more you use it the more problems you find with it. workarounds are generally the way to go in these cases.

    I recommend setting up something that just...
  39. Replies
    4
    Views
    529

    Excel VBA to MAC issue

    Hi

    Im working on a project that is driving me a little loopy, im developing a very simple macro using very basic vba code and it works fine on my side but it just doesnt want to 100% work on a...
  40. Replies
    12
    Views
    1,608

    Re: Type Mismatch in SQL Data Query

    maybe reading in no data as 0 and catching and dealing with it would suffice?



    SELECT [IMPPARTID] FROM [Sheet1$] WHERE [SHAPE] = 'BAR' AND CASE([SIZE] = '' THEN 0 ELSE [SIZE] END) = 4 AND...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width