Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #9  
Old 11-25-2005, 07:48 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Import from Excel

Thanks. That's what I was wondering. You did not do the whole cycle
programmatically.

"cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
news:652FED27-D6E8-454D-AFDF-FFBFA5CBA877[at]microsoft.com...
- quote -

> In Adobe Acrobat 5.0 there is a special tool as selecting tables like
> selecting text and selecting graphics. with this tool I selected the data
> and
> copied to Excel ( or even directly save that table as .csv file and open
> it
> in Excel).
> But the problem I faced if the payee field has more than one line then it
> is
> occupying two rows in Excel. Then I wrote a macro to combine all that data
> in
> two or three rows of single transaction into one. Then I converted the
> file
> in QIF and then imported to Money.



  #8  
Old 11-25-2005, 06:19 PM
cndesu
Guest
 
Posts: n/a
Default Re: Import from Excel

Hi,
Sorry for the late reply.
In Adobe Acrobat 5.0 there is a special tool as selecting tables like
selecting text and selecting graphics. with this tool I selected the data and
copied to Excel ( or even directly save that table as .csv file and open it
in Excel).
But the problem I faced if the payee field has more than one line then it is
occupying two rows in Excel. Then I wrote a macro to combine all that data in
two or three rows of single transaction into one. Then I converted the file
in QIF and then imported to Money.

--
Chanikya


"Dick Watson" wrote:

- quote -

> Great!
> Let me ask, how'd you get them from PDF to Excel?
> "cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
> news:63326480-414F-40DF-ACB2-85F824C84130[at]microsoft.com...
> > Any way I got the solution for converting PDF files to Money. Not
> > directlyconverting PDF to Money but I convert them Excel , to Quicken and
> > then to Money. Any way I also did little bit programming in that (VBA).

  #7  
Old 11-17-2005, 03:09 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Import from Excel

Great!

Let me ask, how'd you get them from PDF to Excel?

"cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
news:63326480-414F-40DF-ACB2-85F824C84130[at]microsoft.com...
- quote -

> Any way I got the solution for converting PDF files to Money. Not
> directlyconverting PDF to Money but I convert them Excel , to Quicken and
> then to Money. Any way I also did little bit programming in that (VBA).



  #6  
Old 11-17-2005, 01:20 AM
cndesu
Guest
 
Posts: n/a
Default Re: Import from Excel

Hi Mr. Dick Watson,
Any way I got the solution for converting PDF files to Money. Not
directlyconverting PDF to Money but I convert them Excel , to Quicken and
then to Money. Any way I also did little bit programming in that (VBA).

--
Chanikya


"Dick Watson" wrote:

- quote -

> What are you asking? How to do it? This will require programming. Help with
> that is way beyond the scope of the NG.
> "cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
> news:AFFBCFC1-DE30-4617-8D7F-B26BFADD76FE[at]microsoft.com...
> > Can I have the suggestion or clue how they can be done from PDF to EXCEL
> > or
> > directly to MONEY?

  #5  
Old 11-13-2005, 02:54 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Import from Excel

What are you asking? How to do it? This will require programming. Help with
that is way beyond the scope of the NG.

"cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
news:AFFBCFC1-DE30-4617-8D7F-B26BFADD76FE[at]microsoft.com...
- quote -

> Can I have the suggestion or clue how they can be done from PDF to EXCEL
> or
> directly to MONEY?



  #4  
Old 11-13-2005, 01:29 AM
cndesu
Guest
 
Posts: n/a
Default Re: Import from Excel

Hi,
Can I have the suggestion or clue how they can be done from PDF to EXCEL or
directly to MONEY?
And one more thing just from the site online statement, I had selected and
copied the contents to excel worksheet. I deleted the unnecessary things
otherthan Date, Payee and Amount. But when I export to Qif file through the
tool provided by http://xl2qif.chez.tiscali.fr/xl2qif_en.php, I could not get
the amount values in the amount column. The remaining two columns were fine
with details just amount values are missing.
Chanikya


--
Chanikya


"Dick Watson" wrote:

- quote -

> That would be really hard. First you'd have to convert the PDF to something
> that you can deal with.
> Could it be done? Yes.
> With readily available tools in a simple way? No.
> "cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
> news23EBB35-A367-4194-A345-F1ED311FF81B[at]microsoft.com...
> > I have a pdf file consists of transactions which bank gave me online. Now
> > Can I import this file to money?

  #3  
Old 11-07-2005, 07:10 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Import from Excel

That would be really hard. First you'd have to convert the PDF to something
that you can deal with.

Could it be done? Yes.

With readily available tools in a simple way? No.

"cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
news23EBB35-A367-4194-A345-F1ED311FF81B[at]microsoft.com...
- quote -

> I have a pdf file consists of transactions which bank gave me online. Now
> Can I import this file to money?



  #2  
Old 11-07-2005, 04:22 PM
cndesu
Guest
 
Posts: n/a
Default Re: Import from Excel

Hi,
I have a pdf file consists of transactions which bank gave me online. Now
Can I import this file to money?
--
Chanikya


"Dick Watson" wrote:

- quote -

> See also http://umpmfaq.info/faqdb.php?q=8.
> "cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
> news:05433109-7FE5-4E53-8DE2-E3E2F5A8B34B[at]microsoft.com...
> > Is there any way I can import from MS Excel to Money?

  #1  
Old 11-07-2005, 12:29 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Import from Excel

See also http://umpmfaq.info/faqdb.php?q=8.

"cndesu" <cndesu[at]discussions.microsoft.com> wrote in message
news:05433109-7FE5-4E53-8DE2-E3E2F5A8B34B[at]microsoft.com...
- quote -

> Is there any way I can import from MS Excel to Money?


 
Old 11-07-2005, 10:07 AM
JB
Guest
 
Posts: n/a
Default RE: Import from Excel

See http://xl2qif.chez.tiscali.fr/xl2qif_en.php

"cndesu" wrote:

- quote -

> Hi,
> Is there any way I can import from MS Excel to Money?
> --
> Chanikya

  #-1  
Old 11-07-2005, 07:49 AM
cndesu
Guest
 
Posts: n/a
Default Import from Excel

Hi,
Is there any way I can import from MS Excel to Money?
--
Chanikya
 

Tags
excel, import
Similar Threads
Thread Forum Replies Last Post
Import from Excel into Money
Dan Wities: Some of my accounts are at institutions that don't work with MS Money, but which I can download information in Excel format. Is there a way to...
Microsoft Money 1 01-23-2004 08:34 AM
Re: import to money from excel
Dick Watson: Asked and answered frequently. Ant it's in the FAQ at http://www.bollar.org/msmoney/#Q8. "Eran" <talyeran@nonstop.co.il> wrote in message...
Microsoft Money 2 10-19-2003 02:12 PM
import from excel
Won Lee: Any way to import from an excel file?
Microsoft Money 5 10-15-2003 06:57 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 02:18 PM.