VBA code to open URL

[mckaya100]

Hi,

I need VBA code that will open a URL site when someone opens the Workbook.
I want to be able to track who uses the work book.

e.g.

When the user opens the workbook, It triggers the url site.
The site will then record user details (unknown to the user)

I will be using this information to analyse the way my reports are being used.

I have found code for button commands but this is not the same.

Has anyone been able to do this or something similar?

Thanks,

Adam

 

[Ruddles]

I find the most simple is

    shell "explorer.exe URL"

But then as far as I'm aware you can't really do much with it, like sending a logonid and password, navigating to a specific page, taking content from the page, etc.

 

[Ruddles]

I was able to get a basic counter working using another example from your forum:
:
.Navigate "http://myurl.com/cgi-bin/excelcounter/excel.pl"
:
However it would be great to pass more variables back to the PERL Script.
/QUOTE]

I don't speak PERL but can you not inject values into the variables in the script as follows:-

     .Navigate "http://myurl.com/cgi-bin/excelcounter/excel.pl[COLOR=rgb(184, 49, 47)][B]?[/B][/COLOR][B][COLOR=rgb(41, 105, 176)]name=fred[/COLOR][COLOR=rgb(184, 49, 47)]&[/COLOR][/B][COLOR=rgb(41, 105, 176)][B]age=21[/B][/COLOR]"

 

[avitzavi]

I use this code for URLs:

ThisWorkbook.FollowHyperlink "https://google.com"