Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108716

Re: Working from data converted from a pdf file

Show all headers | View raw

Apparently I am going to need some more help. I will post back here once I figure out how to upload. It looks like I need to post a link out of dropbox to you can access it?

I loaded this macro into the full file which has some 4,700 rows. The reason I can't tell exactly what is happening is it appears this look goes through all the rows before it copies anything to the sheet2. I stepped through a lot of the iterations of the loop and it passes through those just fine. 

I guess what is happening is when the loop ceased to find anymore rows, it threw up an error message when it encountered the following line.

varOut(n, 0) = Split(varData(i, 1), " ")(0)

After that, it doesn't write anything. Am I close on my guess and would it just need something like an onerror statement to get it to pass on down to where it writes what it did? If I can figure that out, maybe I can build on it to add more fields.

On Wednesday, April 6, 2016 at 1:26:06 PM UTC-5, Claus Busch wrote:
> Hi Bruce,
> 
> Am Wed, 6 Apr 2016 11:23:47 -0700 (PDT) schrieb B Roberson:
> 
> > Cool beans Claus, this macro is working.. I have other fields to populate. This was a sample. Now it's time to expand the test and make sure I can figure out how to bring in other values to the table.
> 
> if you need further help, please upload a workbook with example data and
> the expected output.
> 
> 
> Regards
> Claus B.
> -- 
> Vista Ultimate / Windows7
> Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 08:23 -0700
  Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 12:21 -0400
    Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 11:13 -0700
      Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 15:07 -0400
        Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:17 -0700
          Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 15:26 -0400
  Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 18:24 +0200
    Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 19:57 +0200
      Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 11:23 -0700
        Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 20:25 +0200
          Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 11:39 -0700
            Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 20:53 +0200
              Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:17 -0700
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:27 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 15:39 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:46 -0700
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:49 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 16:05 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 13:17 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 16:30 -0400
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 16:35 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 13:51 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:12 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 14:32 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:38 -0400
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:24 -0400
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:35 -0400

csiph-web