Recent content by beniez

Yes, Thunderbird is registered as default mail program, and it works from other programs which interface to mail. It even worked with the Office 2007 Beta.... But proper Office 2007 just acts as though I don't have a mail program.

Any ideas how to get Office 2007 to play with my email client?In Word 2007, the option to Send email from the File menu is greyed out: in Excel 2007 it's simply missing; in PowerPoint 2007 the Send option on the File menu itself is greyed out. Is this punishment because I use Thunderbird as my...

Ken Perfectly doable, and yes you can have a data file that records the last used number; reads it, converts it to a number, adds one, and uses it to set a document property. Then you include that document property as a field in your document. I used to have some code to do pretty much this...

... and mine was the least elegant solution :-)

Matt Rows(ActiveCell.Row & ":" & ActiveCell.Row).Select HTH Ben

Geoff Yeah well.... I kind of thought my little bit of hacking didn't qualify as VB coding.... No I didn't: I just didn't read the post properly. So you were right and I was wrong, but hey, who's counting? ;-)

hj When I had to do something similar, I created a user-defined function: Function CellColor(r As Range) As Integer '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* ' Returns Color index of first cell of a range ' If return is >1, then cell is coloured '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Dim...

Our users keep turning *off* the warning that pops up whenever you save or print a document which has Tracked Changes in it (Tools, Options, Security: turn off the checkbox "Warn before printing, saving or sending a file that contains tracked changes or comments"). But when they next...

Searae You can input a set of numbers as positive; highlight the range of cells and choose Edit, Copy; Paste Special Subtract to a blank area of the spreadsheet (this turns them negative by subtracting them from zero); and then Cut and Paste them back to the original place. This is one of those...

xlbo That's really useful - solves a problem that's been nagging at me.... Thanks Ben

Xantix You're right (so, of course is xlbo!) - use range names. Just be careful about the end of your range. I've come unstuck by defining the range to end where my data does; then wondered why records added at the end aren't picked up by the query! Either include some empty rows at the end, or...

If you don't want to put your numbers in as text, then use =B1&TEXT(A1,"0000#") This works for all numbers - eg A1=45, C1='C00045', etc: TEXT() just works like setting the format of a number. HTH Ben

Hi Use ISERROR, as in: =IF(ISERROR('Missing'!B12),"Sheet missing", 'Missing'!B12) (Where 'Missing' is the name of the sheet that might be missing) If you put this in while the sheet is missing, Excel will open a files dialog box to allow you to find it; press cancel unless you want...

Hi assafjak I think you need to use the &quot;Use Wildcards&quot; option in the Word Find/Replace dialog box. Then use <A> as your find string. This means &quot;look for cases where A is both the beginning and end of a word&quot;. This works whether or not the As are in table cells. There used...

Hi Stephen Best way is to create an external query in the spreadsheet referencing your Access database. Choose Data, Get External Data, Create New Query, and create a query to get your data. If you want it to refresh automatically when you open the spreadsheet, choose Data Range Properties from...