Results 1 to 7 of 7

Thread: Create Pdf files problem

  1. #1

    Create Pdf files problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear All,

    I have tried the Ken Puls Macro for printing to PDF file using PDFCreator, but I have come up with a strange situation:
    when running the code from inside the macro using F8, everything works fine, but when running the macro thru F5 or from macros option the code stops because of error. I don't believe there is a problem with the code, but rather something else.

    any hints?

    Regards
    Attached Files Attached Files

  2. #2
    If you could post the error you are getting , that would be a big help

  3. #3
    the error is:

    Run-time error 429
    ActiveX component cann't create object

    But why do you think this error happens only when running the code from beginning to end using F5 and not line by line?

    10x

  4. #4
    it could be that when you use F8 to step through the code a process in the code has time to run and finish. When you try to run run the macro a process in the code is not finishing before new code is trying to run. google this problem and you will see others have run into the same issue.

  5. #5
    I have google it before, but haven't found a way to fix it I have added
    DoEvents
    line code, but the error just moves down...any hints?

  6. #6
    I personally would drop back and and adjust the code to see if i could get it to print 1 sheet without errors. once i had that working i would move on to trying then to get the code to print muliple sheets.

  7. #7
    I was having a similar problem. My error was "ActiveX can't find object" I had to move the dll I was using to the excel startup directory. The key is in the error message.

    I suggest that you use breakpoints to find out exactly where the code is failing and then work backwards from there.


    I have excel 2003, so I can't open your file.

Posting Permissions

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