Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

Run Excel 2010 macro template on my PHP website

Hi all.

I have a website where my end users log on and enter some data: Builder/Community, and slab count. The data is stored on the MySQL web server. We have an Excel template with macro where the end user enters data parameters: Month/Year1 and Month/Year2 and they click a button that then pulls the data from the MySQL web server and does some calculations and then my Excel VBA script then creates some charts based on that data. This Excel file is on our network.

Now, my question is if it is possible to be able to run this same Excel template directly on my webpage. Have the end user enter the date parameters and then click a RUN button and the webpage will pump out the Excel file with the data and charts.

We want to do this because sometimes we are away from the office and we need to run this report. The way we do it now, is we call someone at the office to run it for us and email it so we can view it on our iPads. It would be great if we could do this directly on our iPads while on the website.

Is there any way to do this?

Thank you in advance!
0
Sim1980
Asked:
Sim1980
  • 3
  • 2
  • 2
2 Solutions
 
jkpieterseCommented:
VBA will not work on Web Excel. Period. But you can use Javascript to manipulate embedded Excel files. I show an example on my website:
http://www.jkp-ads.com/articles/embeddedexcel00.asp
0
 
EddieShipmanCommented:
Take a look at the PHPExcel library. I believe it has macro capability.
0
 
Sim1980Author Commented:
Thank you both for your suggestions. Could I use something like Apache OpenOffice or Google Charts on the website instead?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jkpieterseCommented:
OF course you can, but it'll have it's own implications on how complex it is to build.
0
 
Sim1980Author Commented:
Ok. The problem I see is that my current Excel workbook connects to the MySQL database through the MySQL 5.1 ODBC driver that is installed on our workstations, I don't see how I can make it work other than using the PHPExcel library or Google Charts etc.
0
 
EddieShipmanCommented:
To be honest, it would probably be simpler to rewrite the macro to do it's manipulations in PHP, since you are using PHP to output the results, anyway. You probably could have been done with it by the time you research how to do it any other way.
0
 
Sim1980Author Commented:
Thank you. I'm going to post another question about other possible solutions not working with Excel because of our iPad usage. Some Excel charts do not show correctly on iPads.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now