trainwater
New Member
- Joined
- Jan 25, 2016
- Messages
- 4
Ok, I have a scenario that I have searched and searched on and have not been able to come up with a good solution. I'm really hoping someone here can help me.
I have two items, a macro-enabled excel workbook and a sharepoint site survey. What I want to be able to do is...
1. Create a button in the workbook to launch a VBA macro
2. Have the VBA macro navigate to the Sharepoint survey page in IE.
3. Open the Sharepoint Survey.
4. Pass data from 5 named cells within the workbook to 5 of the questions within the Sharepoint site.
5. End the macro.
6. Allow the user to finish the survey manually.
I know it's a lot, but I'm hoping there is a way to get this done. If anyone could help point me in the right direction I would be very grateful.
I have two items, a macro-enabled excel workbook and a sharepoint site survey. What I want to be able to do is...
1. Create a button in the workbook to launch a VBA macro
2. Have the VBA macro navigate to the Sharepoint survey page in IE.
3. Open the Sharepoint Survey.
4. Pass data from 5 named cells within the workbook to 5 of the questions within the Sharepoint site.
5. End the macro.
6. Allow the user to finish the survey manually.
I know it's a lot, but I'm hoping there is a way to get this done. If anyone could help point me in the right direction I would be very grateful.
