php

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...

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.

<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...

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

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...

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...

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...

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 =...

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

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...

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...