1. I

    PHP Excel dropdown list

    Hello guys, please i need help, I have a PHP program that creates an excel document. What i want is, if someone selects a State, it should load only the state's cities in the next cell, I cant load all the cities at once because excel has a 255 character limit on dropdown boxes. Am using a...
  2. S

    Extracting Autosuggestions from Wikipedia after entering keyword in Search with Excel vba

    Hi Friends, I have list of keywords in Sheet2AColumn like PHP A PHP B PHP C and so on. I need VBA to search keyphrase("PHP A") from Sheet2AColumn in search box and extract all autosuggestion urls into sheet1AColumn. I did search in forum posts here, but did not find a VBA code which does the task.
  3. M

    Formulas / or VBA codes .

    <tbody> Doc Date Amount Currency Profit Center <tbody> 11/8/2018 11/8/2018 11/8/2018 11/9/2018 11/9/2018 11/9/2018 11/8/2018 11/8/2018 11/8/2018 11/9/2018 11/9/2018 11/9/2018 11/8/2018 11/8/2018 11/9/2018 11/9/2018 </tbody> <tbody> 34,221.57 14,278.86...
  4. G

    Excel function to PHP function

    I have a couple of complicated functions that I need to convert to PHP so that I can build an app. Is anyone familiar with the process? Example 1: =OFFSET(A$7,MATCH(SMALL(B$9:B$844,ROW()-ROW(E$850)+1),B$9:B$844,0)-1,0 Thanks
  5. K

    How to call Excel macro from PHP/MySQL

    Hello, I have written a standalone Excel application including a VBA macro called 'GetImage()' that creates and exports image files to a given folder on the server. Currently the macro can be initiated manually by clicking on a button within Excel, however I would like to know if it is...
  6. A

    SUM + INDIRECT formula of a cell range

    Hi Guys. Im generating an Excel workbook with 2 sheets inside it from PHP, therefor im a little limited on what can / cant be achieved. I want to add a formula that sums 2 cell ranges from the other worksheet. Example =SUM(Synthesis!E36:E38)+SUM(Synthesis!E49:E51) This works in Excel, but...
  7. F

    Linking Excel to external mySQL Server for PHP

    I run a football (soccer) website and on it there is quite a bit of data and quite a few statistics such as league tables, goalscorers, appearance totals etc. which can change on a daily basis. Rather than change each page each day, the data is fed in to the website using PHP and MySQL. I...
  8. L

    XMLHTTP problems

    I'm trying to extract data from some webpages. I'm pulling in the html with an XMLHTTP object and extracting the desired information with Regex. The following code works fine for vanilla ".html" pages: Dim pageHTML As String Dim oXMLHTTP As Object Set oXMLHTTP =...
  9. J

    Can we write any other script in Excel macro other than VB script

    Hi Guys, I was trying to be a bit innovative and was thinking can we write any other scripting language like PHP,JSP other than VB Scripts in Excel Macros Please guys advise me on this, whether we can write anyother scripts other than vb script in Excel macros. Regards, Jibanendu
  10. R

    Web Query Confusion/Help!

    Hi everyone, first post! Anyway, I have an issue which I cannot find the answer to regarding excel web queries. I work for a staffing company and am trying to help our recruiting department locate licensed therapists. Each state has their own online verification site. I hoped to create a web...
  11. S

    using excel to create a drop down menu with links for dreamweaver

    Hello fellow nerds, I am looking for your abundant wisdom. So I'm making a website with multiple categories the each have their own page. I'd like to create a drop down menu for all the category pages. I DO NOT want to copy/paste each and every name and link into dreamweaver. I WOULD LOVE if...

Some videos you may like

This Week's Hot Topics