I have built a large workbook with dozens of macros that is accessed and used by several users internationally.

I'm interested in getting some useage statistics for this 'program.' Just getting into more complex VBA code writing, I have the following code launched when the workbook is opened:

Dim computerName As String
Dim userName As String
computerName = Environ$("computername")
userName = Environ$("username")

Can anyone educate me on how I can take this information (computer name and user name) and FTP it to my web server with a date/time stamp so I can see who and how often these workbooks are opened?

Thanks in advance for any and all help!

It would be better to save this in a Temporary file and load it to FTP.

On the other hand you can open an Excel file in your webserver, update and close it.

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

I need to be able to process this information completely behind the scenes without any user involvement. The macros utilize another application's API and therefore cannot be ran directly from the web server.

Is it possible to post the vales of userName and computerName in a new file and have it upload via FTP without the user being prompted?

Thank you again for your help. I'm sure there is a way to do this, I'm just hoping someone here can help/show me. :)

-DM

Bump

Does anyone know how to do this?

You can use Environ to get the USername and Computer name (http://vbadud.blogspot.com/2007/05/e...using-vba.html)

Please have a look at http://www.ozgrid.com/forum/showthread.php?t=47625 for FTP

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)