Results 1 to 3 of 3

Thread: Cannot retrieve the exact data that i want.

  1. #1
    wkqs97
    Guest

    Angry Cannot retrieve the exact data that i want.

    I cannot retrieve the exact data that i want instead of showing all the details in the file. i only need a part from the whole file. But what i get after run the VB, it shows the all data contain in the file.

    Full code and some pictures are post at the attachment.

    Thanks for helping me !
    Attached Images Attached Images   
    Attached Files Attached Files

  2. #2
    eXtreme Programmer .paul.'s Avatar
    Join Date
    May 2007
    Location
    Chelmsford UK
    Posts
    25,464

    Re: Cannot retrieve the exact data that i want.

    Where's the file, and what do you want to retrieve from it?
    I can see that you're replacing " " with "". Then trying to split on " " , which will return the entire string with no spaces...

  3. #3
    wkqs97
    Guest

    Re: Cannot retrieve the exact data that i want.

    I want to retrieve the Project ID in the excel file at row 71 column F. but when i try to extract the file, it gave me the whole page of data which is not needed. all i need is the PROJECT ID at ROW 71 COLUMN F

Posting Permissions

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



Click Here to Expand Forum to Full Width