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
Solved

Run Excel 2010 macro template on my PHP website

Posted on 2013-10-22
7
428 Views
Last Modified: 2013-10-23
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
Comment
Question by:Sim1980
  • 3
  • 2
  • 2
7 Comments
 
LVL 11

Expert Comment

by:jkpieterse
ID: 39593403
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
 
LVL 26

Assisted Solution

by:EddieShipman
EddieShipman earned 250 total points
ID: 39593759
Take a look at the PHPExcel library. I believe it has macro capability.
0
 

Author Comment

by:Sim1980
ID: 39593953
Thank you both for your suggestions. Could I use something like Apache OpenOffice or Google Charts on the website instead?
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 11

Accepted Solution

by:
jkpieterse earned 250 total points
ID: 39594098
OF course you can, but it'll have it's own implications on how complex it is to build.
0
 

Author Comment

by:Sim1980
ID: 39594151
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
 
LVL 26

Expert Comment

by:EddieShipman
ID: 39594842
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
 

Author Closing Comment

by:Sim1980
ID: 39594860
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 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