Solved

Open Linked Excel File Without Link Message

Posted on 2013-01-25
3
356 Views
Last Modified: 2013-01-29
I am using Access to open an Excel workbook that has links in it. Is there something I can add to the "objExcel.Workbooks.Open modGlobal.g_strTemplate" code so that the Excel does not launch the "This workbook contains links" message?

Thanks.
0
Comment
Question by:Buck_Beasom
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 38818443
Try this

objExcel.Workbooks.Open Filename:="C:\Workbook.xls", UpdateLinks:=False
0
 

Author Closing Comment

by:Buck_Beasom
ID: 38832039
Outstanding! Thanks.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38832221
Glad to help.  BTW, if you need to update the links, set it to true.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now