Excel File Attribute Testing for

DJP01S

New Member
Joined
Mar 21, 2002
Messages
1
I have a programming problem and I am
stuck on finding the solution. I wrote code to assign a sequential alpha/number to an Excel Worksheet, which functions as an IDI form used at work to upload journal entries into our general ledger system. The code
works fine as long as only one person at a time accesses the shared data file.
When two persons access the file at the same time I get the Exel error message box to open file as "ReadOnly".

What I need is a way to test the attribute of the file to determine if it is set
to "ReadOnly". Then I could use a "Do Until ... Loop statement to test for
this attribute value and have it close and reopen the file until the attribute
is False. I have used the help function, but could not find code that I could
use to solve this problem. Do you have any suggestions?

3/28/02
Mark,
Yes, I have tried Sharing the Workbook, however, this creates the problem of duplicate IDI numbers being assigned as multiple users are accessing the same file before the first user has update the file with the last number used. I need to find a way to control access to the file to ensure that only one user at a time can access the file.
_________________
DJPSHERWIN
This message was edited by DJP01S on 2002-03-28 11:23
This message was edited by DJP01S on 2002-03-28 11:31
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Have you considered Sharing (Tools | Share Workbook...) the workbook?
This message was edited by Mark W. on 2002-03-22 14:26
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top