Recent content by jmrdaddy

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...

You are so awesome! Thank you! Thank you! Thank you!

i need to correct the use of the variable objItem where its used instead of olItem. after that what are your suggestions

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.

Fabulous! I put the code line below before creating the UserForm. So even if the name has been used before and it's been deleted I don’t get an error! Thanks, you're a champ! ActiveWorkbook.Save

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 = _...

I enclosed the APP_ERROR_LOG in quotes with a backslash and added ".txt" and it worked. I'll assume that the APP_ERROR_LOG was some constant or something that I didn’t pick up when I was reading. Problem solved. Thanks! Y'all are great

I used the GetTempDir function Roy suggested and it works great. Thanks. I prefixed all the FSO variables with "Scripting" Every thing seems to work fine until you get to this Set filFile = fsoSysObj.GetFile(strPath & APP_ERROR_LOG) ' If not, then create it. If Err <> 0 Then Set...

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?

Well, now it changes upper case to lower case even if the name of the function is upper case. I've tried caps and no caps and partial caps. I suppose I'm just not meant to find out why. %-)

Excel 2003 I don't know I could be wrong.

It isn't a problem. Just wanted to know how it worked and figured I'd get answers to my question here. If the name of the function is all lower case or all upper case, Excel changes the formula. If the function is named "MYHOMEMADEFUNCTION" then "=myhomemadefunction(A1)" =>...

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)"...