Results 1 to 19 of 19

Thread: Solved: Loops that write specific data to file

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    VBAX Regular
    Joined
    Sep 2010
    Posts
    28
    Location
    Quote Originally Posted by GTO
    I tried ignoring the "humor" and the fact that you are asking for some considerable coding as Kenneth mentioned.

    If one could likewise disregard the 'quite urgent' rush to provide their off-time, then maybe I'd be surprised folks aren't tossing the kids outside so they can concentrate on this.

    Maybe its because you've had it cross-posted for four days and haven't bothered to mention...

    Cross-posted at: http://www.mrexcel.com/forum/showthread.php?t=493192

    Please read Here.
    First of all, I want to apologize for my cross-posting. As you can realize, I'm new to all of these help forums, and apparently haven't read well the rules as needed.
    I just saw so many people getting support while I was waiting, and that troubled me, I assume. So, again: Sorry! :]


    ----------

    Now, mohanvijay, thanks a lot for your time and help!
    Hmm, your code runs into runtime error at line 59:
    Run-time error '9':
    Subscript out of range
    That's the line:
    [vba]
    If cprid(final) = Workbooks("sample (1)").Sheets(1).Cells(filpr, 16).Value Then[/vba]
    I have some programming knowledge, and I tried to provide a code idea above.
    Since the method is supposed to write thousands of files at once, I decreased the use in loops as far as I could.

    Can you or anyone else please have a look on my code?
    I have no doubt it has mistakes, but I think its logic is the most efficient.

    Thanks !!!
    Last edited by Aussiebear; 10-09-2010 at 06:00 PM. Reason: Added details about the error

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •