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

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » visual+basic+for+excel+courses+london - Excel online connection

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

resolvedResolved · Low Priority · Version Standard

Darren has attended:
No courses

Excel online connection

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?

RE: Excel online connection

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


Server loaded in 0.09 secs.