Thread: Accessing an Excel file which has macros
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jamesp@premiercs.co.uk is offline
external usenet poster
  
Posts: 16
Default Accessing an Excel file which has macros
Spot on Charlie

Many thanks

James

"Charlie" wrote:


Hi,

Try to put these lines at the beginning and end of your code:

Application.DisplayAlerts = False

Your code to open other file....

Application.DisplayAlerts = true

Charlie
'Opener Consulting Home' (http://www.openerconsulting.com)


;180058 Wrote:
I have written some code which opens another file which has macros and
extracts data. I don't need to run any macros in this other file. Is
there
a way of turning off the button to run macros when the other file opens
up?
Also I'm doing this in 2003 at the mo but is there any difference with
2007?

Many thanks

James


--
Charlie
------------------------------------------------------------------------
Charlie's Profile: http://www.thecodecage.com/forumz/member.php?userid=89
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49795


Reply With QuoteReply With Quote