How to identify a cell [format|category|number|scientific] for sea
I currently have a project in which I need to identify a cell if it is
formatted with scientific and to ignore the data value. Similar to:
If objExcel.Cells(intRow,Column).xxxxx = scientific Then
Else intRow = intRow + 1
Any help would be gretly appreciated
Office --> Excel 2k3 using *.vbs
If I record a macro while I format a cell as Scientific with two decimal places,
I'd get this numberformat:
And this recorded code.
Selection.NumberFormat = "0.00E+00"
So I could use:
if objExcel.cells(introw,intColumn).numberformat = "0.00E+00"...How to Hide inactive accounts
I can't figure out how to hide my 0 balance, inactive accounts. I'd
especially like them NOT to download to my Pocket PC either. Anybody know
how to do this?
In microsoft.public.money, Bill Howell wrote:
>I can't figure out how to hide my 0 balance, inactive accounts. I'd
>especially like them NOT to download to my Pocket PC either. Anybody know
>how to do this?
In the Account List, right-click and select account is closed.
I don't know how that affects Pocket PC.
I'll let you know tomorrow whether that affects the PPC syn...Changing 'track changes' default settings in an existing file
I routinely receive documents created by others that require the use of
tracked changes at the point that I receive them, not before. New documents
that *I* create always have the settings that I prefer--inserts blue,
deletions red--but the received documents are all set to 'by author.'
I'm working with people who are confused/upset/occasionally panicked by the
on-screen craziness of a file with more than one editor, and all they really
need to see is what's going in and what's coming out anyway--hence my dislike
of 'by author'.
I understand that I...how do I make perferated tabs for "For Sale phone numbers"
I am wanting to make and informational sheet for people to be able to tear
off a phone number from the bottom of the information sheet. I would call
them perferated tabs?
What version Publisher?
File, new, Publications for print, Flyers, Announcements...(2002-03) They are called
They are in the same place in Publisher 2000, only called Publications by Wizard.
Mary Sauer MSFT MVP
"connie" <firstname.lastname@example.org> wrote in message
news:D0350E40-6A56-4BD1-BB89-8A12478357...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...Email to all contacts in an account
I have CRM 4.0 and i was trying to send an email to an account with related
contacts. the email was deliverd to the account email but not to the related
contacts. i couldnt find a way to do it. Is there any way for the email to
be sentl automatically to the contacts related to an account when sending an
email to the account?
any help would be highly appreciated.
...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 ...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).
...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.
...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"...Is it possible to change the texts on a CFileDialog?
Is it possible to change the texts on a CFileDialog? I need it to change the
language of those texts.
"bn1" <email@example.com> wrote in message
> Is it possible to change the texts on a CFileDialog? I need it to change
> language of those texts.
...Changing only Legend Text
Is there a way just to change the legend text, without affecting
the axis label in Excel 2003?
If I go to Source Data, it has one entry for those labels.
In the chart, if you right-click the legend, there should be a tab to change
the font size. This should allow you to change the font only for the legend.
> Is there a way just to change the legend text, without affecting
> the axis label in Excel 2003?
> If I go to Source Data, it has one entry for those labels.
> ...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...Reassigning accounts changes owenr on ALL objects....
We had a sales guy leave so I reassigned his accounts to various other
reps....worked great EXCEPT it reassigned all objects related to that
Account....even the completed ones. Where it screws me up the most is
on orders already created and the reportinig that I have created....it
moves those historical orders to new rep. reports have to be based on
order owner vs created by because we have admins that do some order
Is there any way to reassign account and NOT have it change the owner
on any activity/order/etc that has been completed or is in the
maybe an append query at th...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 ...Selecting varying number of chars in a textbox
In Access 2003, I need to be able to highlight (select) a substring of the
text in a textbox for an existing record. For example, if I have a date:
I might need to highlight the "3/10" part while leaving the "/2009" part
unhighlighted. This would facilitate data-entry of a month/day while leaving
the year as-is. I know this is possible, but have forgotten how. Can someone
please point me in the right direction?
Thanks a million!
On Wed, 17 Mar 2010 13:05:04 -0700, Dennis
Check the help file on ...Saving Changes in Transactions.
In Batches; when you go into a Transaction and come back out, the program
asks you if you want to save changes. Your choices are "Save", "Delete",
"Cancel". If you don't want to save changes and choose "Delete" it deletes
your transaction from the batch. This is very misleading and leads to
information loss. I have had several customers complain about it. We would
like to see the "Delete" changed to a "Discard". Then if they want the
transaction deleted from the batch they can use the "Delete Button" at the
...formula to change font colour depending on which cell it has used
I have received some great help on here and again I am seeking more guidance
I have been tasked with setting up some spreadsheets at work to on
applications coming into my department and the number of days it takes for us
to deal with them. I am also looking at number of written enquiries as well.
Using the following headings Application Received (B4), Enquiry Received
(C4), Completed Date (E4).
Then using the following formula
So that it will look at B4 determine if a date is in the cell if it isn’t...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...Sorting Numbers with Multiple Decimals
I am attempting to create a file system using excel that can be easily
searched and sorted by a number ie 1.3.12 or alphabetically. At this time I
have entered the data as I would like it to appear if sorted by number,
however if I attempt to alphabetize I can not restore the numbers to their
Currently I have only 3 columns. One with numbers, one with file names, and
one with additional information.
1.1.1 Bob Marketing
1.1.2 Dave IT
1.1.12 Joe Marketing
12.1.1 New York
188.8.131.52 N...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...Changing the amount of leads that appear on lead page.
This seems like it would be something rather simple to do with customizations
but I have not yet found a way. Right now we have 50 leads showing per page
and some people have 500+ leads is there a way to have it so that more leads
say 100 or maybe even all leads appear in the my leads page.
Is there a reason 50 is the default limit?
I am pretty new to CRM so forgive me if this is an easy question
Hi, There is a setting under Workplace-->Personalize Workplace-->General
that lets one modify the number of records that show up on each page. Please
note that this will change the num...logging password changes
Is it possible to audit when a user changes their Great Plains password and
then get a report on this.
Great Plains Consultant
Are you using SQL Server? If so, I think turning on the C2 security option
will audit these changes.
"Doug" <Doug@discussions.microsoft.com> wrote in message
> Is it possible to audit when a user changes their Great Plains password
> then get a report on this.
> Doug Wilson
> Great Plains Consultant
> MCS Canada
...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...Trying to change the picture name in VBA is giving me permission error
I have something like this
Sheet1.Shapes(i).Name = "picture" + cstr(i)
But it gives me an permission error (70)
Anyway around this
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
That should work unless that name already belongs to another shape. I get a
permission denied error too in that case.