Solved

Opening One Excel Workbook from Another (Both on SharePoint) Using VBA

Posted on 2010-08-15
2
632 Views
Last Modified: 2012-08-14
I am updating VBA code to open an Excel file from another Excel file (same Excel templates containing same code except different content); both are located in SharePoint document libraries. The Excel workbook was created in 2003 with VBA code originally accessing files saved on network folders. Workbook was then saved in 2007 and is being updated to work accessing workbooks on SharePoint document libraries. Code is:


   Workbooks.Open strPath

where
strPath = "//server//......xslm"

The code actually opens the child workbook, but then triggers an error saying something like "procedure was interrupted unexpectedly". When you manually try to save/close the sheet it displays an "Out of Memory" pop-up. Code worked fine when using Excel 2003 and network folders on 2003 Office environment. Any help on how to correctly do this in Excel 2007/SharePoint would be greatly appreciated - thank you.
0
Comment
Question by:artemis1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
Emenizer earned 500 total points
ID: 33442270
0
 

Author Closing Comment

by:artemis1
ID: 33642831
It worked - thanks.
0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question