ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro opens file and hangs in VB editor (https://www.excelbanter.com/excel-programming/408304-macro-opens-file-hangs-vbulletin-editor.html)

davethewelder

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


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com