Help with Excel and Sharepoint
 

Hi,

I am a complete novice to VB and MS (MicroSoft)technologies so please bear
with me.

Here is the problem:

I have a parent folder called "Production". Under Production i have many
subfolders with each of the employee's name. Each folder will again have
Excell with the employees Name and each Excell has tabs respective to the
Dates.

The requirement is that i need to have an Excell that would have a macro.
When i run this macro, it would copy all the sheets from each Excell i
mentioned above.

I have an Excel sheet with me that has a Macro. The Macro merges the data
from all Excell Sheets under a Specified Folder and Sub-Folders into one
sheet.

For Example:
I have a Folder called "trial" under "C:\". It has many subfolders. Each
subfolder has an Excell sheet.


This way i save alot of time otherwise i will have to copy the data from
each tab manually and that would take alot of time, may be hours togather.

All was fine till my company decided to start storing the data on sharepoint
server.

Now i need the same functionality from Sharepoint. ie there will be number
of folders on share point. Each folder will have excell sheets under it. So
now, I need to modify my excell so that it connects to sharepoint, copies
data from each excell.

So I would appreciate it if anybody gives me a vb code snippet which can
help me do this.

Praveen

Help with Excel and Sharepoint
 

Because SharePoint are shared drives, you can just assign a mapped network
drive letter to the folder. For example, G: or H:
--
Gary''s Student - gsnu200785


"Praveen A P" wrote:

Hi,

I am a complete novice to VB and MS (MicroSoft)technologies so please bear
with me.

Here is the problem:

I have a parent folder called "Production". Under Production i have many
subfolders with each of the employee's name. Each folder will again have
Excell with the employees Name and each Excell has tabs respective to the
Dates.

The requirement is that i need to have an Excell that would have a macro.
When i run this macro, it would copy all the sheets from each Excell i
mentioned above.

I have an Excel sheet with me that has a Macro. The Macro merges the data
from all Excell Sheets under a Specified Folder and Sub-Folders into one
sheet.

For Example:
I have a Folder called "trial" under "C:\". It has many subfolders. Each
subfolder has an Excell sheet.


This way i save alot of time otherwise i will have to copy the data from
each tab manually and that would take alot of time, may be hours togather.

All was fine till my company decided to start storing the data on sharepoint
server.

Now i need the same functionality from Sharepoint. ie there will be number
of folders on share point. Each folder will have excell sheets under it. So
now, I need to modify my excell so that it connects to sharepoint, copies
data from each excell.

So I would appreciate it if anybody gives me a vb code snippet which can
help me do this.

Praveen

Help with Excel and Sharepoint
 

Thanks Gary,

So you mean to say, I can acess the data on sharepoint through shared
drives? Thanks for the quick reply.
You solved a major problem. I'll try this and post the result here.

THANKS AGAIN

Praveen

"Gary''s Student" wrote:

Because SharePoint are shared drives, you can just assign a mapped network
drive letter to the folder. For example, G: or H:
--
Gary''s Student - gsnu200785


"Praveen A P" wrote:

Hi,

I am a complete novice to VB and MS (MicroSoft)technologies so please bear
with me.

Here is the problem:

I have a parent folder called "Production". Under Production i have many
subfolders with each of the employee's name. Each folder will again have
Excell with the employees Name and each Excell has tabs respective to the
Dates.

The requirement is that i need to have an Excell that would have a macro.
When i run this macro, it would copy all the sheets from each Excell i
mentioned above.

I have an Excel sheet with me that has a Macro. The Macro merges the data
from all Excell Sheets under a Specified Folder and Sub-Folders into one
sheet.

For Example:
I have a Folder called "trial" under "C:\". It has many subfolders. Each
subfolder has an Excell sheet.


This way i save alot of time otherwise i will have to copy the data from
each tab manually and that would take alot of time, may be hours togather.

All was fine till my company decided to start storing the data on sharepoint
server.

Now i need the same functionality from Sharepoint. ie there will be number
of folders on share point. Each folder will have excell sheets under it. So
now, I need to modify my excell so that it connects to sharepoint, copies
data from each excell.

So I would appreciate it if anybody gives me a vb code snippet which can
help me do this.

Praveen