Type: Posts; User: westconn1
Search took 0.29 seconds.
glad you have it sorted
i will go back to vba land
the full code sample in the last post is all vba anyway, though not hard to convert
i can not see in this new code if objTerminGruppe2 is now a folder, or still an item collection object?
try deleting the cache entry for the url first
it is not relevant which year you use, it only returns the month name
yes, but not comprehensively
that was what my code does
not enough information
replace whole paragraph text
you can do like this
For m = 1 To 12
Selection.Find.Execute Format(DateSerial(Year(Now), m, 1), "mmmm")
If Selection.Start > 0 Then
that would defeat the whole purpose of terminal services
do some use (or try to use) the current widows default printer? whether selected specifically or not?
how is the printer selected?
i had not tested any, and no they do not work, excel must treat them differently
have tested with most types of text files, dat file exe file zip file, and some others, the last 2 listed give...
with events variables must be dimensioned in object modules, not general modules, best to use the thisworkbook module
Public WithEvents app As Application
Private Sub app_WorkbookOpen(ByVal wb...
if you create an application with events object
you can run an ontime procedure from the application workbook open event, that will return the name of any file dropped onto an open excel window,...
you would have to use an API getcommandlineargs, though i believe there is some bug with this and need to use getcommandlineargsex
i remember doing an example on this some years ago, i will see if...
if there is no application.filedialog in powerpoint, as with outlook
Set cd = CreateObject("MSComDlg.CommonDialog")
cd.InitDir = "C:\temp"
cd.Filter = "imagefiles|*.jpg"
should make no difference,
i was using an existing folder, as i believed you were doing, maybe that is the problem
here is another example
Set cal =...
so try changing the code to
For Each oPara In ActiveDocument.Paragraphs
If InStr(1, oPara.Range.Text, "<!--Mobile-->") = 1 Then
you can add a program to the right click menu, so that it will copy to the clipboard or a variable
windows 7 and maybe vista already have this built in, from memory it is shift right click, copy...
post a sample document for testing
i would think not in .net
this is a fully tested working example
Set itms = GetNamespace("mapi").GetDefaultFolder(olFolderInbox).Items
Set tgtitms = itms.Parent.Folders("test").Items
For i = 1 To itms.Count
that did not work for me, that is why i suggested setting the item to an object first, but i did not test completely
maybe, but to test some code i would need more
there is no clipboard object in VBA, you can not use like VB6
if you need to clear the clipboard, you would need to use the clipboard APIs
i have posted an activex, if you want, see...
i think i pointed that out above
should work to any folder
i think the problem is that objTerminGruppe2 is not actually a folder but an items collection, you can try like
can you post a sample of html document?
as stated above, you can not assign an item as a collection of items
'OR if you want to copy
mycopy = objTerminGruppe.Item(i).copy...
afaik categories is a string list and may not be a single item match, better to use instr
the code posted does not indicate what you are comparing to, is vcbHomeoffice (etc) a constant, variable or...
see thread display options below threads displayed, change time period selected
once the dialog shows the timer does not fire until the dialog is closed
you need to put this code into a separate exe then shell it before opening the dialog
in a module
'API used to...
does the closewindow procedure ever run?
i would need to access the webpage that is opening the dialog
try another loop till readystate_complete, usually works, unless in some sort of frame
it may be possible to do using findwindow and sendmessage APIs it may not be possible from within your application, as the code may not continue until the dialog is closed, may require creating a...
did you try a <br> between lines
xml is only text, so you can do whatever you want, you just need to parse out what you want and write to cells
open the xml file using open
read the entire content using input
use instr to find...
no need to use bookmark if you are using table for results, just place in cells
On Error Resume Next
For e = 1 To wb.document.all.Length
' Set ele = wb.document.all(e)
If wb.document.all(e).Name = "log_in" Then
If Err.Number = 0 Then MsgBox e
what is the expected id number?
i got a value of 71, is that correct?
you could also try
do you get the msgbox?
if so just assign the value of i to a global variable
else just run the code when you want to use the submit button
as we do not know why you want the index of the...
Click Here to Expand Forum to Full Width
Survey posted by VBForums.