Numbers from the ether

"The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel.

The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option. The system extracts data by learning from a user’s selection of data they wish to capture into Excel. The more selections, the more the system is trained."

Labels: Addins, General, Internet, Reference, Shortcuts, Tips, Tutorials

Auto Republish

1. Click Save As Web page from the File menu. (click the Office logo in 2007+)
   
   
2. In the Save As dialog box, click the Publish button. (click Publish, Create Document Workspace in 2007+)
   
   
3. Use the drop down arrow beside Choose to select what you want to publish.
   
   
4. In the File name field, enter a file name.
   
   
5. Place a check beside Auto Republish every time this worksheet is saved. This way the data will be updated each time you make changes to the worksheet.
   
   
6. Select Open published page in Web browser to view the data in your Web browser after you click Publish.
   
   
7. Click Publish.

Labels: General, Internet, Reference, Tips, Tutorials

Transfer data

Some simple guidance of how to transfer data from Excel or Access into HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL files on web pages in order to quickly share your data with others.

Labels: General, Internet, Reference, Tips, Tutorials

Outlook, Excel, and VBA

• Mail Workbook
• Mail one Sheet
• Mail more than one Sheet
• Mail the Selection or range
• Mail Every Worksheet with Address in cell A1
• Mail sheet or sheets to one or more people
• Mail range or sheet in the body of the mail (Send personalized email)
• Mail a message to each person in a range with Outlook
• Mail a message to each person in a range with CDO (no security warnings)
• Sending a different file to each person in a range with Outlook
• Zip the ActiveWorkbook and mail it with Outlook
• Security (Prevent displaying the dialog to Send or not Send)

Labels: General, Internet, Reference, Tips, Tutorials, VBA

Do You Question the Web?

"Generally, though, people tend to overlook the option of using the Web as a data source for Excel, be that source the Internet, an intranet, an extranet, or a Web Service. But they shouldn't. Web queries are an easy, yet remarkably flexible and predictable way of bringing data into Microsoft Excel from anywhere on the Web. You can point a Web query at any HTML document that resides on any Web server - or even on a file server, for that matter - and pull part or all of the contents back into your spreadsheet...When you start using Excel's Web queries, you will realize they are almost as limitless as the Web is.

Labels: General, Internet, Reference, Tips, Tutorials