Money to Excel question

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

thx

Dick
Tue Aug 01 19:24:52 CDT 2006

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@aol.net> wrote in message
news:%239gs2OatGHA.3240@TK2MSFTNGP03.phx.gbl...
> How would I import a Money report into an excel spreadsheet that is
> already formatted for it?

jnsaunders
Wed Aug 02 06:47:33 CDT 2006

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@mind-enufalready-spring.com> wrote in
message news:%234O5JoctGHA.452@TK2MSFTNGP05.phx.gbl...
> 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@aol.net> wrote in message
> news:%239gs2OatGHA.3240@TK2MSFTNGP03.phx.gbl...
>> How would I import a Money report into an excel spreadsheet that is
>> already formatted for it?
>
>