98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply Autosum with keyboard shortcutIf you press Alt and = at the same time, it applies autosum. |