Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Open Linked Excel File Without Link Message

Posted on 2013-01-25
3
Medium Priority
?
376 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 49

Accepted Solution

by:
Dale Fye earned 2000 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 49

Expert Comment

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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

571 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