Search results for query: *

Can you insert a multi page tif file into a Word document manually? I suspect it's not possible, I've only ever managed to view all pages of a multipage tif in Microsoft's fax viewer or some of the better paint programs, but not the Office suite. I think it needs to be split into single page...

Have a look at http://myitforum.techtarget.com/articles/1/view.asp?id=8375 Regards, Nic

I use the following, set up with a keyboard shortcut of Ctrl & t to put a timestamp in the activecell of a workbook. You could modify as required, and maybe add a few lines in to save the workbook afterward. Sub snapshot() ActiveCell.Select ActiveCell.FormulaR1C1 = "=now()" Selection.Copy...

Hi, This question is relating to Windows XP and the built in defrag tool. Does anyone know if harm will come to a machine if it is shutdown during the middle of a defrag? Thanks, Nic

Rody, Have a look here: http://www.tek-tips.com/faqs.cfm?fid=4116 Regards, Nic

RodP, The only other way I can think of doing it within Excel is by taking the column you want to do the replacement in, separate the words by doing a 'text to columns' using a space as the delimiter. You can then do the replacement by matching the whole cell (as each cell will only hold one...

Hi RodP, Why don't you try putting a space either side of the word ja as your variable ie ' ja '. This won't work if ja is the only word in cell, but from what you say above, that doesn't look to be the case. Hope that helps Nic

Chris, Thanks for the link, that's what I needed to know. Regards, Nic

Does anyone know if it's possible to upgrade a Secondary Server into a Primary Site Server? We are looking to put a number of Secondary Servers into Overseas offices with good WAN links. Each office has 50 or so machines. I've been asked to look into the longer term, and if those offices...

Matt, You need to run 'wbemtest.exe' it's normally in c:\windows\system32\wbem. If in the 'NameSpace' box you type root\cimv2 then click 'connect'. In the next window click 'Enum Classes' and under 'SuperClass Info' window, leave it blank and click 'ok' you'll see a list of properties than...

Simon, You could perhaps try looking at controlling Outlook through Excel. I've come across a few articles relating to Sendmail but they all say you can't add Message text. Have a look at the following article...

You can use .ReturnWhenDone = False in the With Statement, so it won't be able to be routed elsewhere but still gives you the message "The enclosed document has a routing slip. You are the last recipient; no further routing is necessary." I can't find any other options to...

Hi, You can use this kind of sending routine to add a message text: Sub Testsend() ActiveWorkbook.HasRoutingSlip = True With ActiveWorkbook.RoutingSlip .Recipients = Array("name1", "name2", "etc") .Subject = "Test" .Message = "Hello...

Otherwise you could have a look at parse_data spreadsheet on http://www.xl-logic.com/pages/vba.html which gives you the option to parse more complicated cell contents. It could be adapted to your requirements quite simply. It basically apes the 'Text to Columns' function. Regards, Nic