Type: Posts; User: westconn1
Search took 0.23 seconds.
you will find many examples in this and the VB6 forums and many more on google
one example here...
which line gives the error?
this does not look right, even if it works it would insert the images into the range for each cell in the column
i have requested this moved to office development
if you want an example for that, update the Visdata project included with VS6
the instructions are online
here is the link, in case anyone is interested
post a workbook with the code and some sample data
will appactivate work to some other window or application on the machines that give error?
are they using 32 or 64 bit os?
are you filling in a web form or a dialog box?
for webforms, i am sure...
set revs = doc1.revisions
For Each r In revs
what have you tried so far?
try doevents after inserting cell
you need to supply more details and what code you are using that does not work correctly
what are you actually trying to send to the internet explorer window?
what operating system?
when the code stops, it normally will go into debug mode, but if it is not there is some error handing code that overrides the default break mode
you need to find where the error handling is...
i am sure your users would appreciate if you were to use a userform, instead of all those message boxes, all the information could be entered into textboxes with some radio buttons to choose the...
if excel is available to automate, you could just use the worksheet function
MsgBox ("You got " & numberCorrect & " out of " & numberCorrect + numberWrong & ", " & UserName), vbApplicationModal, " IT Quiz"
if msgbox("start again?",vbyesno) = vbyes then start...
on the CD
silly as it may seem the VBA help file is an optional install when installing office
i always do a custom install so i can select VBA help and deselect the stupid office assistant...
most of the information is in the vba help file, that is where i looked the value
unfortunately, as there are multi values for importance, vba true = -1, is not one of them,...
numbercorrect = 0
numberwrong = 0
after displaying the result
or before starting the next set
you may need doevents within the code to create presentations, to allow the cancel button to be processed
is this actually in VBA (visual basic for applications)?
looks like VB.net, for which this would not be the correct forum, though someone may answer
if it is vb.net, better to pm an mod and ask...
do you set the count back to zero after each set?
the only real use for the tab index is to change the order that controls can be moved to by tabbing
most controls also have an unused tag property that can be assigned a string for a reference of...
.importance = olImportanceHigh
.OriginatorDeliveryReportRequested = True
what is the problem and what are you trying to achieve?
not required, there is a callback method
all credits to authors
some mods and testing by me as part of a current project
'Please include the following comment in your source code
does your code write to vba modules?
either way show the code that has problem, indicating which lines break the code
or better post a sample workbook that demonstrates the problem
the cell where you click the mouse becomes the activecell, so you can return activecell.row etc, but there is no way to tell if the cell was activated by mouse or keyboard
try, display the userform modally
you can try like
for each itm in objsourcefolder.items
Set cpy = itm.Copy
cpy.UnRead = True
Nextof course this does not take into account if the item has...
you could use
for each ele in wb.document.all
you could also try
for each ele in doc.getelementsbytagname("h5")
which would be better, but i have not tested if this is valid for header tags
there are hundreds of examples in this forum, but each page is specific, you can try like
set frm = wb.document.forms(1)
frm.all("usename").value = text1
frm.submitchange element names and...
you can use a static variable within the procedure like
Application.ScreenUpdating = False
Dim lngI As Long
if not runalready then
you can use application.wait, but you would need to specify the time to wait, based on some expectation
it there are variables used in the sql it will fail or cause errors when read from a text file, which may indeed increase the time to execute
regardless of what language is used to call the query, possibly this would be better answered in the database forum, but if you can not post the sql query (even if proprietry information is...
you could try
buttonelement.disabled = true
once you have set an object to the button element
then put them in a table, with an empty cell between or padding
yes, i could not make the vlookup work within existing formula, though it tested fine within someother cell, but figured it should be possible with all information to hand
you can try a function like
Function manyfiles(fn As String)
mypath = Left(fn, InStrRev(fn, "\"))
ext = Mid(fn, InStrRev(fn, "."))
tmp = Mid(fn, InStrRev(fn, "\") + 1)
you could try <br> or <p>
Click Here to Expand Forum to Full Width
Survey posted by VBForums.