Whilst I'm trying to checkin the file into SharePoint using VB scripting, I'm being asked to manually select the Content Type (either document or Link to document). Can you please help how can I automate if using any command??
After setting
Set wb = workbooks.open("file.xlsx")
Wb.checkin
Please note once I choose the type of document it's successfully checking into SP, but have to do it manually all the time.
Many Thanks in Advance!
