![]() ![]() When I want the VBA update and export procedure to run, I change the name of the file to igger. Under normal operation, when the PC is waiting to be triggered but I don’t want to trigger it yet, a file named igger will be present in the _ Remote folder. I defined three file names (as VBA constants) for various triggers: Const REMOTE_TRIGGER_FILE_TRUE As String = "igger"Ĭonst REMOTE_TRIGGER_FILE_FALSE As String = "igger"Ĭonst REMOTE_TRIGGER_FILE_STOP As String = "igger" It is set to synchronize automatically, so any changes made on my laptop are reflected (nearly) instantly on my phone, and vice versa. ![]() This is where the newly created Google Drive folder is located on my computer. So FullPath returns: C:\Users\Jon Peltier\Google Drive\_ Remote\ On my computer, Environ("UserProfile") returns the directory of my Windows account: C:\Users\Jon Peltier #Vba ontime codeI put this folder name into a VBA constant at the top of my code module: Const REMOTE_DIRECTORY As String = "\Google Drive\_ Remote"Īnd I referenced this constant in the FullPath function: Public Function FullPath() As StringįullPath = Environ("UserProfile")
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |