Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I run the following code... it crashes my excel and I believe it is
because of the break links command. any ideas? Application.Run "'SNW INV PLAIN.xls'!FilterAll" Sheets("Agencies").Select Range("a1").Select Sheets("Corporates").Select Range("a1").Select Sheets("Tax Muni's").Select Range("a1").Select Sheets("Muni's").Select Range("a1").Select Sheets("Agencies").Select Sheets(Array("Agencies", "Corporates", "Tax Muni's", "Muni's")).Select Sheets("Agencies").Activate Sheets(Array("Agencies", "Corporates", "Tax Muni's", "Muni's")).Copy ActiveWorkbook.BreakLink Name:="S:\Inventory\SNW INV PLAIN.xls", Type:= _ xlExcelLinks Application.Wait Now + TimeSerial(0, 0, 1) Sheets("Agencies").Select ActiveWorkbook.Protect Password:="snwwb", Structu=True, Windows:=False sFilename = "S:\Inventory\SNW Offerings " & Format(Now, "yyyy-mm-dd") ans = MsgBox("Save file as " & sFilename) If ans = vbOK Then ActiveWorkbook.SaveAs Filename:=sFilename End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Break a link between workbooks when there is no "break" option | Excel Discussion (Misc queries) | |||
Link won't break | Excel Discussion (Misc queries) | |||
Can Not Break a Link | Excel Discussion (Misc queries) | |||
Can't break my link | Excel Discussion (Misc queries) | |||
break a link | Charts and Charting in Excel |