mavicbenedicto
New Member
- Joined
- Jun 28, 2012
- Messages
- 1
Hi,
I am a newbie to VBA. I am creating a Macro that will help in checking-out and checking-in of files to a sharepoint. Here's how the program should go.
1. Open Microsoft Excel New Workbook.
2. List document filenames (*.doc) in Column A1 of the active worksheet
3. Let's say I have 10 documents listed in my spreadsheet. The macro would perform a loop into the list of filename and look into the sharepoint document library with columns Document Title, Document Num and Check Out To. There are thousand of documents in it.
4. The macro should check if it is existing and if it is available for check-out.
5. If the document was checked-out by anybody, the macro should be able to get the Check-out To (sharepoint User name) column and record it to the worksheet (e.g. B1)
6. If the document is available for check-out, the macro will check-out the document and download it to a specific folder.
7. The macro would save the spreadsheet as a report for document status.
I am able to distingush if the document is CanCheckOut. My big problem now is how can I get the value of Check-out To column from sharepoint to be able to write it on the spreadsheet for reporting purposes.
I would really appreciate if you could give me some help.
I am a newbie to VBA. I am creating a Macro that will help in checking-out and checking-in of files to a sharepoint. Here's how the program should go.
1. Open Microsoft Excel New Workbook.
2. List document filenames (*.doc) in Column A1 of the active worksheet
3. Let's say I have 10 documents listed in my spreadsheet. The macro would perform a loop into the list of filename and look into the sharepoint document library with columns Document Title, Document Num and Check Out To. There are thousand of documents in it.
4. The macro should check if it is existing and if it is available for check-out.
5. If the document was checked-out by anybody, the macro should be able to get the Check-out To (sharepoint User name) column and record it to the worksheet (e.g. B1)
6. If the document is available for check-out, the macro will check-out the document and download it to a specific folder.
7. The macro would save the spreadsheet as a report for document status.
I am able to distingush if the document is CanCheckOut. My big problem now is how can I get the value of Check-out To column from sharepoint to be able to write it on the spreadsheet for reporting purposes.
I would really appreciate if you could give me some help.
