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...
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...
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 "Use Wildcards" option in the Word Find/Replace dialog box. Then use <A> as your find string. This means "look for cases where A is both the beginning and end of a word". 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...
Unless I'm missing something, these are basically find and replace activities (highlight the relevant column and find "1", replace with "Closed" etc). If you need to do this repeatedly, then record your actions as a macro.
Ben
Hi Tony
Normally Word defaults to continuous numbering between sections, but if it isn't, go into View Header/Footer, press the Format Page Number button, and choose "Continue from previous section" there.
HTH
Ben
David
Creates a new query - or rather, you create the join in a query (which you can if you want use to create a new table). Go into query and add two tables with a common field; drag the common fieldname from one to the other; you've created a join.
HTH
Ben
David
Joining the data is pretty much the only way to do what you want in Access - how else will Access know which record to put each bit of NewStuff into? (Remember that Access, being a relational database, doesn't regard a table as having an "order").
I'd be tempted to paste your...
Am I right that there is a Microsoft library that supports PERL-type regular expressions? One that's available to VB6 or VBA programs (ie, before VB.NET)?
If so.... which library is it?
Ta in advance
Ben
[rofl]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.