Search results for query: *

Hello I have a macro that saves Outlook emails to a specified folder on disk. Because Outlook lacks a GetSaveAsFilename method, I'm using Excel's, as follows: c = Excel.Application.GetSaveAsFilename(InitialFileName:=txtCompoundFilename, fileFilter:="Outlook Message (*.msg), *.msg"...

Thank you all for the file links, I'll give some of them a try. Its interesting to learn that a website can exclude itself from being cached. Q. ------- The joke cannot be found The funny quote you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Hi all. I am looking into potential misuse of a computer for which I have responsibility. There is evidence in the History that an inappropriate website was visited, the page titles suggesting a registration process was completed. There is a cookie for said site, created on the same date, and...

So it is. There's another thing I've learned today! 8-) Cheers Andy. ------- The joke cannot be found The funny quote you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Perfect, combo - just what I was looking for, thank you. It only remains a mystery as to why "DrawingObject" turns up a blank in Help, and is not listed as a property or method of the Shape object! Oh well. Thanks again! ------- The joke cannot be found The funny quote you are looking for...

In Excel, you can assign a formula to an Autoshape, so that it displays the value of a reference. Is it possible to read this formula back using VBA? I tried to use the construction Autoshapes("name").textframe.characters.text, but this returns the result of the formula (i.e. what is displayed...

Thanks CBasicAsslember, I wasn't aware of that property. Looks like it could be handy. ------- The joke cannot be found The funny quote you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Hi loomah, thanks for the reply. As it turns out, I've now fixed the problem. I had a conditional format based on a volatile User-defined Function which was running when the sheet activated. This was obviously confusing Excel. Oh well, another nice idea out the window! Thanks for your...

Hello All. I'm having an odd problem with SheetActivate which is (sort of) not firing for a specific worksheet, and wondered if anyone could assist. My code is: Private Sub Workbook_SheetActivate(ByVal Sh As Object) Debug.Print "activating sheet: " & Sh.Name If Sh.Name = "Timesheet" Then...

Sorry, forgot to come back and close the loop. Removal/reinsertion of the modem (together with a complete reinstall of windows to fix a shedload of other woes:-)) did the trick. Thanks very much! ------- The joke cannot be found The funny quote you are looking for might have been removed, had...

micker377 - thanks for your reply. I'll give that a go tonight... ------- The joke cannot be found The funny quote you are looking for might have been removed, had its name changed, or is temporarily unavailable.

I think it depends on whether you are the person tendering, or the person inviting tenders. Either way, where I work, the person tendering tends to be called the "bidder" (or tenderer of course.) From the bidder's point of view, the organisation inviting tenders would be "the customer". From...

Hello folks, After suffering a crash, I lost the driver for my HSP 56 Micromodem, and had to reinstall the driver (which I found on the Conexant web site). The driver installed without a problem, and according to the "Modems" utility in Control Panel, it is installed on COM3, and working...

Hello from a keen and regular reader, but only occasional participant... unfortunately my handle is almost as dull as dplank and jebenson's: as = initials; risk = something I was involved in at work when I registered. You can imagine it took me a long time to come up with something so...

There's a longer version of the poem, with a couple of extra verses in the middle. This one has no spelling errors in UK English. (I didn't write this, and I don't know who did - apologies if its out of place in this folder.) Eye halve a spelling chequer It came with my pea sea It plainly...

Matthew One might (if one were a pedant) argue that unnecessarily redundant was unnecessarily redundant? :-) ------- The joke cannot be found The funny quote you are looking for might have been removed, had its name changed, or is temporarily unavailable.

In my own timesheet, I use the ROUND function, like this (with C1 formatted as a number, and A1/B1 containing the start and stop times (formatted as hh:mm): Range("C1") = WorksheetFunction.Round((Range("B1") - Range("A1"))* 24, 1) I round to a tenth of an hour (one decimal place). For two...

MCubitt - I get colours in Print Preview mode even when my printer is B&W. Go into File/Page Setup/Sheet, and make sure the Black And White box is not ticked. ------- I am not responsible for any "Sponsored Links" which may appear in my messages.

Try running this macro. It will delete all duplicate rows, whether they are next to each other or not (You don't say whether this is a criteria). ASSUMPTIONS: This assumes your data starts on Row 1, is in Columns A and B, and that there is a blank row at the end of the list. Please adjust...

Bit late now, but regarding deletion of collection items: The solution I usually use, which avoids the need to declare a variable, is: Do ActiveDocument.Hyperlinks(1).delete loop until activedocument.hyperlinks.count = 0 It works because when you delete the top item in the collection, the...