Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook used to open but now crash with File/path error
office excell 2003
windows xp i been working on a .xls sheet with 3 userforms and about 8 usermodules. to start i got /////////////////////////////////////////////////////////////////////////////////////////////// Private Sub Workbook_Open() Sheets("Sheet1").Select Worksheets("sheet1").Range("K4").Value = False Worksheets("sheet1").Range("K5").Value = False Worksheets("sheet1").Range("K6").Value = False Worksheets("sheet1").Range("K7").Value = False Worksheets("sheet1").Range("K8").Value = False With Application .Calculation = xlCalculationAutomatic .MaxChange = 0.001 End With Application.Visible = False UserForm1.Show UserForm1.TextBox1.Value = "" UserForm1.CheckBox1.Value = False UserForm1.CheckBox2.Value = False UserForm1.CheckBox3.Value = False UserForm1.CheckBox4.Value = False UserForm1.CheckBox5.Value = False End Su /////////////////////////////////////////////////////////////////////////////////////////////// when i select disable macro's the workbook dont crash but if i enable it does.... /////////////////////////////////////////////////////////////////////////////////////////////// file/path access erro /////////////////////////////////////////////////////////////////////////////////////////////// and when i go and look at the repair log i get //////////////////////////////////////////////////////////////////////////////////////////////// Microsoft Office Excel File Repair Log Errors were detected in file 'C:\files\Jobcard.xls' The following is a list of repairs: Lost Visual Basic project /////////////////////////////////////////////////////////////////////////////////////////////// |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File crash when I try to open | Excel Discussion (Misc queries) | |||
How to find file-path of open workbook? | Excel Discussion (Misc queries) | |||
Excel crash when exiting with the Workbook open | Excel Programming | |||
Word and Excel crash when I try to open a folder to get to a file | Excel Discussion (Misc queries) | |||
Path\File name length problem Excel Crash on save as | Excel Discussion (Misc queries) |