LinkBack URL
About LinkBacks
Macdave_19 
put the following code into the ThisWorkbook file that is on the left hand side in VBA with the little excel icon.
Sub Workbook_Open()
Workbooks("sample.xls").Activate
ActiveWorkbook.Close
Workbooks.Open Filename:="c:\sample.xls"
End Sub
put the following code into the ThisWorkbook file that is on the left hand side in VBA with the little excel icon.
Sub Workbook_Open()
Workbooks("sample.xls").Activate
ActiveWorkbook.Close
Workbooks.Open Filename:="c:\sample.xls"
End Sub
cheers
really no need for the "little excel icon" part lol i know me way around by now lol
thanks for the help dude!!!! my code was similar to this!!
Mr MaGoo
Magoo.Inc MMVII
If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post
Actually the code that I wrote earlier was a bit specific. It would activate when you open the initial workbook. However, the body of the code is the same if you want to use the procedure in a module.
Sub ThisModuleClosesAndReopensAnotherWorkbook()
Workbooks("sample.xls").Activate
ActiveWorkbook.Close
Workbooks.Open Filename:="c:\sample.xls"
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks