-
thisWorkbook.Save going to TMP file
Hi guys,
When executing thisWorkbook.Save, it is saving the TMP file which excel creates, and not saving the actual workbook.
The command is executed behind ThisWorkbook Code (under Microsoft Excel Objects).
There is a user form being used to update data on the workbook (based on what user inputs to the form), then then click Save. But it is not saving the actual workbook, only saves temp file (CVT300 -- found under C:\Documents and Settings\<USER_ID>\Local Settings\Temp). This mean when another user opens the form, they do not see the changes made by previous user. Any advice on how to correct this?
If Cells(7, 1) = 1 Then
ThisWorkbook.Save
End If
Thanks,
FIXXXER
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules