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

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

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

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

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

Hi all, I've received an attachment which is MIME encoded, as follows: (I have changed the filename) ----=_NextPart_ST_13_56_52_Monday_January_10_2005_1018 MIME-version: 1.0 Content-Type: application/octet-stream; x-oid="1.2.840.1.113556.3.10.2"; name="filename.PDF" Content-Transfer-Encoding...

Hello everyone, First post in this forum; thanks for your patience. I have a new (still) digital camera which produces .MOV quicktime video clips (640x480, 30fps). These display very choppily on my PC. Current spec: P3 500MHz, Win98SE, on-board graphics (no graphics card). Would a separate...

Hello all, I have a simple pivot table from which I have created a pie chart. (Project ID codes vs hours booked to project) If I add data labels to the chart using "Format Data Series", then the labels disappear when the pivot table refreshes. If I add the labels using the "Chart Options"...

OK, this is an odd one. I have a workbook in which all of the cells which have no background color (i.e. "No Color") have turned a grey colour (very similar to the colour of the sheet tabs at the bottom) instead of the usual white. New worksheets I create in this workbook have the same colour...

Hi all, In my (limited but growing) CSS experience, I have always referenced style sheets like this: <link rel="stylesheet" type="text/css" href="styles.css"> Recently I have seen style sheets referenced like this: <style type="text/css"><!-- @import "styles.css"; --></style> Which of...

Hi folks, In my document, I have used the following in my page footer: Page { PAGE } of { SECTIONPAGES \* MERGEFORMAT } This looks OK on screen and in print-preview, I get "Page 1 of 27" no problem. However, when I print out, I get the following sequence: Page 1 of 1 Page 2 of 2 Page 3 of 3...

If a formula results in a negative time (e.g. -3:14), excel converts it to "####", and helpfully provides a tool tip telling you it has done this. Is there any way to disable this behaviour? The odd thing is that, if I chart a range containing "valid" (positive) times and "invalid" negative...

Hello folks, I have an Access 97 database which requires some tweaking. The customer requires the database to remain in Access 97, however I now have Access 2003. I notice that Access 2003 has a function "Tools/Database Utilities/Convert Database/To Access 97 Format". I therefore assume that...

Hello experts, Does anyone know if it is possible to include a ruled line to separate Excel headers/footers from the "body" of the document? This is easy in Word, by using the drawing tools in the header and footer, but I cannot see a way to achieve it in Excel. Many thanks.

Hi All, I have a Running Total field performing conditional count in my Group Footer which counts (some of) the Detail records subject to a formula, and resets on change of Group. All well and good, but if there are no detail records which match the criteria, the count field is blank. How do...

Hello experts, I have a risk register report, in which the risk information is contained in a Group Header, and the Mitigation Actions are in the details. I've used &quot;InRepeatedGroupHeader&quot; to provide a &quot;Continued&quot; label when the detail spreads over more than one sheet, but...