Search results for query: *

I've tried the line of code below. I can't get the option "NewWindow:=False" to work. A new window is opened every time regardless of whether the value is "True" or "False". Is there on option in IE that preempts this? Has anyone else encountered this before? What did you do...

I need to add a user defined property to each mail item in a folder. The code below works without errors but it only adds the property to the currently selected mail item or the first mail item in a selected group of items. How can I make it work for every item in the folder? Thanks. Option...

Is there a Network API call or other thing to test whether or not a given user is connected? i.e. getUserConnected("johnjohnson") Returns TRUE or FALSE depending on if the user "johnjohnson" is connected to the network.

A UserForm can be created using code such as that below. Sub Add_Form2() ' Declare a variable to hold the UserForm. Dim mynewform As Object ' Create a new UserForm. You can now use this new VBComponent object ' to manipulate the User Form. Set mynewform = _...

The MSDN website Logging Errors to a Text File offers the code below as an example of how to use the FileSystemObject. Two questions (actually three): 1. Is the function GetTempDir a Windows API function and if so what dll file or other thing do I need to reference to use it. 2. I tried a...

Is there a property for userforms by which one could "hide" the Titlebar? I'm imagining something like... Titlebar.Visible = False Or is it more complex than that?

When a formula is typed in a cell in Excel the formula is automatically capitalized. i.e. "=average(A1:A25)" becomes "=AVERAGE(A1:A25)". Is there a way to automatically change the case of a homemade formula like Excel does? i.e. "=myhomemadeformula(A1)" becomes "=MYHOMEMADEFORMULA(A1)"...

In Excel, if you have a formula in a cell such as... =HYPERLINK("http://www.yahoo.com/","YAHOO!") neither the SheetFollowHyperlink or the FollowHyperlink events will fire when the cell is clicked. Is there a way to make this work? Is there another event that will work?

When the "Request a Read Receipt" option is disabled, is it possible to write code to set the ReadReceiptRequested property to "True" each time a new message is started or when making a reply or when fowarding?

I would like to "mark" an image control on a user form with a graphic or text element at the location where the user clicks the image. I don't see a way to do this with the standard image control. I suppose one could superimpose another type of control over the image control and make it...

I would like to "mark" an image control on a user form with a graphic or text element at the location where the user clicks the image. I don't see a way to do this with the standard image control. I suppose one could superimpose another type of control over the image control and make it...

I’ve had a system crash. I was able to salvage much of my stuff, but had to reload applications. I used the piece of code at the end of the post in Outlook to collect addresses before the crash without problems. But now I get a run time error Collaboration Data Objects...

I need to format cells so that the value "TRUE" gives a "1" and value "FALSE" gives a "0". I've figured out how to do it the opposite... [=1]"TRUE";[=0]"FALSE";General but I can't get what I want to work. Can someone help, please?

I hope I’m in the right forum. I want to add an item to the right click menu in Outlook and Explorer. I want to copy the selected text or picture or link or whatever and add it to a text file or word file automatically. Can anyone get me started.

Be kind. I'm not sure if I've gotten the terminology correct, but here goes nothing... In Outlook, is there a property that stores the date that is currently selected in the calendar? Such that one could change that property and "jump" to a date.

I am attempting to have VBA return the number of characters in a document using the following line of code... lngNumChars = ActiveDocument.Content.ReadabilityStatistics(2).Value For long documents, that value returns 32001. This method apparently returns an integer value. Is there a way to...

Be kind. I'm not sure if I've gotten the terminology correct, but here goes nothing... In Outlook, is there a property that stores the date that is currently selected in the calendar? Such that one could change that property and "jump" to a date.