thisWorkbook.Save going to TMP file RRS feed

  • Question

  • 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
    End If

    Monday, April 30, 2012 12:42 PM

All replies