Thanks Dick

You answered my question. Sorry it was vague. I had wanted to import cvs
data from a custom Money report into a pre formatted excel template. Now I
know how to do it.

P


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:%234O5JoctGHA.452[at]TK2MSFTNGP05.phx.gbl...
- quote -

I'm not sure what you mean by "already formatted for it".

In general, Money knows how to export to CSV files. These know values but
know no formatting.

The way to get around it, more or less, is to have your formatted
spreadsheet refer to the VALUES in another spreadsheet, the .CSV file,
rather than contain them itself. I.e., don't store Money's 32.50 value in
cell a1, let cell a1 ='externalsheet'!A1 where externalsheet is the .CSV.

Another way is to setup your sheet from an exported .CSV file, save it as
..XLS, then, to update, open the next .CSV, copy the areas you want, and
Paste Special Values them into the formatted sheet.

The final way is just to have the formatted sheet get its data from Money
dynamically using the MoneyLink (free) add-in from Ultrasoft. This has
limitations because the add-in has limitations, but, depending on what you
are trying to accomplish, might work just fine.

All those are starting offers given that I'm not clear on your objective.
Post back with more and we'll see where we go. I do a lot of stuff with
Money data in Excel...

"jnsaunders" <jnsaunders[at]aol.net> wrote in message
news:%239gs2OatGHA.3240[at]TK2MSFTNGP03.phx.gbl...
- quote -

How would I import a Money report into an excel spreadsheet that is already
formatted for it?

thx