macro not running in XP

S

shalini

My macro is working in NT but not working in XP.compilation error saying
dll not found is coming.actually the applciation contains 3 buttons. 2
buttons out of which are used to open the common dialog box (for
selecting the files destination.)and another button behind which the
entire macro is placed. now the problem is in XP we are unable to even
click the button (to select the path ,error message saying compilation
error dll not found is arising) In tools references
i have checked the vba project and few others but could'nt solve the
problem..
Private Sub CommandButton1_Click()
NameArbeitsmappe = ActiveWorkbook.Name
Workbooks(NameArbeitsmappe).Sheets
("Steuerung").CommonDialog5.ShowOpen

Workbooks(NameArbeitsmappe).Sheets("Steuerung").TextBox1.Text = _
Workbooks(NameArbeitsmappe).Sheets("Steuerung").CommonDialog5.Filename

End Sub

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Top