Search:
Type: Posts; User: davidfongchoy
Search:
Search took 0.02 seconds.
-
Here's one way to save the .gif using an API call. Just specify the URL to the .gif in the argument to the function and an appropriate filepath:
Private Declare Function URLDownloadToFile Lib...
-
I don't think you Powerpoint has event handling for its presentations, but you could do the task in the code snippet below. You'll have to assign an on-show macro to initiate the do loop in the code...
-
Have your tried array formulas? Here's the exerpt from the Excel's Help. I've never used them, but it sounds like it might be what you are looking for.
About array formulas and how to enter them...
-
Without using a comm .ocx, you can use probably use the createfile, writefile, and readfile api's for some of your communication needs. Search the API section of this forum. There's a lot of good...
-
Since you can't make a custom formula with VBA, I think using an Excel pivot table will do the trick.
-
Volker-
I think the most foolproof way of handling this problem is the following. Excel can handle application level events, but the way to access it isn't like accessing events to lower object. ...
-
Thanks again for the response. It sounds like I am probably approaching this in the wrong manner. Could you suggest a better way? Ultimately, what I want to do is something like this:
Dim app...
-
Thanks for the help so far. I've been thinking about this a little bit more and I have an idea that I was wondering you could comment on. Please excuse me if there is a glaring error in my logic! ...
-
Using the VBA/VB GetObject() function, I am trying to access Excel as an automation server. My problem is that the GetObject() function only returns the first instance of Excel that was launched and...
-
If I could iterate through instances of Excel, I can identify the correct instance through the Application object. For example, I am interested in modifying a workbook that might already be openned...
-
I'm trying to use Automation in VBA to access a specific instance of Excel. I've been using the GetObject method to access Excel. However, it will only return the Excel object that was running...
-
Typically, I would have 18 {X,Y} pairs. The data is made up of triplicate observations at 6 input values. I hope this helps!
-
Thanks NotLKH and David for your insight so far. I really appreciate the input. Ideally, I'd like to use pure VB or VBA code. The vendor for the package that I have been using so far said their...
-
I am new to this math forum, and I hope that this is an appropriate place to post this question...
I need to fit data to the "4 parameter logisitic equation" for biological relationships. ...
-
I'm trying to use VBA to access a remote Oracle DB without a DSN or an Oracle client on my machine. Currently, I'm using my company's distributed (Powerbuilder) app to access the backend, but it...
-
Using DAO, I'm trying to copy to the clipboard an OLEObject field object so that I can paste it to an Excel document. I've been trying to use the GetChunk method of the Fields collection and setting...
-
I'm trying to multithread a VBA application, based on documentation that I've seen for VB. From what I have heard, I can use the AddressOf operator to pass a Long value to an API function that uses...
|
Click Here to Expand Forum to Full Width
|