Can workbooks be consolidated in Sharepoint using VBA?

[PurpleMilk]

Today, I have a macro that consolidates workbooks in a LAN folder. The
macro runs in any folder and assumes all the files within the same folder as
the macro will be consolidated NOTE: Only worksheets with a specific name
are consolidated.

Currently the macro uses ChDrive and ChDir for the path, and uses DIR to
pull file name.

I'm new to Sharepoint and these documents may be moving to a Sharepoint
library and I would like to know if it's possible to be able to do similar
type consolidation of workbooks in Sharepoint (not using lists). Either
somehow being able to revise the macro or using some other method?

Any ideas?

 

[JLGWhiz]

I have not used Sharepoint but I would assume that what can be done on one
server can be done on another, so long as you have the permissions.

 

[Barb Reinhardt]

I believe what you want to do can be done by mapping the SharePoint drive.
You need to include everything but the last part of the URL for your main
site or subsite when you map it. Include the site name, but not the view.
THEN, you'll need to make sure that your WebClient service is running. Most
often when my mapping isn't working, it's because of the WebClient.

 

[Barb Reinhardt]

I'm the admin to all of the sites that I've mapped. But if you can't see
them, it's kinda difficult to get the URL. If there are subsites that I
don't have access to, they are never seen in the mapping.

 

[PurpleMilk]

Ok, great, thanks! I'm the one developing the sharepoint site so it should
work for me.