Our company is deploying Sharepoint with the expectation that virtually all files are stored within. Prior to its deployment, we would run a VBA macro in Excel to pull data from ~100 other 'source' Excel files. Now that we're migrating to Sharepoint the question is, is there a way to do something similar when all of the source files are stored within Sharepoint? May be a dumb question, but I'm new to Sharepoint and need to get a feel for what kind of challenge this will be.
We use Sharepoint here, and I access Excel files quite often, either opening or replacing them. Assuming you have access rights to the site, you shouldn't have any problem. Here're the codes I use most often:
To open from Sharepoint:To Save to Sharepoint:
Please Login or Register to view this content.The code you used previously should still work, you'll just have to change the location information.Please Login or Register to view this content.
I hope this helps.
John
Last edited by jomili; 11-08-2011 at 03:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks