|
#9
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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 > news 23EBB35-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
| |||
| |||
| 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 news 23EBB35-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
| |||
| |||
| 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
| |||
| |||
| 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? |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |