webpage

I have a spreadsheet that is a requisition form. This is only going to be used and available on our Intranet site. What I want to do is embed the spreadsheet into the website. The users can enter their quantities of what is needed into the form and then click on the Submit button on the bottom...

Hi All, I have some code which is trying to do the following: I have an excel workbook with a list of the end part of a hyperlink in column A. I want the code for each cell selected to go to the webpage of the complete hyperlink using the currently instance of IE running Copy the webpage Add a...

Hi guys I managed to copy excel data to Clipboard in Csv format: Sub CSVclipboard() Dim myRange As Range Dim strTemp1 As String Dim objDataObject As MSForms.DataObject ' require ref to MSForms library Set objDataObject = New MSForms.DataObject On Error Resume Next Set myRange =...

I have an Excel VBA that opens a webpage and clicks a link. The link runs a JavaScript that generates a PDF page in a new IE window. So far all is fine, but I have not found out how to save (download) the PDF. Below is my VBA, test it and you can see what I mean: Sub GeneratedPDF() Dim...

Hi All, I want to develop a vba prog to automatically fill in the input box in the a forum shown in the following link, which is in Chinese. The input box is on the bottom of the page. Actually, it is pretty much like the one we are using on mrexcel forum. ¡¾µêÆÌÓªÏú¡¿ÖвîÆÀÄã²»µÃ²»ÖªµÀµÄΣº¦...

I'd like to have a web page open in a separate (Access)form using parameters that would normally be passed using an HTML <FORM> 'submit' button. The wbbwebsite.navigate control only appears to pass the URL itself. Is there a way to have it also provide FORM variables?

I am trying to read the search results from an internal company web page. I can navigate to, input, click send. When the results come back I have not been able to "read" the results. Its a javascript postback The source code for the web page does not change. The end of source page reads...

hi, everyone; i am having a code to navigate my IE browser to a webpage, and then from there i want the whole webpage to copy it into my excel sheet. can anyone help me with that? webquery is not an answer! because i need to do some log-in and other functions till i get to that specific page...

When I first publish to a web page in Excel it publishes fine, I can add to the web page, and I can update the data and it will republish fine. Then one time after it saves and is about to republish, it will crash. Every time after that first crash it will crash when trying to publish. I can...

I am trying to import baseball webpages via VBA http://sports.yahoo.com/mlb/scoreboard?d=2012-03-16 The problem I am getting is that all the code from the site is too big for the variable and does not even get to the point where the scores are imported. Ultimatley I want to build a...

hi i am trying to copy particular content from the url. The urls are posted in the "a" column of my excel sheet. i want to open these links one by one and then from each open page copy a particular text back into the excel sheet eg. have below form:- A B 1...

Hi All, I am trying to retreive share prices from the following page http://www.asx.com.au/asx/markets/pr...Codes&asxCodes= AMP I can navigate several pages and searches to get there but I can't seem to get the specific piece of data I want to extract. I want to extract the last share price...

Hi I'm trying to write a macro to copy particular "fields" from a web page into excel. I am not sure of the best way to do this. This is what I have thus far ... but I' now a little stuck. Grateful for some assistance. The URL for the web page is in my code: Sub GetConInfo() Dim conIE As...

I have been playing around with Excel Trying to Get the following to occur ( automatically ) Example: Sheet 1 A1 = Bluegum Room { Colunm Name } A2 = Microsoft Luncheon { Function Name } A3 = 10:00 { Start Time } A4 = 13:00 { End Time } A5 = Anthony { Delegates Name } A6 = IBM Dinner {...

Hi... Would appreciate if any one can help me get data to the excel file from the website... http://etintelligence.com/etig/researchchannels/markets/bsestockquotes.jsp i want to get data for all the alphabets to excel file in one go... right now i have to click each alphabet and copy data...

Hi everyone, After 2 days, I give up ... and I come to you ... :-) In fact, I need to export a lot of webpages to excel, but only for the urls inside them ... urls which are behind an hyperlink and those which are not coded in html (inside a 'pre' code by exemple). I've found some macro to do...

Does anybody know how to control a website through VBA? Specifically, I am looking for the VBA code to press the "Next" and "Previous" buttons on a web page. This is relatively easy in some cases as the anchors usually have a "href" to direct the code to a new location. However, some sites...

Hi guys, Currently in order to monitor the WAN links I have to use Reachability Dashboard of Cisco Works which updates every 15 minutes. I have to see which links are down and every 30minutes put those entries into Excel Sheet to be sent to the link vendors. Also, I have to keep monitoring the...

I have a fairly large workbook. About 50% of the worksheets are charts that are updated on a daily basis. A VBA macro goes to each chart worksheet and does a "save as webpage-chart only". The chart itself is saved to a gif and a new webpage is made that displays the gif. That part works...