• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Error Appears - PDF Export from Excel

I

inbp

Member
Hi all respected,


i am using this article http://www.excelhero.com/blog/2010/04/excel-acrobat-pdf-form-filler.html


this is the excel file.

https://www.dropbox.com/s/4hggtslic73oqyt/Acrobat_FDF_Form_Fill_excelhero.com.xls


problem is when i click on create pdf button


"Complie Error:"

"Can't find project or library"


can anyone guide me how can i remove this erro?


Error appear here "Left$(sTmp, 2))"


If Len(vClient(1, 3)) > 3 Then

sTmp = Replace(vClient(1, 3), "-", "")

sFileFields = Replace(sFileFields, "---EIN_LEFT---", Left$(sTmp, 2))

sFileFields = Replace(sFileFields, "---EIN_RIGHT---", Mid$(sTmp, 3))
 
Hi, Muhammad Shakeel!


Check if you have these references in your VBA project:

- Visual Basic For Applications

- Microsoft Excel NN.0 Object Library (14 for 2010)

- OLE Automation

- Microsoft Office NN.0 Object Library (14 for 2010)

- Adobe Acrobat 10.0 Type Library

- AFormAut 1.0 Type Library


If you have them all, check if any other is marked as missing. But I think that the raised error isn't related to that instruction, since it's a mere string function, nothing involving referenced objects. In my case even without the pdf file "f8655.pdf" it run fine at least up to the next sentence of your posted code.


Regards!


PS: Perhaps you may want to give a look to this topic and get in touch with the OP:

http://chandoo.org/forums/topic/using-excel-to-populate-a-pdf-form
 
Sir i am using office 2013 following were not found in library


- Microsoft Excel NN.0 Object Library (14 for 2010)

- Microsoft Office NN.0 Object Library (14 for 2010)

- Adobe Acrobat 10.0 Type Library

- AFormAut 1.0 Type Library
 
Hi, Muhammad Shakeel!

I won't have access to machines with Office 2013 until Tuesday, but you should find at least the 1st two references with 15.0 instead of NN.0. For the 3rd one you must have Adobe Acrobat (or Reader installed), no matter what version, I remember that it worked with 9/X/XI. The last one I've surely seen it in Reader X/XI, so if you download and install the last version of that software you'd be getting those references.

Regards!
 
ok thank you Sir its working only after installing adobe reader, but can you help me in changing the formatting of document?? i need other type of data use in School Fee Voucher


Following Excel File need to be in PDF.. the data highlighted in Yellow color is dynamic

https://www.dropbox.com/s/6565ro2bv0pp8hf/Excel%20Data%20-%20Button.xlsx


While following is the file where detail enter

https://www.dropbox.com/s/6565ro2bv0pp8hf/Excel%20Data%20-%20Button.xlsx


i shall be highly obliged for your support sir (i am not well known about macros so request it to you)


Regards!

Shakeel
 
Hi, Muhammad Shakeel!

I'm leaving now (Sat 5PM GMT-3) and will be back on Monday or Tuesday. If you haven't solved it yet I'll give a look then.

Regards!
 
Hi, Muhammad Shakeel!


Tuesday, coming back here as said before, and verify 2 things:


a) You bumped twice this post so as if doing so you were to receive more attention. Contrarily you might disencourage people who could be able to help you. Hence posting again in the same topic without adding any useful information, doesn't guarantee at all that bumping it will accelerate any answer.


Are you hurried? If so start reading the main green sticky post at this forums main page...

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

... if you had done so, you should have noticed this points:


"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."


"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."


"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."


BTW, you've been part of this community for six months wrote almost 90 posts and you still haven't passed by the Introduce Yourself topic, which is nor a requisite neither necessary but just a polite attitude.


b) You said that the .pdf file on the first link isn't what you need, but I think you didn't check the links you posted here upwards:

http://chandoo.org/forums/topic/vba-error-appears-pdf-export-from-excel#post-110525

since both are of the workbook and not for the .pdf file.

Would you please upload it and paste its link here? Thank you.


Regards!
 
thank you Sir for your reply and post.


actually i have post it, because on my topic it was appeared that "RESOLVED" and i was unable to edit that. that's why i post again without any information. Sorry for that. i will be careful next time and thank you for guiding me.


you need .pdf file also??
 
Respected Sir.


Thank you for your reply, no issue, when you will free, take your time, if can resolve it will be great for me.


Regards!

Shakeel
 
You must log in or register to reply here.
Back
Top