?
Solved

EXCEL VISUAL BASIC

Posted on 2007-03-23
1
Medium Priority
?
144 Views
Last Modified: 2010-04-30
Hello,

Could someone provide me with code on how to open an excel file without the message asking whether I want to enable macros appearing? Please note that I want to keep macro security as a medium level.

Thanks.
0
Comment
Question by:f19l
1 Comment
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 1500 total points
ID: 18780851
You can open the workbook inquiry only:

   ExcelApplication.Workbooks.Open Filename:=FilePathName, UpdateLinks:=0, ReadOnly:=True

You can also try disabling alerts:

   ExcelApplication.DisplayAlerts = False
   ExcelApplication.Workbooks.Open Filename:=FilePathName, UpdateLinks:=0

Kevin
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Suggested Courses
Course of the Month16 days, 16 hours left to enroll

864 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