Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pcdaugs

  1. pcdaugs

    Workbook Open Event

    Hello Skip, That is the thing, I can't tell where the error is and on which line because when you have the document set to "Shared" you are unable to get access to the VB Editor! It really sucks and I can't figure out how to see where the error is happening. Any suggestions on how I can view...
  2. pcdaugs

    Workbook Open Event

    Hello Skip, Thanks for taking a look at this for me. I tried what you suggested with the range object instead of the string. It still doesn't work as a shared document. I also tired the Worksheets(stPartner) and that still gives the same error. I don't know if I was clear enough earlier but I...
  3. pcdaugs

    Workbook Open Event

    Hello All, I have an excel workbook that is being used to track our sales people's call results. Basically, I have a list of prospects that they can call and then choose from a drop down menu whether they left a voice mail, set an appointment, not interested, and a few more options. Anyway...
  4. pcdaugs

    Problem with the Offset Property of a Range Object

    Hello Everyone, I am currently writing some code to produce a client list that tells me who bought a product from what producer(sale rep or agent). The first step in this process is to reformat a excel spread sheet that is extracted from a .PDF file so that it will build a list that shows the...
  5. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Skip, I went through and added producer1.value as below. All it did was through runtime errors. Did I do this right or you suggesting something else? Set Producer2 = Sheet2.Cells.FindNext(Producer2.Value) Thanks, Paul
  6. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Alright, I just used F8 to cycle through my code and found that the code is work beautiful up until I hit the line below that is located between the ends of the nested Do While Loops. For some reason this code assumes you want to find the next value from the most recent find method instance. Is...
  7. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Skip, Actually, I setup two new variables so that didn't have to reverse the offset. Dim rCount1 As Excel.Range Dim rCount2 As Excel.Range If Producer1.Column = 1 Then Set rCount1 = Producer1.Offset(0, 1) Else Set rCount1 = Producer1...
  8. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Skip, Again, you help has been GREAT! And just as it seems I am out of the woods and finished when another issue rears it ugly head. Boy, I forgot how much thought goes into programing! Anyway, the If statement works great I even was able to find a couple of errors in my programing...
  9. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Skip, Boy, is this a DUH moment! passing it as a range would have been smart...lol well I am very greatful for your help. Anyway, I just played around with this code and it does what I want it to do but there is still one hitch that I thought I would ask about. Producer1 and Producer2...
  10. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Skip, I understand that I need to find the next producer and I have done that with the following code in bold. Set rfnd = Sheet2.Cells.Find( _ What:="Producer:", LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext...
  11. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Skip, I am already using the FindNext(rFndP1) argument to find the next producer. The problem I am having is searching for the clients that are tied to the specific producer. Example: Report in Excel Column 1 Column 2 Producer1 Client LTC Client LTC Client LTC...
  12. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Skip, I do appreciate the help, I will be sure to reread my posts twice before I post. Maybe that way I will avoid the misunderstanding. Anyway, here are the statements I can make about the report once it is extracted into excel. ~The Producer is found most of the time in column A but...
  13. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello All, I guess I made the mistake in explaining that the .pdf file has already been extracted into excel document. Now I am searching the excel document for the producer and client and relating them to each other. If any one can help me in pulling the client out tied to their producer, it...
  14. pcdaugs

    Reformat a Report Extracted from a .PDF File

    Hello Everyone, I have a limited CRM that will produce two lists, producers and clients, in a contiguous format but the data does not show which producer wrote which client. To solve this I have another report(from the CRM) that is only available by printing it to a .PDF file and then...
See more

Part and Inventory Search

Back
Top