This may be simple but I haven't a

[tinymind]

This may be simple but I haven't a clue ..

I have a buton that opens an excel spreadsheet.. simple enough! But the spreadsheet has a password on it I want access to to open the spreadshee and run the macro within the spreadsheet ..

I have got the button to call the spreadshheet open it ...

The spreadsheet macro works when the spreadshett opens ... I just missing the set passwords bit in the middle to get it just right ...

If any one can help .. I will be much in their debt!

Tiny ...

Perfection IS Everything!

 

[GHolden]

This code will open a password protected excel workbook..

Private Sub mOpenExcelPassword()
Dim ExcelApp As New Excel.Application

ExcelApp.Workbooks.Open "C:\Test.xls", , , , "password"
ExcelApp.Visible = True

End Sub