I have an issue where I am saving a file with Custome properties to sharepoint.
Requirements:
1. Template open from the SharePoint site with a default name, user inputs the information in the XLS.
2. User clicks on Save button, or Clicks on cancel. If clicks on cancel, should be prompted to save.
3. the dialog box for save as, User is prompet with a new name (Based on the data entered).
4. user can change it or keep the name.
5. properties page from sharepoint is prompted and user can enter the value and then the file is saved to the Doclib.
What I have tried:
1. Override workbook_beforesave to set custom properties.
2. Tried Application.save function, but that saves the file directly with desired name and the properties box does not pop up.
3. When the user gets to the save after clicking the close option, the beforesave macro is not getting executed and the custom properties are not being set.
Desired outcome:
Ideally I would like to automatically close the document once it has been saved. I would lile to execute the beforesave routine from both place (clicked on save, as well as when coming to save during close)
I would like to get the properties box before the file has been actually saved to SharePoint site.
I am a complete newbee to Excl macro, and this is the fiest macro I am writing, i could paste the code that I have here if that would help.
Requirements:
1. Template open from the SharePoint site with a default name, user inputs the information in the XLS.
2. User clicks on Save button, or Clicks on cancel. If clicks on cancel, should be prompted to save.
3. the dialog box for save as, User is prompet with a new name (Based on the data entered).
4. user can change it or keep the name.
5. properties page from sharepoint is prompted and user can enter the value and then the file is saved to the Doclib.
What I have tried:
1. Override workbook_beforesave to set custom properties.
2. Tried Application.save function, but that saves the file directly with desired name and the properties box does not pop up.
3. When the user gets to the save after clicking the close option, the beforesave macro is not getting executed and the custom properties are not being set.
Desired outcome:
Ideally I would like to automatically close the document once it has been saved. I would lile to execute the beforesave routine from both place (clicked on save, as well as when coming to save during close)
I would like to get the properties box before the file has been actually saved to SharePoint site.
I am a complete newbee to Excl macro, and this is the fiest macro I am writing, i could paste the code that I have here if that would help.
