Similar Threads
1. Variable as part of a variable name - VB Syntax
2. Transferring part of a multi-dimensional array to a range in VBA
I have a three-dimensional array (ex. TEST(1 To 2, 1 To 2, 1 To 360)) and I
want to transfer two dimensions (keeping the third as a constant) back to a
range. Is there any way to use the Value function to do this, instead of
creating a new two-dimensional array?
I tried: Sheets("FIRST").Range("FIRST").Value = TEST(1, 2, 360),
but I got a repetition of that one particular value. I can do it by
creating a new 2-D array, but this takes up a lot of code...Any help would be
appreciated...
Bob J.
3. Transmit Multipart data with part being binary
4. Simulate a multi-part form using httpSendRequest Post
I've been able to post variables to a webform using the wininet HTTP
POST functions. However when I try to add a file to the request, the
web page respondes with unknown variable for the file. I think I have
to create a multi-part request by adding additional headers/bodies to
the request, then use HTTPSendRequestEX and InternetWriteFile (to send
the file in parts). I've read all of the microsoft knowledgeBase
articles that referr to this however none show how to create a
multi-part request. Does anyone have a snippet of code showing how to
create the multi-part form?
Adolph
5. Delete part of the SYSTEM Path Environment Variable
6. change part of the PATH variable via scripting
Heres the scenario, the path is set to:
Path=C:\Program
Files\Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Querey;C:\Program
Files\Support Tools\;
and I need to ONLY change "C:\WINDOWS;C:\WINDOWS\System32\Querey;" so
that it correctly specifies "C:\WINDOWS;C:\WINDOWS\System32\Query;"
without messing up any of the path statement before and after it.
Can this be done with a script or command? Bonus if it can be done
remotely via scripting and without 3rd party compiled software.
7. Collection Problem Part 3 - Object variable not set - Visual Basic/VB
8. Storing part of a vba code line in a variable
Hello,
I'm trying to get a macro to check the values of a set of
textboxes in a vba userform, and create a single string of
their contents.
Any one or more of the textboxes might have text in them,
and the set of textboxes may be filled in multiple times
(basically, there are 5 available boxes for data. When the
user has filled them all in they have the choice of ending
there or using more boxes. If the click "More", the macro
will create a string of all the current values, then clear
them and allow the user to enter 5 more. This may continue
indefinately.)
In order for this to work, though, I need to put the vba
code representing the name of the userform textboxes into
a variable. The textboxes are named:
txtListItem1, txtListItem2, ... etc.
Here is the code I'm trying to make work:
----------------------------------------
Sub WriteList()
Dim ItemName as String, ItemNo As Integer
For ItemNo = 1 To 5
ItemName = "txtListItem" & ItemNo
If Len(Trim(ListString)) = 0 Then
If Len(Trim(ItemName)) <> 0 Then
ListString = ItemName
End If
Else
If Len(Trim(ItemName)) <> 0 Then
ListString = ListString & vbCr & ItemName
End If
End If
Next
End Sub
-------------------------------------
Of course, what is happening is the varible "ItemName" is
just being filled with the actual name of the textbox, not
the value of the textbox.
How can I get the ItemName variable to take on the value
of the textbox I'm naming?
Thanks!