Printable View
Well. I have created a dialog box, which is activated by a command button on another worksheet. I first created it ina workbook called bidding april29, my boss has combined what I was doing with what he was doing and now it is calling bidding may2003. BUT when I push the button to run the dialog box, if opens the old file to run it?? Smarty me , thought just move the old file and it would fix its self - - dumb move now i just get an error??
Any suggestions??? Other than start over!
Just a suggestion, but if you show some code, it's usually easier to help.
this is the code o n the button
Private Sub CommandButton2_Click()
Application.ScreenUpdating = False
Sheets("Dialog1").Select
DialogSheets("Dialog1").Show
Application.ScreenUpdating = True
End Sub
this is the error i keep getting
'system bid template kim29may.xls' could not be found. check the spelling of the file name, and verify that the file location is correct.
Then I get a run time error .1004, show method of dialog sheet class failed. Then I can end or bedug, if I debug this line is highlighted: DialogSheets("Dialog1").Show
All I know is the my "smart" boss combined what I was working on and what he was doing and then deleted my old file, cuz when you pushed the button in the new file it opened the old file to run the dialog box.
Well, if, as you say 'my "smart" boss combined what I was working on and what he was doing and then deleted my old file' you have isolated your problem have you not? Your button code refers to a worksheet in your old file which no longer exists. That's why the file can't be found or the Show method on its worksheet implemented.
ok, i knew what the prob. was just dont know how to fix it??? I cant see where the code points to the old file??