cchristner
09-05-2016, 07:53 PM
Hey guys,
I was wondering if anyone would be able to help me out. I need a code that will save a copy of an Excel file as a part number that is in the B1 field. With a date stamp and make the copy read only. I was wondering if anyone had any idea's. Basically I want to be able to look back at the data and I will need to know the part number which changes. But the part number is located in the file B1. Than I want to know the date and time it was saved. I also want to view the data at a later date without the option for operators to change the information. An example of the format would be Part_yyyy_mm_dd hh. If anyone could help i would really appreciate it.
I was wondering if anyone would be able to help me out. I need a code that will save a copy of an Excel file as a part number that is in the B1 field. With a date stamp and make the copy read only. I was wondering if anyone had any idea's. Basically I want to be able to look back at the data and I will need to know the part number which changes. But the part number is located in the file B1. Than I want to know the date and time it was saved. I also want to view the data at a later date without the option for operators to change the information. An example of the format would be Part_yyyy_mm_dd hh. If anyone could help i would really appreciate it.