Excel / VB???:))

[q4s72534]

I want to open a closed excel book writing by writing a vb script in another excel notebook. How should I do this?

thanks

 

[VBAva]

record a macro doing what you want to do, look at the code and change it if needs be

 

[Bowers74]

Try something like this:

Sub OpenWorkbook()
Dim wb As String
wb = "Workbook_You_Want_To_Open_With_Path_&_File_Extention"
Application.Workbooks.Open (wb)
End Sub

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!