Solved

EXCEL VISUAL BASIC

Posted on 2007-03-23
1
136 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 500 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

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Determine Range to Select 5 48
Copy Files - Python 7 83
vb6 connector to SQL Server 2 37
Copy a row 12 61
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
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…
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

770 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