Search results for query: *

ooops... I should say: the ConvertToHoursMinsSeconds function converts the found string to the simple time. strebor

Thank you jges! The link was very helpful... here is what works. Private Sub mainProcess() Dim stringOut As String Dim fileReader As System.IO.StreamReader Dim testFile As System.IO.FileInfo Try fileReader =...

I have text files that contain time in a strange format which needs to be converted. The format is: 3 days 14 hours 34 minutes 17 seconds I want to convert it to 86:34:17 (which will then be able to be manipulated by Excel, etc.) I have a regEx pattern...

Thank you spamjim... appreciated the humor! strebor

I have a intranet website. The users on this intranet may use Firefox or Internet Explorer. There is an important page which I don't control on a sharepoint that is all messed up when opened with Firefox. I would like to make a link to it that, if one is in Firefox it will launch Internet...

Well... I know it is important to know the why... and I should take more time to learn more about this... and I should learn more about my car, and why my teenage son will not wake up in the morning and a whole bunch of other whys that I haven't got to, but... for right now... since I am just...

That worked... Thank you! strebor

I am working on a template. I have several autotext entries that will be placed in the template based on the choices a user makes in a user form. Putting 1 autotext entry in works fine... subsequent autotext entries merely overwrite the previous (or first) so that in the end the only autotext...

...but that didn't solve the problem. strebor

Okay... I choose File > New and open a workbook based on the template. strebor

Not sure. I guess I don't know when 'storing' occurs. I created the macros while working on the .xlt file. I saved everything. When I assign a macro to a button in the 'custom' toolbar that I created there is a drop-down at the bottom.. All Open Workbooks This Workbook myfile.xlt It doesn't...

This has to do with Excel templates (.xlt) and vba for excel macros. I have the same question as was posted in this very short thread.. thread707-1150241 Nobody answered that question (3 years ago!). In my case, it works after I assign the macro.. but as soon as I exit from excel and...

Thank you all. And in less than 10 minutes I had 3 things that work... and I came up with a forth. Private Sub txtHour_Change() If Len(txtHour.Text) = 2 Then txtMin.SetFocus End If End Sub But I really like Gerry's method. Thank you all. strebor

I have an Excel user form that has some 'fixed' length fields (two digits) and for convenience sake I would like to be able to enter the required number of digits and have the focus change to the next field without having to use the tab key or reposition the mouse cursor. I've looked through a...

Or, include the hta:application attributes... <hta:application applicationname="my.hta" border="thick" borderstyle="normal" caption="true" contextmenu="false" icon="c:/program files/Microsoft Office/OFFICE11/refbarh.ico" maximizebutton="false" minimizebutton="false" navigable="false"...

Duane - Thank you for the link properties post. It helped me fix a problem. I didn't even have to struggle too much, because zapzip did most of the struggling. I just sort of shoulder-surfed! strebor

Or this, no trailing space. Despace = "test1 test2 test5 " Dim re Set re = New RegExp re.Pattern = "\s+" re.Global = True Despace = Trim(re.Replace(Despace, " ")) WScript.Echo Despace strebor

dm4ever- I tried this again and it worked! Not sure what changed. So thank you again. I guess I have a starting point now. strebor

Thanks dm4ever! I tried this out (using the GUI interface and advanced wizard). I mapped a drive to another machine of mine and had Outlook running and attached to a .pst file. I tried to back it up, making sure that Shadow Copy was enabled. It created a .bkf but reported that it had skipped...

I sometimes have to connect to remote machines and copy files. It is fairly trivial to script a solution that works well for idle files, but if I need to retrieve an Outlook personal folder file, it is always in use, as Outlook is holding it open, and it will not copy. Is there a way, using...