| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing an Excel file which has macros
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing an Excel file which has macros
On Jan 13, 10:33*am,
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? * Which button are you referring to? Is this a button that you have placed in a sheet, or the menu item under Tools and it's counterpart in the Toolbar. If it's the later, your best bet is to simply remove the Macro Toolbar from the machines where this might be run. Maury |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing an Excel file which has macros
It comes up when you try to open the file and before it opens you get the
'Security warning' dialog box with 'Macros may contain viruses...' and then the user has to click on either the 'Disable macros' or 'Enable Macros' button to open. Programically, i don't want to see this dialog box. Does this make sense? Thanks James "Maury Markowitz" wrote: On Jan 13, 10:33 am, 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? Which button are you referring to? Is this a button that you have placed in a sheet, or the menu item under Tools and it's counterpart in the Toolbar. If it's the later, your best bet is to simply remove the Macro Toolbar from the machines where this might be run. Maury |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing an Excel file which has macros
Button? What and where is this macro and what kind of button. -- Don Guillett Microsoft MVP Excel SalesAid Software " wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing an Excel file which has macros
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing an Excel file which has macros
You could use this line of code but you need to be more specific on what button where. Code: -------------------- Application.EnableEvents = False -------------------- you would have to tie it in with an IF statement so it will only be used on a certain sheet or workbook!, don't forget to turn it back on ;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 -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49795 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing an Excel file which has macros
A bit picky but I like where you're coming from :-)
"Simon Lloyd" wrote: You could use this line of code but you need to be more specific on what button where. Code: -------------------- Application.EnableEvents = False -------------------- you would have to tie it in with an IF statement so it will only be used on a certain sheet or workbook!, don't forget to turn it back on ;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 -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49795 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing an Excel file which has macros
It wasn't meant to be picky, sorry it seemed that way! ;180310 Wrote: A bit picky but I like where you're coming from :-) "Simon Lloyd" wrote: You could use this line of code but you need to be more specific on what button where. Code: -------------------- Application.EnableEvents = False -------------------- you would have to tie it in with an IF statement so it will only be used on a certain sheet or workbook!, don't forget to turn it back on ;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 -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'Accessing an Excel file which has macros - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=49795) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49795 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accessing Excel 2007 Userforms from Macros | Excel Programming | |||
| Problem accessing an Excel file from ADO | Excel Programming | |||
| Accessing Excel Macros from VB.Net | Excel Programming | |||
| accessing word file from an excel file | Excel Programming | |||
| accessing .mpp file using excel VBA macros | Excel Programming | |||
Hybrid Mode
