always on top

[Jorn]

Good MOrning All!

I have tried a search, as i have seen this somewhere on the board but cant find it now. How do I make a form float on top of excel, but still enable the user to open excel workbooks and select them? (basically this is a pushbutton formatting program, and they need to be able to open certain worksheets and push a button on the form)

Can someone help?

Cheers!

John

 

[Jorn]

Hey Ho,

From this code, i can see that I can successfully generate an open window, however, it will only tell me the file can open.

What else do i need to add to get it to actually open the file? Ive tried the basics. the code im using is below.

Private Sub CommandButton4_Click()
fileToOpen = Application.GetOpenFilename("Excel Files (*.xls), *.xls")
If fileToOpen <> False Then
MsgBox "Open " & fileToOpen
End If
End Sub

 

[Ekim]

Private Sub CommandButton4_Click()
fileToOpen = Application.GetOpenFilename("Excel Files (*.xls), *.xls")
If fileToOpen <> False Then
'MsgBox "Open " & fileToOpen

Workbooks.Open fileToOpen
End If
End Sub

Regards,

Mike