Hi,
I just created a Add-Ins to add more option to the “save as PDF” via the use of a form. The user have to indicate the directory where he wants the pdf file(s) to be save by filling a text box.
Could somebody help me to create a BROWSE to directory button ?
If someone is interested I could post the add-in on the forum; just let me know. (see 2 messages futher … 
)
Cheers!
Olivier
OlivierV (BOB member since 2002-10-15)
Hi Olivier and welcome to Bob! We’re always interested in new code so we can add to our library 
If you could post it here we’ll put a copy there - perhaps when we’ve got it updated with your browse directory requirement.
Nick Daniels 
(BOB member since 2002-08-15)
Ok,
I give it a try to link to the file in zipped version.
The Zip file contains the pdf.rea file that you just have to install ghas a add-in.
If somebody could help me to add a browse buton on the form, he (she) get all my concideration and will be credited for the work. If you update it; send the zip back by e-mail and I will update it opn the server.
Cheers! and let’s work together
Olivier
Zip file 
: PDF.zip
OlivierV (BOB member since 2002-10-15)
Microsoft has a built in Active-X control that should do this for u… Its the CommonDialog control. I have not used it in BO but it should work in VBA (well, it works in VB 
)
hope it helps
avaksi 
(BOB member since 2002-08-22)
Thank you for you help 
I just tried but the bad news ( 
) is that it doesn’t work in BO (not in VBA in fact). Do you have another idea ?
Did you triy my Add-Ins ? It would be goed for me tho have some feed-back in order to enhance the system 
Cheers!
Olivier
OlivierV (BOB member since 2002-10-15)
hey…
I tried it and got it to work… Do u have VB installed on your machine? This control is on every PC on the world but is not licensed for design-time only run-time.
U will have to install VB to get access to this control. To check if this is the issue do the following…
1 Insert a Form to your code
2 On the Toolbox, right-click and choose Additional Controls
3 Find the MS CommonDialog control
4 Now when u try to put it on the form u should get an error…
I will check the add-in and give feedback tomorrow…
avaksi (BOB member since 2002-08-22)
Avaksi
No I don’t have VB on my (at work) machine 
so that’s why iI can’t use it in design and the problem is that they won’t let me install VB just for one buton
Yes that’s it … something about bad licencing …
Merci ! and see you tomorrow !
Olivier
OlivierV (BOB member since 2002-10-15)
me likes it!!! 
very nice… I really like the ‘PDF’ on the menu trick u pulled.
nice work…
avaksi (BOB member since 2002-08-22)
Thank you !
Now we have to get the Browse to directory working !!!
Olivier
OlivierV (BOB member since 2002-10-15)
Thank you Oliver! I love it!!!
David Piet (BOB member since 2002-10-01)
Olivier
I will try and work on this over the weekend. I am thinking of changing the ‘PDF’ menu to say ‘Convert’ and then give the option to the user to create PDF, XLS or TXT files. I will include the option of choosing reports, documents as I love that feature. I will also include the commdlg control so that they can browse to the location.
Converting to pdf and txt is easy as BO supports it natively. I will try and modify Daves code in the Code section to get the xls conversion. I am sure he wont mind if we promise to put our add-in to the samples
Folks, any ideas or suggestions??
ADDITION: Any other conversions used by users?? It would be fun if we could make it an exhaustive list…
avaksi (BOB member since 2002-08-22)
This would be a great feature! Will it work for ZABO users? 
David Piet (BOB member since 2002-10-01)
Hi Oliver,
Is Browse to directory working? I am using your add-on and it’s great!
Previously, I was looking for a macro for creating PDF files for each report tab page. Now, this served more than what i need…
Thanks again,
Ravi Amara (BOB member since 2002-10-02)
I have the browse working on the add-in but need to add some error routines. Will post it tonite or tomorrow morning…
How do u upload Add-Ins to the Forum??
avaksi (BOB member since 2002-08-22)
Send it to Dave…
Eileen King (BOB member since 2002-07-10)
or, Not an easy solution
register for a free web page with some username ‘XXX’ at
Zip the file(PDF.zip) and upload it into the account.
And, gave us the link…
Hope this is OK at BOB…
Ravi Amara (BOB member since 2002-10-02)
More specifically, please send it to busobj@forumtopics.com. That’s the email address for Bob.
In your email, please reference this topic, provide a brief readme, and any other appropriate information that you would like to have posted. Thanks for sharing! That’s what makes this forum so awesome. 8)
Dave
Dave Rathbun (BOB member since 2002-06-06)
Sure, it’s fine. But if we can post it here, we’re happy to do so. That way everything is in one place.
Dave
Dave Rathbun (BOB member since 2002-06-06)
Avaski
Did you include the Browse button and the error handling?
Did you manage to upload it to Bob?
Miguel Varela (BOB member since 2002-08-15)
Yes, Olivier helped me with that but I am yet to add the error routines. I am mailing the add-in to BOB and will add the relevant routines once Bobbers test it and find issues…
Olivier and I tested it on Windows 2000, Windows XP. Also you will need Excel on the PC if you wish to use the Add-in to its full potential…
avaksi (BOB member since 2002-08-22)