Publish Excel To Internet Web Page

Feb 3, 2010

I have this spreadsheet that I use regularly and that others also view (not edit) and to facilitate viewing, I would like it to go on the net.

Ideally, simple editing would be done from within the browser.

View 5 Replies


ADVERTISEMENT

Put In Error Handling In Case The Format Of The Page Changes Or The Internet Page Is Unavailable

May 18, 2006

I have some code that parses an html table. I want to put in error handling in case the format of the page changes or the internet page is unavailable. I am testing without an internet connection and the run time error is not being branched off to the error handler and is fatally ending the macro. This is true also if I raise an error manually.

Private Sub ParseInjuryPage()
On Error Goto ErrorHandl
Dim strPage As String
Dim webIE As SHDocVw.InternetExplorer
Dim myURL As String
Dim tableBeg As Long
Dim tableEnd As Long
Dim RowBeg As Long
Dim rowEnd As Long
Dim cellBeg As Long
Dim cellEnd As Long
Dim strBeg As Long
Dim strEnd As Long
Dim myCell As Range
Dim rowNum As Integer
With Sheets("INJ")
Set myCell = .Range("A2")
.Range("A:F").Value = vbNullString
rowNum = 2
Set webIE = New SHDocVw.InternetExplorer
myURL = "http://www.sportsline.com/nfl/injuries"
webIE.Navigate myURL
Do Until webIE.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
strPage = webIE.Document.body.innerhtml...................................

View 6 Replies View Related

Macro To Publish Print Area From Active Sheet To Web Page

Feb 26, 2009

I am trying to write a macro that publishes the print area as a non-interactive web-page to a file that sits in the same location as the spreadsheet from which the macro is being run.

I am using the the following macro:

View 14 Replies View Related

Open An Internet Page

Nov 15, 2006

I have tried to open an internet page usin excel in order to get some information, for this I wrote the following code which doesn't work:

Dim i As Integer
For i = 2 To 3000
Workbooks.Open Filename:="http://www.anm.ro/anm/anm_maint.asp?anmPage=2&ID=i"
Application.Goto Reference:="R12C3"
Range("C12:C25").Select
Selection.Copy
ActiveWindow.ActivateNext
ActiveCell.SpecialCells(xlLastCell).Next.Select
ActiveSheet.Paste
ActiveWindow.ActivateNext
ActiveWorkbook.Close
Next
End Sub

How can I make so that, this procedure to open page with ID 2, and 3and so on

View 2 Replies View Related

Print Internet Explorer Page

Mar 22, 2007

Does anyone know the command in VBA to print the current Internet Explorer page? I was exporting it to Excel to print, but I could save time if there is a command to activate the print button.

View 9 Replies View Related

How To Go Back To Previous Page In Internet Explorer Using VBA

May 8, 2014

how to go back to previous page in internet explorer using vba.

View 2 Replies View Related

Publish Excel List In Word?

Aug 17, 2013

I have a list of club members in Excel.

Is there some method in Word that allows a directory in Word to update from the Excel List?

E.g. If new members are added to Excel, When I open Word, the new members are shown automatically?

View 1 Replies View Related

Excel To HTML - Auto Publish With File Update

Feb 18, 2011

Im trying to use excel as part of an real time display system, what im looking to do is after xx time period import some data (which is fine, I have that bit sorted), then save to as html- (hopefully using excel 07 abilty to repubish data to update the same file with more info).

I have added some Javascript to the html file to auto scroll, and then will be adding a refresh script which should hopefully update the display with any new info genrated from excel...

so far I have found the following code, but could do with a hand to tie it all up!

Code:
Public Sub Watchon()
State = "Mointoring Folder..."
Timerun = Now() + TimeValue("00:10:00")
Application.OnTime Timerun, "DetectNewFiles"
Userform1.Nextupdate.Caption = ">Next Update will be @: (" & Timerun & ")"
With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _

[code]....

Then within DetectNewFiles Sub, I need to update the html data, I guess I can't reuse the above bit, as it would just overwirte the whole file (and so remove javascripts too).

Code:
Sub DetectNewFiles
'Some code to import text files to excel
With ActiveWorkbook.PublishObjects("Book1_24990")
.Publish (False)
.AutoRepublish = True
End With

Some code to reset next time update of DetectNewFiles

View 1 Replies View Related

Can Retrieve Data From Internet Using Excel / VBA

Oct 27, 2012

I have a list of zip codes in excel, which I need to pass to store website and retrieve all the store locations in that area..

For example:

[URL] .... "choose my store on the left"

or [URL] ....

Is it possible to do this in Excel/ VBA?

View 3 Replies View Related

Updating Local Excel File Through The Internet?

Apr 14, 2014

30 people in different countries use a sophisticated VBA Excel file on their local PCs, let's call it myexcelfile.xls. This file contains no custom data, as all data is stored in myexcelfile_backup.xls.

The biggest challenge with this set up is that whenever there is a newer release or bugfix of myexcelfile.xls, I need to send it out per email to 30 people and hope they replace it with my updated version.

Note that newer versions can replace older versions without any data loss, as all data is stored in the backup file.

Idea: with tools like WGET or BITSADMIN, I was thinking of creating a batch file, that would simply download the latest version from a FTP server, and replace the older version with the newly downloaded one.

Constraints: I shouldn't be using any software that is not native to Windows 7the files can sit in different folders on these 30 computers, therefore the update mechanism would have to identify the path they are in.the update mechanism would have to close the file first before running the update. Question: What is the best way to go about this? A DOS Batch file? Or another excel file that is just the "updater", meaning, it's only purpose is to download the new file from the web and overwrite the old file?

View 1 Replies View Related

Excel VBA Automation For Internet Explorer To Website

Feb 26, 2013

I have been trying for some time to be able to download a file from what I believe to be a FTP site. There are three user input fields which I have been able to identify there names. After these fields are complete there is a button to push which I have also identified it's name.

Once the process of pushing this button is done, an unspecified amount of time must occur for data to be gathered and the option of Open, Save, or Canel appear in a Download window. I would then need to Save and Overwrite an existing file.

No Login or Password is required.

I have been able to automate the open of I.E. and input to the three select fields as well as the necessary button push.

However, I am unable to identify how to automatically save the file into a specified location, with overwrite privileges enabled. Below is my progress

View 9 Replies View Related

Not Able To Open Excel File Downloaded From Internet / Mail

Jun 27, 2013

I am not able to open any excel file which comes as attachment with mail.It shows the message "file is corrupt ".

However , once it is open from other computer, I can view the same in LAN system.

View 2 Replies View Related

VBA - Download Excel File From Internet And Then Extract Data Out Of It

Dec 20, 2012

I'm trying to download an Excel file from the internet and then extract data out of it. The problem is that I don't get any errors, yet the file downloaded is only 1kb in size. The extraction bit works, but the file is empty. The actual file is size 350KB.

Code:
Sub ExtractDataTest()

Dim FileNum As Long
Dim FileData() As Byte
Dim MyFile As String
Dim WHTTP As Object

On Error Resume Next

[Code] ....

View 1 Replies View Related

Excel 2007 :: Linking Cell To Part Of A Table On Internet

Apr 26, 2014

I am using Excel 2007. A few years ago I managed to link a spreadsheet to a particular part of a website. To be specific, I linked a cell to a portion of a table on a website showing the current average price of petrol in the U.K. I also linked a cell to a website which showed the current exchange rate for pounds and dollars. I haven't been able to replicate the procedure.

View 3 Replies View Related

Mailing Address Pasted From Internet To Excel And Then Mail Merge With Word?

Jul 26, 2013

I'm trying to use Word mail merge with Excel to create mail labels and letters for each person on the list. For example,

Johnson, Michael
7391 Wilson Street
Van Nuys, CA 91405

I want to create a mailing label for this person. If possible, I'd like to make the top line of the address "Dr. Michael Johnson," however the format that I'm copying from is last name, first name. And I also want to want to create a letter that starts with "Dear Dr. Last name," such as "Dear Dr. Johnson." This is the website that I want to copy the addresses from:

Doctors in Los Angeles, CA | Primary Care Physicians and Specialists

I have done my homework, but I don't know how to properly paste the addresses into Excel and then use Word to create the labels and letter. I have tried many ways, but I have been unsuccessful.

View 1 Replies View Related

Publish File On The Web

Aug 13, 2008

I developed a small program using Microsoft Office Excel 2007 and VBA. The program contains some user interface items such as command buttons and userforms for user input.

During the distribution of the program I realised that most users do not have Excel 2007 yet. When I try to convert the file into Excel 97/2003 it is not possible because I used features not available in this version.

I was wondering if there is any way of publishing the Excel file in the web. In this way Excel 2007 would exist in the server and the users could use the file directly from the server without needing Excel 2007 installed in their computers.
I tried to save the file as "Web page" or "Single File Web Page" but the "buttons" stopped working, I guess the VBA code is not saved..

View 4 Replies View Related

Excel 2010 :: Hyperlinks With JPG Files Using Internet Explorer Do Not Show Pictures On Win7

Jan 26, 2013

In Excel 2007, Hyperlinks in cells pointing to jpg files in a subfolder display with internet explorer. On my WinXP/Intnernet Explorer 8/Office 2007 system these links work fine.

When sending the excel and jpg files to another person with Win7/Office 10, jpg hyperlinks work and launch Internet Explorer but come up blank. (Hyperlinks to PDF files work fine and show up in Acrobat, just the jpg's come up blank in Explorer.)

Questions:
What is causing this, a setting in Explorer/Win7 or Excel?
Can I change Excel hyperlink default software to use something other than Explorer to display the jpg files?

View 5 Replies View Related

VBA To Publish A Worksheet To Our Website

Nov 7, 2007

We are a construction company.
We travel and do work local.
Some employees that have access to the internet at home.
Some have access when they stay at hotels.

What I would like to do is give them a work schedule on our website.
I would really like to do this using VBA.
Is it possible to save the worksheet and send it to our website?
I would love to attach a Macro to a button so the person, after updating the schedule, just punches that button and the updated sheet goes on our website.

View 9 Replies View Related

Publish Data To Sharepoint Calendar

Nov 16, 2007

I use an excel report that connects to an external sql datasource and using macros imports and arranges the data showing dates, job number, description and author of various jobs coming up at work.

I want to publish this spreadsheet's contents onto a calendar in excel or (preferably) onto a sharepoint calendar.

Does anyone know how to:

1) Publish the spreadsheets contents into a calendar in excel?

2) Publish the spreadsheets contents onto a calendar in sharepoint?

View 3 Replies View Related

Page Break Preview It Shows The Page Numbers In The Centre Of The Page

Jun 9, 2009

When I view a sheet under Page Break Preview, it shows the Page numbers in the centre of the Page. While I am aware that it would not print the page number I was wondering if there is an option to remove/hide the page numbers.

View 3 Replies View Related

Excel Page Setup Up

Jun 16, 2009

This might seem a strange type of Excel question.

Some "Clever" person decided to create a site plan using MS Excel. It has been done quite well tbh. The problem with Excel is that I am unable to set a custom page size as this plan sits nicely on a paper size I made ealier through using Word. Guess what there is a custom page size selection on Word but not Excel. Is there a walkaround for this ?

The only other way I can do this, is to print off 2 a4 landcape print out but the printer goes to the next page and leaves a nasty seperation.

The copy of Excel i have is 2003 sp3

View 9 Replies View Related

Excel 2010 :: Add Search Box To The Top Of Page?

Jun 12, 2013

I have an excel 2010 file that we export (save) to HTML so we can upload to our website.

1) Can I add a search box to the top of the page?

2) Can I freeze the row headings?

View 1 Replies View Related

Reference Particular Cell To A Page In Excel

Aug 11, 2013

How to link a particular cell to many pages in excel. In my when i drag the pages, Rollno are not coming sequentially.

Here is my worksheet (Result.xls)

View 5 Replies View Related

How To Insert Page Numbering In Excel Cell

Nov 16, 2005

I'm trying to have a repeating cell automatically update the page number and number of pages, much the same as in a header/footer situation, but I need it to be done in 1 cell.

View 2 Replies View Related

VBA To Convert Excel Invoice Page To PDF And Mail From ID

May 2, 2014

I am uploading excel file. I need it to convert the invoice page to PDF and mail it to the mailing addresses which is in b13 and b14 with my mail id .

View 2 Replies View Related

Excel 2003 :: Only Partial Page Prints?

Jul 27, 2008

Using Excel 2003 I have had this problem ocassionally, and I can't figure out what causes it or how to fix it. In a workbook of several excel worksheets I will ask to print a mulitple page worksheet and only 2/3 of every page prints. This also happens if I print to an Adobe acrobat file, and typically happens when I am printing to pdf files. The selection is correct; there are no page breaks . . . it is just some sort of glitch. The only way I get rid of it is to close down and reboot .

View 8 Replies View Related

Excel 2007 :: Adding Page Break With VBA

Mar 25, 2011

I have been trying to write a macro to add a page break in Excel 2007, but I have had no success.

A friend recomended:
Columns("CC:CC").Select
ActiveWindow.SelectedSheets.Vpagebreaks.add Before:= ActiveCell

This has not had any affect when I have printed.

View 3 Replies View Related

Apply A Bottom Page Border In Excel File?

Nov 6, 2012

I want to apply a bottom page border in my excel file. The page border should be fixed, i.e. if you insert a row above the border then the border should not shift as well.

View 2 Replies View Related

Excel 2007 :: Removing Page 1 Etc From Sheet Background?

Apr 6, 2010

I'm working with a very large spreadsheet which has somehow divided itself into print areas. Each section has 'Page 1' or the equivalent as a background, behind the data itself. I thought it would be simple to remove this, but for the life of me I can't see how. I'm using Excel 2007.

View 6 Replies View Related

Excel Macro Enabled Dashboard To Interactive Web Page

Jun 3, 2014

I have created a dashboard in excel and want to convert it into an interactive web page.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved