Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro opens file and hangs in VB editor
Hi, I am running a series of macros to open files filter data, cut and paste
data into other spreadsheets and format the data. I had listed the macros to run within a controling macro which was working ok but now when it opens a file it opens the VB editor at the worksheet object, which is blank, and stops the macro. Is there a command "on exit got to macro2"? Sub OpenandsaveasXL() ' delete_15_data ' Open_today_Report15 Report_15_Filter Copy_to_Sheet2 ' Open_today_Report17B ' Report_17B_remove_top_rows ' Open_today_Report10 ' Report_10_remove_top_rows End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
VBE Editor opens automatically when I run a macro | Excel Programming | |||
open of xls fil on FTP server hangs and never opens | Excel Discussion (Misc queries) | |||
Macro now opens up VBA editor - not intended | Excel Programming | |||
VBA editor hangs when changing font | Excel Programming |