View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Opening another workbook while current one is open

Maybe:-

Sub sistance_level_wages()
Set myworkbook = ActiveWorkbook
Workbooks.Open ("c:\Documents and settings\myname\my documents\taxes.xls")
myworkbook.Activate
End Sub

Mike

"Bob" wrote:

After I have opened an existing workbook (Rates.xls"), I need to run a macro
(stored in the "Rates.xls" workbook) that will open another workbook called
"Taxes.xls" that's located in the "My Documents" folder. After "Taxes.xls"
has opened, I then need to make "Rates.xls" the active workbook so I can
continue to run the macro.
Can someone tell me how to do this, and make it so that the macro will work
on anyone's computer (the workbooks will always be located in a user's "My
Documents" folder.
Any help would be greatly appreciated. Thanks.
Bob