Free Microsoft Excel 2013 Quick Reference

Convert Excel worksheet to interactive web page

Is there a program to convert a complex Excel worksheet with massive data lookup pages to be an interactive Web page? ( visitor fills out info - program returns results - visitor can save or print )


I am trying to save an Excell worksheet as a Web page and some of the
headings are dropped. Using Office 2003

I need help converting Excel worksheets to a PDF file. I have a fairly complicated file (at least for me) that is used by construction estimators. The file consists of about 12 worksheets and contains hundreds of formula, checkboxes, etc. At present the estimators print out only the relevant part of each worksheet after they enter the job details, then scan the print outs to create a PDF file, then email the PDF file to our field offices. I am looking for an efficient method to directly create PDF file of only the print range portion of each worksheet. I really just need a duplicate of the print in PDF format. I do not need hyperlinks, metadata, or anything fancy in the PDF. I have read about the “click-to-convert” program, “metadata assistant”, and “verypdf” and maybe an Adobe product would work, but I have no experience with any of them. Would printing to Microsoft Document Image Writer be a good alternative? Cost is really not an issue, the company will buy whatever works best. Thanks in advance to all.

Hi all,

I know a little bit about Excel VBA, enough to create some simple macros and such but this is way beyond me, and if I could get this to work in some capacity it would save my group a bunch of time I thought I would ask for some help here. I've looked around and didn't see much when it comes to inputting info from Excel to a web page. Long story short every day values must be updated from an excel spreadsheet to a web page. Those values seem to be contained in this var contents line and I'm assuming this is where i need to upload them or recreate this line? I've made bold a couple of the examples of the values that would need to be changed. I'll send the HTML for the entire page if needed but be warned its pretty long and the javascript var section isn't until line 1334. Long story short I know how to create an instance of IE and not much more past that. Any help or pointers in the correct direction will be appreciated.

			    var a
= window.open('','' , 'width=895,height=400,scrollbars=yes, resizable=yes');
			    a.document.open("text/html");
			    a.document.writeln("<pre>");
			    var contents =
"I:LBPBER.IV,741,LEHMAN,ILBPBERIV,0.000,63.139112,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LBPBTR.IV,741,LEHMAN,ILBPBTRIV,0.0005418017,68.919481,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPAGER.IV,741,LEHMAN,ILPAGERIV,0.000,115.164662,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPAGTR.IV,741,LEHMAN,ILPAGTRIV,0.0005418017,125.493495,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBCER.IV,741,LEHMAN,ILPBCERIV,0.000,120.751585,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBCTR.IV,741,LEHMAN,ILPBCTRIV,0.0005418017,131.583972,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBOER.IV,741,LEHMAN,ILPBOERIV,0.000,99.864388,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBOTR.IV,741,LEHMAN,ILPBOTRIV,0.0005418017,108.820301,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBSER.IV,741,LEHMAN,ILPBSERIV,0.00,126.21723,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBSTR.IV,741,LEHMAN,ILPBSTRIV,0.0005418017,137.534612,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBWER.IV,741,LEHMAN,ILPBWERIV,0.000,120.64712,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPBWTR.IV,741,LEHMAN,ILPBWTRIV,0.0005418017,131.461579,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPCLER.IV,741,LEHMAN,ILPCLERIV,0.000,51.299189,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPCLTR.IV,741,LEHMAN,ILPCLTRIV,0.0005418017,55.909333,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPCTER.IV,741,LEHMAN,ILPCTERIV,0.000,51.242154,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPCTTR.IV,741,LEHMAN,ILPCTTRIV,0.0005418017,55.843218,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPGDER.IV,741,LEHMAN,ILPGDERIV,0.000,132.145393,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPGDTR.IV,741,LEHMAN,ILPGDTRIV,0.0005418017,143.990806,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPHOER.IV,741,LEHMAN,ILPHOERIV,0.000,51.268391,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPHOTR.IV,741,LEHMAN,ILPHOTRIV,0.0005418017,55.87717,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPIAER.IV,741,LEHMAN,ILPIAERIV,0.00,53.286349,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPIATR.IV,741,LEHMAN,ILPIATRIV,0.0005418017,58.072121,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPKCER.IV,741,LEHMAN,ILPKCERIV,0.000,80.081933,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPKCTR.IV,741,LEHMAN,ILPKCTRIV,0.0005418017,87.26915,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLCER.IV,741,LEHMAN,ILPLCERIV,0.00,79.661206,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLCTR.IV,741,LEHMAN,ILPLCTRIV,0.0005418017,86.804833,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLHER.IV,741,LEHMAN,ILPLHERIV,0.000,75.640201,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLHTR.IV,741,LEHMAN,ILPLHTRIV,0.0005418017,82.42813,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLNER.IV,741,LEHMAN,ILPLNERIV,0.000,58.308178,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLNTR.IV,741,LEHMAN,ILPLNTRIV,0.0005418017,63.53771,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLPER.IV,741,LEHMAN,ILPLPERIV,0.000,63.170741,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLPTR.IV,741,LEHMAN,ILPLPTRIV,0.0005418017,68.838128,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLXER.IV,741,LEHMAN,ILPLXERIV,0.000,47.900469,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPLXTR.IV,741,LEHMAN,ILPLXTRIV,0.0005418017,52.199411,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPNGER.IV,741,LEHMAN,ILPNGERIV,0.000,31.32802,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPNGTR.IV,741,LEHMAN,ILPNGTRIV,0.0005418017,34.14486,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPSBER.IV,741,LEHMAN,ILPSBERIV,0.000,54.696803,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPSBTR.IV,741,LEHMAN,ILPSBTRIV,0.0005418017,59.613784,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPSIER.IV,741,LEHMAN,ILPSIERIV,0.00,106.989736,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPSITR.IV,741,LEHMAN,ILPSITRIV,0.0005418017,116.584612,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:14<br>I:LPSMER.IV,741,LEHMAN,ILPSMERIV,0.00,144.688615,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:23<br>I:LPSMTR.IV,741,LEHMAN,ILPSMTRIV,0.0005418017,157.661625,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:23<br>I:LPUGER.IV,741,LEHMAN,ILPUGERIV,0.000,64.363167,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:23<br>I:LPUGTR.IV,741,LEHMAN,ILPUGTRIV,0.0005418017,70.154279,X:SUSDUSD,687,,,D,1430,2215,-060,P,Y,Start,Open,15,20090330,16:33:23<br>";
			    a.document.writeln("LBPITicker, LBPISourceID,ClientID,CUSIP,DailyTreasuryBillRate,PreviousIndexLevel,Currency
Conversion Ticker, Source ID for Currency Conversion Ticker,Daily Price Change
Threshold,EndofDayOverridevalue,CurrencyMultiplyDivideFlag,Portfolio StartPublish Time, Portfolio Stop Publish Time, Publish
Time DST Adjustment, StatusFlag, BillingFlag, Start Stop Publish Flag, Publish Open Close Flag, Calculation Frequency
Interval, Rundate,Update Time");
			    a.document.writeln(contents);
			    a.document.writeln("</pre>");
			    a.document.close();


Does anyone know if this is possible. Would like to have a columned data sheet in excel and be able to pull information from the excel file to the Web page. Kinda like using the Vlookup to look up the first column and getting information from the others. If anyone knows if this can be done and if so are there any good tutorials or anything online. Thanks.

I have an Excel work book with a single spread sheet. I have set one column
in the sheet to 'Wrap Text' in the cells - the type as 'general'. In the xls
version all looks good - but when I save it as an interactive web page, the
wrapped cells no longer wrap.

Trying to convert a workbook into an interactive web page ready for publishing, I chose File- Save as a Web Page from the Menu bar, and followed the required steps. In the Save As a Web Page dialog box, I checked "Add Interactivity With: ", but I get the error message:
"The Microsoft Office Spreadsheet Component could not load the XML data.
Validation Load Error: For Type list, the absence of a < cell range list > tag implies relative cell references in the list values which is not allowed."
I am using Excel 2003, SP3.
Any suggestions will be much appreciated.

Hi there,

Does anyone know if it is possible to publish an Excel report with Pivot Tables as an interactive webpage? I have done so by saving as web page but it is not interactive.

My pivot table allows users to expand and collapse the rows and when I saved it as web page, the + sign is no longer there.

Have tried Google but it doesn't seem to be returning anything relevant.

Has anyone attempted this before? It would be great if anyone can provide me with some suggestions.

I am running on Excel 2010 by the way.

Thanks in advance.

I'm looking for a way to publish an interactive (and macro-enabled/protected) worksheet to a web page - preferably on my own site.
Its a one off from a home user so sharepoint isnt really an option and the commercial companies (spreadsheetweb/kdcalc etc) also seem pretty expensive for a single use (or very occasional) and also dont offer support for all the features in Excel 2007 at the basic levels either.

Sharing services like Googledocs or Zoho also dont support features such as macros.

I'm sure there must be a way but i've been searching around for a few hours now and have pretty much run into a wall !

Cheers
Steve

Hi,

I'm trying this for the 1st time. I can publish a workbook interactively and a pivot table staticly but cannot publish a pivot table as an interactive web page. When I do this I see the PT structure but no data and it says THE QUERY COULD NOT BE PROCESSED. I have researched extensively and cannot find out why this does not work. I'm running Win7 and IE9. I did change the security settings in IE9 to enable data sources since I tried this 1st with a SQL Server back end but it does not work with even a regular pivot table.

Thanks in advance for any help!
Howard

I have built my first simple VBA app and linked it to a command button in one of my worksheets. The app brings up a dialog box that moves around some cell ranges according to user input.
Well, I tried to publish the entire Excel workbook to a web page.
Only the data appears on the web page.
I would want to publish the page together with the command buttons and my VBA app.
Is this possible ?
Any help is appreciated.

Hi,

Is it possible to display and use items such as buttons and comboboxes on an excel workbook saved as an interactive web page.

Linked to this...is it possible to run macros when saved as a web page?

If it is possible how do I make objects appear and work as I can't seem to get them to even display.

Cheers

Andy

How do I create a hyperlink to a web page in Excel?

I click on Insert/Hyperlink. Click the on the "Browse the Web" button and
slect a web site. After creating the hyperlink, I am unable to open the
hyperlink. I get a error message box saying, "Unable to open. Unable to
locate Internet server or Proxy server".

Hello!
I've been searching the web for nearly a week now trying to figure out how
to read the information a user can enter into an interactive web excel
spreadsheet.

More precisely, I need for a user to enter an unlimited amount of numbers
and I need to be able to read the numbers and enter them into a database (SQL
Server). To protect from user errors, my team thought it might be a good idea
to provide the Excel Spreadsheet in a web page and users can just paste the
information directly into it, and then click a button to upload the
information to our database.

I have found that Javascript can read the variables entered into the Excel
Spreadsheet, but I cannot find how to code directly into the VB.NET (2003)
environment. I would prefer NOT to use Javascript if possible.

If someone could point me in the right direction so that I can find
information that is already available on the web, or if someone could share
an example of how to do this, it would be greatly appreciated.

Thanks!
Kris

Self-taught Excel VBA noob here.
I have scowered the internet far and wide to get to the point I'm at right now - which is stuck.

Through VBA I can launch Internet Explorer, load a web site, enter my search string into a field on the screen, click the web site's "Submit" button, and post the data of the resultant data table into an Excel Worksheet using a Web Query.

Now I need to select the next page on the web site and have been unable to do so.
Here's the web site: http://www.bcad.org/clientdb/?cid=1
Enter the first two letters of your last name in the search field and hit enter.
A page will load with the results. At the bottom right of the screen you'll see the hyperlinks to the other pages of the table. What is the code in VB to select those pages?

I've tried this, and it doesn't work:
URL = "http://www.bcad.org/clientdb/SearchResults.aspx?rtype=address&page" & cycle & " "
IntExplApp.Navigate URL
Do While IntExplApp.Busy
Loop

Also, if there's an easier way of collecting the table data than a web query I would love to know.

Thanks in advance!
Chris

How do I create a hyperlink to a web page in Excel?

I click on Insert/Hyperlink. Click the on the "Browse the Web" button and
slect a web site. After creating the hyperlink, I am unable to open the
hyperlink. I get a error message box saying, "Unable to open. Unable to
locate Internet server or Proxy server".

How to convert a muliple page worksheet to a single page worksheet?

Thanks,

Tom

I have Excel and Adobe Acrobat Professional installed on my computer. Is there a way to create a macro that when activated will convert each worksheet in my excel file to a separate pdf file?

I am using Excel 2007.

I want to convert an Excel spreadsheet to a static one page HTML page that is:Using standard embedded HTML format (not referring to a CSS style sheet)Not using Microsoft styles.Not breaking up spreadsheet into multiple files or using folders.
Can this be performed by Excel 2007? Or is there another tool anybody can recommend?

When I use Excel 2007 Save As: Web Page *.htm, *.html Spreadsheet, it breaks up the spreadsheet into multiple files and uses a Microsoft-based styles.

Hi,

I'm trying to create an Excel spreadsheet. This should have a button
and when this button is clicked, it should take the data in some of the
cells and post them to a web page (using the HTTP POST method rather
than GET).

This web page does some processing on the server and returns some HTML.
I'd like to get this and put it into a string, so I can parse this and
update other cells in my worksheet.

Is this possible in Excel 2002?

Thanks,

Richard

Is there a simple way to convert a multiple worksheet (with different format
pages) to a single page worksheet with all different pages appended together?

Hi everyone, I'm trying to save my worksheet as a web page but I have a question. When I save the whole workbook, excel will create a web page with the tabs at the bottom to flip through the other sheets, this feature I don't want. I tried creating just a single sheet as a web page, but what excel will do then is center my data, which I also don't want (I want it all to be on the left hand side of the page.) Any suggestions what I can do?

Hi,
I am hoping someone can help me with a macro for converting excel worksheets to a PDF, saving and attaching it to an email. If cell A8 is empty the worksheet is to be skipped, the sheets where A8 is occupied i want them converted into one pdf file, saved and attached to an email. I have Excel 2003 and Adobe Professional 6.

Can someone please help?

Thanks
dawn

Hello,
I need to change the size of the spreadsheet once it is published as a web
page- It only fills half the page. Is there a way to change the size that it
is full screen? or 75% -

Thanks

Hi,

I was wondering if it is possible to use data validation (drop down
boxes) when you publish the Excel spreadsheet to a web page?

--
Chikita
------------------------------------------------------------------------
Chikita's Profile: http://www.excelforum.com/member.php...o&userid=24111
View this thread: http://www.excelforum.com/showthread...hreadid=377158