Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro recorded... tabs & file names changed, macro hangs Steve Excel Worksheet Functions 3 October 30th 09 11:41 AM
VBE Editor opens automatically when I run a macro [email protected] Excel Programming 5 November 24th 06 01:21 AM
open of xls fil on FTP server hangs and never opens Ralph @ Randa Excel Discussion (Misc queries) 1 April 11th 06 08:13 PM
Macro now opens up VBA editor - not intended excelnut1954 Excel Programming 4 February 13th 06 05:39 PM
VBA editor hangs when changing font Faith Tay Excel Programming 0 July 18th 04 10:26 AM


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"