vkrisz81 Posted September 12, 2022 Share Posted September 12, 2022 hello , i have another issue on handling cells. i have a password protected file to cover and def function and calculator cells, its ok. i have a cell where i must type a date. IF i place it manually, "2022.09.13" function says ok if i type it by autoit as sheets().cells()="2022.09.13" it says error i read the value when its ok, says value is "20220913000000". once i met with this when i used vba codes.. BUT if i write to cell this "20220913000000" excel says error, do i have to break password protection to find out which cellformatting is applied? or how can i solve it? thank you Link to comment Share on other sites More sharing options...
vkrisz81 Posted September 12, 2022 Author Share Posted September 12, 2022 (edited) i can see now, after breaking protection, cell format is a special, star sign marked date format .. but i dont know how to fix this bug.. i can see, the data wich are compared to this field are "8.8.22" and "23.8.22" which are date format by excel. if i type by program 22.8.22 does not accept, but if i type an enter on field it ok. .. Edited September 12, 2022 by vkrisz81 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now