Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open workbook
my macros work ok now but when i add the line to open the workbook - i does so successfully but then stops and doesn't run through the othe macros i have called. Sub xxx() Workbooks.Open Filename:= _ "C:\Documents and Settings\person x\Desktop\Database.xls" MatchData ExtractUniqueEngCodes CopyPasteUnique End Sub i also would like to automatically accept the "enable macros" dialogu box which comes up. is there any way of doing this? cheer -- rbekka3 ----------------------------------------------------------------------- rbekka33's Profile: http://www.excelforum.com/member.php...fo&userid=1403 View this thread: http://www.excelforum.com/showthread.php?threadid=26307 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open workbook
One Possibility.
How do you run your xxx macro? Do you use a shortcut key that has a shift as part of the combination? If so, use a shortcut key combination that doesn't include a shift. -- Regards, Tom Ogilvy "rbekka33" wrote in message ... my macros work ok now but when i add the line to open the workbook - it does so successfully but then stops and doesn't run through the other macros i have called. Sub xxx() Workbooks.Open Filename:= _ "C:\Documents and Settings\person x\Desktop\Database.xls" MatchData ExtractUniqueEngCodes CopyPasteUnique End Sub i also would like to automatically accept the "enable macros" dialogue box which comes up. is there any way of doing this? cheers -- rbekka33 ------------------------------------------------------------------------ rbekka33's Profile: http://www.excelforum.com/member.php...o&userid=14033 View this thread: http://www.excelforum.com/showthread...hreadid=263073 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) |