Hello,
using sheet with some informations.
There are some columns with text and one column with datetime (VBA). That column has this:
VBA code:
Please Login or Register to view this content.
In desktop app it works fine. Problem is if I have this document in onedrive/sharepoint because there is word "NAME?" instead of datetime.Please Login or Register to view this content.
Can anybody help me how to fix that please?Please Login or Register to view this content.
Thank you.
Last edited by AliGW; 02-28-2024 at 03:25 AM. Reason: Thread title improved.
VBA does not work in the browser environment.
Try a formula, e.g
=TEXT(NOW(), "dd.mm.yyyy hh:mm:ss")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello AliGW,
thank you for your response. Tried to add =TEXT(NOW(), "dd.mm.yyyy hh:mm:ss") instead of =EntryTime(A1) but it shows me there is an error in that.
Works here. Attach a sample workbook.
Where is SK? That's not much use to us. Are you in Europe? Maybe you need this:
=TEXT(NOW(); "dd.mm.yyyy hh:mm:ss")
=TEXT(NOW(); "dd.mm.yyyy hh:mm:ss")
this works without error. But I need to show datetime after text entry in first column.
So every row will have different datetime.
For example, if I add some text in A1, B1 will have datetime. If I add another text in A2, B2 will have different time.
SK is slovakia
See if this will work for you: https://www.easyexcelanswers.com/timest.html
https://support.microsoft.com/en-gb/...7-1b49cd50d123
Please change SK to Slovakia in your profile. Thanks.
It works fine in Desktop. datetime shows without problem. In onedrive cells with datetime are blank without errors.
=IF(A110<>"";IF(E110="";NOW();E110); "")
OK - in that case, you are going to need to look into Office Scripts, if it's available to you. I cannot help you with that, I am afraid.
https://learn.microsoft.com/en-us/ja...office-scripts
I've amended your thread title. Good luck!
understand, thank you.
Maybe there is any way to force users to open url link with xlsm in desktop app?
I don't think so - you'd need to instruct them how to do that themselves (not foolproof, as I know from my own experience).
You could have a look here: https://sharepointmaven.com/how-to-d...-and-onedrive/
ok thank you for all.
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, remember that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks