473,378 Members | 1,462 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Identifying users in Excel VBA

2
I am building an excel file which I want to be used by up to 5 people, but which I do not want them to share <Tools><Share Workbook.> The reason for this is that I need to log each action with a unique identifier, which would not be possible if two people opened a shared workbook at the same time.

I have written an auto_open routine which will alert the user that they have not got the file read write, because another user is in it, and will then auto_close the file.

I would like to be able to show the second user, the log on id of the person who does have the file read write, presumably using some sort of environ("username") function. Does anyone know whether this is possible?

Thanks for your help.

EBG
Jul 25 '06 #1
0 1617

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: David | last post by:
I know that identifying the user IP address with HTTP_SERVER_VARS; is reliant on the browser agent but I have stumpled upon the following code which I have tried to understand but failed! ...
1
by: hokiegal99 | last post by:
This is not really a Python-centric question, however, I am using Python to solve this problem (as of now) so I thought it appropiate to pose the question here. I have some functions that search...
1
by: Marilyn Chalmers | last post by:
I am a newbie at HTML and web authoring and have a problem I cannot figure out. If I provide a link like this in my page and the user clicks on the link the document file is downloaded and...
1
by: Jason | last post by:
I want to perform a date calculation. For example: a 1 date 2 2004-01-04 3 2004-01-11 4 2004-01-18 ....and so on. I'll continually add things to this column and the goal of the...
2
by: Jim Lacenski | last post by:
I have a VB class that uses .NET and ADODB to write into an Excel spreadsheet (via Jet) on a server as part of a web application. ADODB is used instead of ADO.NET because it greatly simplifies the...
4
by: __Stephen | last post by:
Sorry about the cross-post. "Life would be so much easier it we didn't have end users" :) I have an ASP.NET app that delivers a cross tab report to our Accounting Department. CFO just demanded...
1
by: martin DH | last post by:
Hello, I've hit a mental roadblock and could use some design ideas if anyone is willing. Access 2003, Windows XP Pro In my database is a form (HOME) that is filled with command buttons that run...
12
by: Kevin Walzer | last post by:
I'm trying to learn C. I have a fairly extensive background with C-based scripting languages (Python,Tcl, others), so a great deal of C is proving easy to pick up (control structures, functions,...
3
by: evenlater | last post by:
I have an Access application on a terminal server. Sometimes my users need to export reports to pdf, rtf or xls files and save them to their own client device hard drives. They can do that right...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.