Fairly Easy Formula Question....
......the answer to which is eluding me!
I am using this formula =VALUE(C1&" "&A1) to return a date (month in col A
and day in col C). Can someone tell me how to modify the formula to avoid
#VALUE! being returned when col C contains an empty cell.
What exactly do you have in C1.
How is C1 formatted and what did you enter (type in) for a "month"
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
...Filter Count question
I have the following code:
.Filter = "[Status] = 'Open' AND [Source] <> 'SE Meeting'"
.FilterOn = True
Me.Label32.Caption = "PCCB Action Items"
.OrderBy = "[Group_Name], [IssueID]"
.OrderByOn = True
When I execute this on a commandbutton it returns all the open action items
not equal to SE Meeting as the source code. That works perfectly.
I have a new unbound textbox called AI_Open. Once I execute the above code,
i want some code that will count the number of open action i...Import Messages from Outlook Express 6
I would like some advice on importing messages that are
currently on a Win98se machine running OE 6 into an XP
Pro machine running Outlook 2003,
Thanks, any help greatly appriciated,
<firstname.lastname@example.org> wrote in message
> I would like some advice on importing messages that are
> currently on a Win98se machine running OE 6 into an XP
> Pro machine running Outlook 2003,
> Thanks, any help greatly appriciated,
Go here to backup your old OE:
http://insideoe.tomsterdam.com/backup/index.htm...Two computers, one Money file.
I want to use Money on my business laptop and my home desktop, and I want
the two to synchronize (possibly via online sync.). Does anyone know if this
is possible? Would I need to buy an additional license? Thanks.
In microsoft.public.money, Uffe Henrichsen wrote:
>I want to use Money on my business laptop and my home desktop, and I want
>the two to synchronize (possibly via online sync.). Does anyone know if this
>is possible? Would I need to buy an additional license? Thanks.
See FAQ available at http://umpmfaq.info/faq.html for information on
accessing the same dat...Money Money Money !! Agloco !!
I recently joined AGLOCO because of a friend recommended it to me. I
am now promoting it to you because I like the idea and I want you to
share in what I think will be an exciting new Internet concept.
Sign in : http://www.agloco.com/r/BBBV9253
Detailed =DDnfo : http://www.ulasbeldesi.com/agloco_en.html
AGLOCO's story is simple:
Do you realize how valuable you are? Advertisers, search providers and
online retailers are paying billions to reach you while you surf. How
much of that money are you making? NONE!
AGLOCO thinks you deserve a piece of the action.
AGLOCO collects ...Purchased Money Essentials wont install
I purchased MOney essentials and got an error that said that money was open
and wouldnt install. I paid to the 5.98 to be able to redownload for 60
days. HOw do I do this.
Same thing happened to me. I called the 800# and they helped me out after
about 30 minutes on the phone.
> I purchased MOney essentials and got an error that said that money was open
> and wouldnt install. I paid to the 5.98 to be able to redownload for 60
> days. HOw do I do this.
...changing from outlook express to outlook #2
is it possible to change e-mail addresses from outlook
express to outlook with out doing it manualy?
also, i'm having trouble getting the e-mails to come into
ouitlook. (i took out the servers in outlook exp).
...money 2002 #26
I have purchased a new computer and my old one has money
2002 also installed I want to take all data on old and
put in new computer how do I do this
Locate the *.mny file and copy that to your new computer. Once you have
Money installed on the new PC then navigate to the *.mny file with Windows
Explorer and double click on the file name. That will fire up Money which
will recognise your file.
Microsoft MVP - Money
"steve Post"...Lost Outlook Express Folders
I transitioned from Pacbell DSL to SBC DSL about a year
ago. I just recently tried to reset up an existing email
address (not my primary address) with an SBC support rep.
During the process I lost all folders for my primary email
account. The support rep said all we did was remove and
add back the primary account, and delete temp files to
speed things up. According to her this should not cause
folders to be lost. I don't find any of the folders when I
search. How do I do all to recover these folders before I
just move on?
...Outlook 2007 and Outlook Express (XP Professional)
Currently using Office 2000 professional.
Do not use Outlook 2000 - use Outlook Express.
Now I plan to install Outlook 2007.
Question - Will I run into problems with:
1) having Outlook 2000, which is not used for mail?
2) the fact that I use Outlook Express for mail?
Will the address book import into contacts, when I install?
Out of curiosity - why will you keep Outlook 2000 if you install Outlook
2007? Why not use Outlook 2007 for mail?
You can certainly install Outlook 2007 and use Outlook Express for mail if
Ben M. Schorr, MVP
Roland Schorr & Tower...money 2005 #11
Is money 2005 out and when are they going to updated their
webpage with money 2005?
Depends where you look. Some retailers are shipping others are saying 21st
MS will update the webpage when they see fit! We will just have to keep
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes http://www.microsoft.com/uk/support/money/feedback
I do not respond to any emails that I have not specifically a...Duplicate Funds in Money
I have a 401k account where I have always downloaded the information myself.
I then found out that I could have money keep the information up to date, so
I tried to create a new 401k account within on-line setup.
Originally, I had a duplicate account, but I worked through that issue. Now
I'm having a problem with duplicate funds. In my original 401k I had a fund
like the following. "Merck Common Stock" with the online one, they call it
"MRK CMMN STCK" I Just want to treat them as the same, but each time money
downloads the information, it uses the "MRK ...Microsoft Money in Australia
Currently using the last version of Microsoft Money that was released in
Australia - v14 (2004?). Noticed that future versions are not available in
Australia. The seem to be some funny compatiblity issues since I have put it
on my Vista machine... it doesn't like it when other apps are open - doesn't
let me easily switch between apps. Anyway, not important.
I like to keep current with my software so would like to upgrade to a newer
version, happy to pay full price, but I REALLY need to retain access to my
historical data. Will I be able to purchase the US version and upda...WinUSB large data question
Can we use virtual memory or file mapping view buffer for WinUSB ? How can
we send large data more than gigabytes to USB device ?
Thank for your teaching .
On 2010=E5=B9=B407=E6=9C=8805=E6=97=A5 06:23, Kid wrote:
> Can we use virtual memory or file mapping view buffer for WinUSB ? Ho=
> we send large data more than gigabytes to USB device ?
I think setting up transfer requests of this size is a bad idea;=20
instead, just set up a loop that submits the data in handy chunks.
What is the max buffer size do you suggest ?
"Si...MONEY MONEY MONEY!!!
A while back, I was browsing these newsgroups, just like you are now, and
came across an article similar to this that said you could make thousands of
CASH within weeks with only an initial investment of $6.00 (American) plus
International stamps due to users that may be outside the United States! So
I thought, "Yeah, right, this must be a scam!" But like most of us I was
curious and kept reading. It said that if you send $1.00 to each of the 6
names and addresses listed in the article, you could make thousands in a
very short period of time. You then place your own na...Problems with Money 2005
I've used Money for several years. Started using '05 about two months ago.
Two days ago I got a downloaded statement from my broker (an everyday
occurence). Money crashed. It just froze up. I had to use control alt delete
to get out. Now I have tried repairing files, restoring backups, you name it.
I finally did get a backup file that was about a month old to open and run. I
made a copy for safety. As soon as the statement was downloaded, this file
froze up. I just want to get my data back for the last month, I don't care if
I have to delete the statement. I'm afraid all...Question marks in reply
Once in a while a recipient of a reply indicates that
instead of the text there are only question marks. The
machine, where Outlook 2000 is installed, runs Windows 2000
SP3. When the problem shows up I run Detect an Repair and
also "sfc /scannow" command using Run. The problem
dissapears for a couple weeks and then comes back. Any ideas?
...Money 2000 user guide
Can i please have some help!!! I have lost my money 2000
user guide. Does anyone know where i can get a
downloadable version of it. It would be greatly
...Rules wizard question #3
Hi - I'd like to know how I can determine how many people in our
organization are forwarding their mail to another account. I'm not
referring to forwarding which is set up on the Exchange server - we in IT
control that... I'm referring to who may have set up forwarding in Outlook
via the rules wizard. Is there any way to determine this without visiting
every single user and checking manually (which is pretty much impossible)?
...money vs simply accounting
i've used simply accounting but never ms money, are they both similar in
function? is ms money any easier?
...Money Data #2
Can you access the Microsoft Money data with a report writer like Crystal
Reports or Microsoft Access to create customized reports?
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"tmc" <email@example.com> wrote in message
> Can you access the Microsoft Money data with a report writer like Crystal
> Reports or Microsoft Access to creat...Money 2004 Error 1335 #2
Sorry about the vague description.
Upon installation I constantly run into an error. about
45 seconds into the download from the CD. The error
message says that Error 1335 because "Money.cab" file is
corrupted, network errors, or bad CD.
Upon researching the error on microsoft.com I did
followed their techniques to correct the problem.
They were: Copy the entire disk on your local desktop,
perform a clean boot and run the setup from the local
computer and not the cd. This would rule out the bad
I then continue to receive the problem. Now this disk
a...Reinstall Money Plus problems
I have Money plus on my PC which expires in 09 Nov. I purchased a new
downloaded copy so that I can extend it to 11 Jan. I tried to install
the new copy, it started the installation and gave the message: "Money
is ready to go! To complete the installation, Press Finish.
The copy of Money is still the same i.e. still the Nov expirity date.
Do I have to unstall the current copy and reinstall or is there a way
to extend the licence please?
Here are the instructions I received from Microsoft to manually
override/register Money Plus Deluxe. Hope this helps...
"Since you already pur...Best Super money transfer site for you......money...money...money...money...
The best site for your information all about money http://www.supermoneytransfer.info
...Repair a Money data file? MS Money or MSN Money?
I've posted here before about trouble accessing one bank in my MS Money
setup. I'm using MS Money 07 Deluxe on a WinXP Pro SP2 computer. It's
now been well over a month since I've been able to download
transactions from this bank.
Last week, I had an online chat with a MS support rep. Unfortunately,
I had to cut the session short, after over an hour, because I had a
meeting I had to attend. And with one thing and another, I'd rather
not go through the chat again and paying for phone support is a very
Anyway, to sum up: I tried accessing the data via the ...