Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

What r the steps needed to convert the functionality of my excel vba workbook into a service I can provided to users from my website

Posted on 2014-01-11
3
Medium Priority
?
312 Views
Last Modified: 2014-01-14
I have created numerous useful excel workbooks that create various pdf files using vba.

What are the steps I would need to take to enable visitors to my website to create custom pdf files using these macros.

Now I imagine I would need to convert the macros into some language that can mimic some of excel's vba functionality.

However I do not want visitors to have acces to my code.

I want them to enter thier data on some type of webform and then receive a downloadable pdf file.
0
Comment
Question by:Dov_B
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 39774349
I believe this has nothing to do with Excel.

You will have to use any of the programming languages supported by websites, i.e. javascript or any of the dot net languages.

There are ready made solutions such as Doculicious.

You may also be interested in iText an open source library that allows you to create and manipulate PDF documents, the disadvantage is that you will have to code your own solution.
0
 

Author Closing Comment

by:Dov_B
ID: 39781128
Thank you and good to hear from you. I have been away from ee for quite a while. Kol Toov!
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39781340
Good to see you around too. Happy tu!
0

Featured Post

Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question