WMatkovich
New Member
- Joined
- Apr 16, 2014
- Messages
- 5
I have a master file on share point that I want to suck data from some team files (also on SharePoint in the same location). I am using a Macro to pull the data and paste into the Master file. The Macro worked perfect on my PC but when I moved the files to SharePoint the code errors out.
In the Master file I have a cell with the Path to the folder that all Team files reside. I also have a list of Team File Names. I use
Sheets("Labels").Select
Path = Range("b2").Value
BenFile = Range("b3").Value
InterOpFile = Range("b4").Value
NMOCFile = Range("b5").Value
SECFile = Range("b6").Value
VistaAFile = Range("b7").Value
and
Workbooks.Open Filename:=Path & BenFile
to open the file and then do some other stuff with the data in the Team File.
How do i get this to work when the files are on SharePoint
In the Master file I have a cell with the Path to the folder that all Team files reside. I also have a list of Team File Names. I use
Sheets("Labels").Select
Path = Range("b2").Value
BenFile = Range("b3").Value
InterOpFile = Range("b4").Value
NMOCFile = Range("b5").Value
SECFile = Range("b6").Value
VistaAFile = Range("b7").Value
and
Workbooks.Open Filename:=Path & BenFile
to open the file and then do some other stuff with the data in the Team File.
How do i get this to work when the files are on SharePoint
