I'm wanting to copy some additional entries into a table in a closed workbook from a userform.
I can't see how it would work, but before I start coding to retrieve and open workbooks, is it possible to update without the destination workbook being opened?
The destination workbook will be held on a SharePoint site on our intranet.
Thanks in advance.
I believe you can retrieve data from a closed workbook, but you can't add data to a closed workbook.
I remember trying to open a workbook from SharePoint server. I believe I had to map it on my computer 1st.
Use Getobject() method which will open the workbook in invisible mode
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sweet - GetObject does the trick for local content.
However....
The workbook I need to update is on a sharepoint server - as davesexcel eludes to, this changes the game slightly.
works perfectly.
Please Login or Register to view this content.
I can retrieve, open and update from SharePoint, however I would like to do this silently but the URL throws up an error and changing the slashes URL backslashes to forward ones hits an error with the HTTP: part.
Any ideas or should this be a whole new post?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks