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"...remote database needs prefix database in sql
I'm trying to write some SQL for a remote sql05 database and it requires me
to prefix any table names with the database name.
Is there anyway around this, kinda clutters up the sql, i think.
This is the way object identifiers work. :)
You can, however, use synonyms on SQL Server 2005 (and above).
Matija Lah, SQL Server MVP
what does it mean when some databases require it and others don't?
> This is the way object identifiers work. :)
> You can, however, use...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.
...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"...Address book in public folder is formatted as a message
I just installed a new copy of exchange 2003. Now my addres book in the
public folder is formatted as message. I created a template with the view I
want i.e. card with details for the addresses, but it does not allow me the
flexiblity I have when it was a card view. Another problem is that no aone in
the company is able to add, or change any address. What am I doing wrong?
...Default date formats
In Excel 2002, dates entered in a worksheet as "dd/mm" default to a custom
format of "d-mmm". For example, 4/26 shows as 26-Apr in the worksheet cell
even though it is shown as 4/26/2005 in the Formula Bar. I want them to
default to "mm/dd/yyyy". In the Regional settings, the default short date
format is shown as "dd/mm/yyyy".
J Fultz wrote:
> In Excel 2002, dates entered in a worksheet as "dd/mm" default to a custom
> format of "d-mmm". For example, 4/26 shows as 26-Apr in the worksheet cell
> even tho...Databases
I want to be able to sort my customers via the products they buy. I know
> > to do an excel spreadsheet which is useful for mail merges. I also know
> > by adding new categories you can sort contacts. Which is the best
> > Pros/cons of each method please
> > Peter
Peter Brown wrote:
> I want to be able to sort my customers via the products they buy. I know
> to do an excel spreadsheet which is useful for mail merges. I also know
> by adding new categories you can sort contacts. Which is the best
we have page overflow and date format issues with excel macro. this
macro generates about 20 pages of charts... 18 of 20 are printing on
two pages when we run on xl2002 sp-2, same reports are on one per page
in xl97 and xl2000.
any suggestions as to a fix would be greatly appreciated.
...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...Percent Format: Allow user to type Percent, not decimal?
Seems like when a field's underlying value is a decimal amount, but
the presentation format on a field in a form is "Percent", the user
still has to type the decimal equivalent of the percent when editing
e.g. CouponRate=.05437 is shown as "5.437%", but when the user clicks
into the field to type something, they have to type, for instance, ".
04798" to get 4.798 percent to show.
Seems logical from one perspective, but my users don't care for it.
I can think of one way to handle this, using event code, but I'm
wondering if there is a Good-...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...Activities Relationship (MSCRM Database)
Would someone mind looking at the ActivitesBase table and tell me what
relationships they have for this table?
what are you trying to find?
"Kristina Ledford" <email@example.com> wrote in message
> Would someone mind looking at the ActivitesBase table and tell me what
> relationships they have for this table?
We are getting errors when trying to open activities of some Leads that were
created (not imported) in CRM. There was another post about this ...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...Problem about Sample Database
I have a MS CRM license with MSDN. I completly
installed MS CRM with organization named "Adventure Works
Cycle. I got 6 licenses of Suite Professtional. But when I
tried to install sample database following
aintain/20_samdb.mspx . It was error in step of add
license. I added 8JUNYZUK3U66WXTRP7WE1 and the error
screen was shown "You must enter a valid license key".
Please help me solve this problem.
"dinorex" <firstname.lastname@example.org> wrote in messag...Formatting text..
Is there a way to make cell B26 show f.ex. red blinking tekst, when B25 is
containing the same text string?
You can easily make B25 turn RED if it contains the same value as B26 by
using the Conditional Formatting Feature....Format > ConditionalFormat >,
and follow the menu..............if you want it to "blink' then that will
require some VBA code and will continue to consume system resources all the
time it is running.
Chip Pearson has some instructions.....
Vaya con Dios,
Chuck, CABG...[Announce] DataDirect XQuery 3.1 Supports Querying of OpenDocument Format
[Announce] DataDirect XQuery 3.1 Supports MySQL; adds Extended File-
Type Support & Output Enhancements.
[Announce] Dear microsoft.public.dotnet.xml,
DataDirect Technologies has released an updated version of DataDirect
XQuery, an easily embeddable, Java-based implementation of the XQuery
1.0 and the XQuery API for Java standards. Here are some of the
highlights of the new release:
* Extended file type support and output enhancements, DataDirect
XQuery version 3.1 further simplifies the performance of combining and
processing heterogeneous data sources. The product now supports the
abil...How do you keep Excel currency formatting during a mail merge?
I would like to be able to enter currency in Excel as a simple number (ex:
2000) and, when I merge the database to my MSWord Document using Mail Merge,
I would like the number to show up formatted as currency (ex: $2,000.00).
How do I do that?
Debra Dalgleish posted this to a similar question:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:
http://hom...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...Save custom formats independantly of workbooks?
Is there a way to save several custom formats (say,
numbers in $000's, in $ millions, etc) which I would use
for a variety of workbooks (including workbooks where
those formats do not exist yet), with a name, and make
them accessible from the toolbars?
Earlier today someone kindly suggested to assign a name
to the format using Format -> Style, but the formats I
had saved have disappeared from the style menu once I
closed a spreadhseet and used a different one. Any
...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
...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...