How to copy data from an excel sheet to another excel sheet uploaded in sharepoint using VBA? -


i ask if it's possible copy or transfer data excel sheet worksheet uploaded in sharepoint without need of opening file sharepoint. done vba? you're prompt response appreciated. lot!

if have access sharepoint can use code: excel vba up-/download multiple sharepoint folders

in order open sharepoint folders network drive , access files using filesystemobject or dir on local hard disk.

i recommend method if you've enough drive letters available. 1 letter 1 folder. can connect root folder on sharepoint , browse subfolders in explorer.

i hope you. if have question, ask.


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -