Since the file is accessed by more than 1 person, it is advisable to change the Attributes of this file to READ ONLY. This way you do not need to write any separate code to keep track of Locking / Unlocking.
Every person who will open the file will get read only access to the...
This sound like you simply upgraded from XP to Win7... not a fresh install.
And this is common for the Files and Folders permissons to be reset.
Locate your folder where you wanted to save the file and re-take the Ownership of that folder by Right Click... Properties and then...
Welcome to Chandoo.Org Forums.
Is it possible for you to share the original excel workbook for us to look at. So that we are able to help with this query.
You will find information on how to post a file, on the top 3 sticky's on the forum home.
Do you have access to any kind of database such as Microsoft Access / SQL Server etc.
This task can be easily done using a SELECT QUERY and would be much faster as compared to the loop and also given the fact the number of records is very high.
Make use of the RecordSet Object here.
Instead of directly executing your SQL statement by calling Cn.Execute.
Open a RecordSet and pass the SQL as the Source.
Dim rs as New ADODB.RecordSet -If you can afford Early Binding
Dim rs as Adodb.RecordSet - If late binding...
There are a number of ways you could have created a dashboard.
1. You may show sales by SalesPerson and a comparison between them as well.
2. You may show sales by products, by month and by quarter.
3. You may show sales by Month and Year.
All this can be done using...
You can use the Internet Explorer library inside your VBA Project and then write code to do this.
Since we cannot access the site, cannot show you the steps.... but the general way to go is to use IE Object.
Hope this helps...
Yes, you can use the UNC names (fully qualified location link address) for the database name and it will work as long as the Network share is up and running and the end user has rights to read/write data from the folder.
If you are not sure of the complete link, open a...