VBA -- file permissions

Reply

Join Date: Jun 2009
Posts: 3
Reputation: archangel1177 is an unknown quantity at this point 
Solved Threads: 0
archangel1177 archangel1177 is offline Offline
Newbie Poster

VBA -- file permissions

 
0
  #1
Jun 17th, 2009
Okay so I am new to programming but I have a very basic knowledge of some things. I have been working with vba and I need to write a macro for a word document that only allows the people that are allowed into it to view it and I havent the foggiest idea on how to do that. Does anyone have any ideas or possibly a saved macro that they have used in the past that I might be able to use?
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 134
Reputation: HITMANOF44th is an unknown quantity at this point 
Solved Threads: 19
HITMANOF44th HITMANOF44th is offline Offline
Junior Poster

Re: New guy here!

 
0
  #2
Jun 17th, 2009
cant you just password protect the file ?
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 134
Reputation: HITMANOF44th is an unknown quantity at this point 
Solved Threads: 19
HITMANOF44th HITMANOF44th is offline Offline
Junior Poster

Re: New guy here!

 
0
  #3
Jun 17th, 2009
because i know in word you can set passwords for files so only if you know the password you can view edit that file
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 3
Reputation: archangel1177 is an unknown quantity at this point 
Solved Threads: 0
archangel1177 archangel1177 is offline Offline
Newbie Poster

Re: New guy here!

 
0
  #4
Jun 18th, 2009
Sure I could do that, But what I am looking for is to make it to where there are logins for the few people that are going to be able to view it. What I have it a document that has a rotating list of passwords for the production machinery that needs to be kept out of public access, but needs to be on the company network so that all of the people involved can get to it.
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 234
Reputation: Kraai is an unknown quantity at this point 
Solved Threads: 16
Kraai's Avatar
Kraai Kraai is offline Offline
Posting Whiz in Training

Re: New guy here!

 
0
  #5
Jun 18th, 2009
I agree, why not just create a folder on the network, chuck the word doc in the folder, and password protect the folder, and only those that know the password, will be able to access the folder.
I left my hotdog somewhere, If you find it, feed it please, or better feed yourself!!
Webhostig and ISP Solutions in ZA
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 3
Reputation: archangel1177 is an unknown quantity at this point 
Solved Threads: 0
archangel1177 archangel1177 is offline Offline
Newbie Poster

Re: New guy here!

 
0
  #6
Jun 18th, 2009
Yeah you guys are probably right. I think that i was trying to over think the situation. Thanks.
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 234
Reputation: Kraai is an unknown quantity at this point 
Solved Threads: 16
Kraai's Avatar
Kraai Kraai is offline Offline
Posting Whiz in Training

Re: New guy here!

 
0
  #7
Jun 18th, 2009
@archangel1177

Keep it simple, that is my motto when it comes to these things. However, I do not know anything about programming, and what you were trying to do, may still have an answer.
I left my hotdog somewhere, If you find it, feed it please, or better feed yourself!!
Webhostig and ISP Solutions in ZA
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC