Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I can't remember where I found this, so I am not able to give proper credit. My apologies. Anyway, this is the code that I am using and it works for me with spreadsheets in SharePoint in the cloud.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("Metrics").Range("O1").Value = Now End Sub In the cell where I want the date and time to show, I put =Now() You may need to put the name of your spreadsheet where "Metrics" is. I must confess that I do not know why or how it works for me, only that it does. |
#2
![]() |
|||
|
|||
![]()
Bui cả chồng :v. về ăn Gọi trưa xong đấy. kêu Gam Bùi Nguyen chỗ gọi Thu Đang Gấu Tâm chị vợ M*p Jessica đ*p phá đi em nay Nguyen gặp Huyen Mới
Bao Hiem Nhan Tho Daiichi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Network path in cell | Excel Programming | |||
Path to a network drive | Excel Discussion (Misc queries) | |||
Why doesn't Save as work over the network? | Excel Discussion (Misc queries) | |||
Saving to a Network Path using VBA | Excel Programming | |||
Network Path | Excel Programming |