Originally Posted by
CRLCHS
Pardon my lack of knowledge and code paste. I am in no way remotely familiar with any of this and am learning from the school of google so please bear with me and i appreciate any and all help.
The data is automatically imported via DDE from the data acquisition software to a saved workbook template. After batch production is complete and it is the end of the day, and the technician selects "stop recording" in the software, it is programmed to automatically "save as" the template with the date/time. After the "save as" copy is stored, the template is closed without saving changes to the template, thus returning it back to a blank template.
pt - i have tried to lock and password protect the cells, but if i remember correctly, the data was not able to be imported
Where is the Save As copied stored/saved to by the software? You could have macro or Excel addin that password protects all the files/workbooks within that folder.
You could possibly run something like this password protect all the files in a particular location.
Sub ProtectAll()
Dim wBk As Workbook
Dim sFileSpec As String
Dim sPathSpec As String
Dim sFoundFile As String
sPathSpec = "C:\MyPath\"
sFileSpec = "*.xls"
sFoundFile = Dir(sPathSpec & sFileSpec)
Do While sFoundFile <> ""
Set wBk = Workbooks.Open(sPathSpec & sFoundFile)
With wBk
Application.DisplayAlerts = False
wBk.SaveAs FileName:=.FullName, _
Password:="swordfish"
Application.DisplayAlerts = True
End With
Set wBk = Nothing
Workbooks(sFoundFile).Close False
sFoundFile = Dir
Loop
End Sub
Bookmarks