leoce7
Last Activity: Nov 18 '08, 09:43 PM
Joined: Aug 20 '08
Location:
-
Microsoft Internet Controls (Inet)
I'm trying to write a macro in excel 2003 to use the "Microsoft Internet Control' reference library to access data from a web page. The problem is that it won't let me dimensionalize Inet controls even though I have added the reference ... i.e "Dim inet1 as Inet" is not allowed. Does anybody have any experience with Inet controls through excel? -
I've generated programs that plot lines (polynomial, linear, exponential ... doesn't matter to a program) real-time by utilizing a picture box. All you need to do is correspond pixels to predetermined grid lines. Actually, this can be done statically or dynamically as it is plotted. You can draw lines, circles, connect lines, etc. using this. It is all pretty straight forward. Some helpful properties would be...
.forecolor... -
multiple ways ....
EXAMPLES (1-Dimension)
A) Declaring array...
1) dim temp() as integer: redim temp(1 to 8)
2) dim temp(1 to 34) as integer
C) Accessing array...
temp(INDEX) = INPUT
The parenthesis indicate that the declaration is for a new array.
This is extremely basic stuff but you can make arrays much more complicated when you start...Leave a comment:
-
Hey!
Ok so at a quick glance ....
Your initial case, "Select Case ("I3")" ... I'm not sure it is recognizing this because it is not told that it is a cell/single range. This statement assumes an arbitrary string "I3" rather than (what I assume you intend) the cell I3. Also, if you are having trouble changing the "value" of range I would suggest using the following instead: Cells(Row_Index ,...Leave a comment:
-
Refer to KeyPress, KeyDown & KeyUp events ........ lots of info for these and fairly straight forward. I would make a function for the event and pass in as a parameter which key was pressed and then utilize a "Select Case" structure followed by ASCII code identifiers to process which keys were pressed and how to proceed.Leave a comment:
-
If you want it a little less hard coded with the option of interpreting different initials ........ here is a crude example of a function you may want to try:
' =============== =============== =============== ============
Public Function StringManipulat ion(str As String)
Dim str2 As String
Dim index, i As Integer
Dim c, cN
' trim leading/trailing spaces & make...Leave a comment:
-
Is it just the .FileSystem property that doesn't work? What about .DriveType or .ShareName? If the drive isn't ready yet you could code in a delay possibly before you try to retrieve drive attributes using the Sleep feature or timer.Leave a comment:
-
Rename files longer than MAX_PATH using WIN32 API (VBA)
I need some help renaming a file that has a full path length longer than MAX_PATH (>260). I can locate the files using WIN32 API ("\\?\" recognition for long paths, etc.) coding and have actually developed a workaround using the Dir commands as a secondary route with appropriate error trapping as well. My problem simply is that I have located the file but now need to rename it. Neither the "Name" statement nor FSO's .movefile...
No activity results to display
Leave a comment: