visual+basic+for+excel+courses+london - Excel online connection

Resolved · Low Priority · Version Standard

Excel online connection

Darren has attended:
No courses

by - delegate Darren [1 post] (2007 Oct 10 Wed, 12:52) Reply

Is is possible to connect a websites visitor hit counter to an online excel document, therefore showing a graph of how mnay customers are coming to the site monthly?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel online connection

by - trainer Rich platinum contributer [744 posts] (2007 Oct 17 Wed, 10:14) Reply

Darren,

You can store hits to a text file, then import that textual data into Excel. This is easier because it is plain text you are storing (numbers, csv). An Excel file is binary and much more complicated to put together.

This page shows you how to store hits into a text file using ASP:
http://www.freevbcode.com/ShowCode.Asp?ID=359

This page shows you the same using PHP:
http://www.totallyphp.co.uk/scripts/text_file_hit_counter.htm

You'll need to have ASP or PHP installed on your server (if you're unsure, ask your hosting provider). You can also use Perl or any other CGI script, which you'll find plenty when doing a web search.

However, you'd be best to use something like Google Analytics to get data on your visitors. It's just a small bit of javascript code you add to your template or every page on your web site. Much easier - and they do all the graphs for you.

Regards, Rich

· Excel and Inventory Management
· How to Create Better Excel Spreadsheets: Part One
· Prepare for your MOS Certification with MS Excel Courses
· VBA Excel 2007
· Tools From Advanced Excel Courses: Goal Seek and Solver

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Rate this page: