Search:
Type: Posts; User: GBeats
Search:
Search took 0.06 seconds; generated 5 minute(s) ago.
-
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...
-
Does this indirectly point to my problem with arrays that a posted a few days ago regarding variant string arrays and actual string variants?
...
-
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)...
-
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)...
-
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...
-
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...
-
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 =...
-
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.
-
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...
-
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....
-
Just before i mark the thread resolved. Thanks.
What tool are you using in your previous post?
-
Great!!
This works
Public Function Profile_Get(APIKey As String, Name As String, Employer As String) As String
'Dim xmlhttp As Object
'Set xmlhttp =...
-
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...
-
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....
-
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...
-
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...
-
I would guess the function is used inside the sheet on a formula, and the calculations are triggering it.
-
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...
-
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...
-
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...
-
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...
-
Your selecting an item thats not in the combobox list, your property on the combobox is set not to allow this.
-
@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.
-
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...
-
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,...
-
:afrog: mark as resolved, glad you fixed your issue
-
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...
-
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
-
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.
-
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...
-
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...
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|