Opening a workbook then switching back to first workbook

I am trying to make one of my macros open a file then switch back to the orignal file and then running the macro.

here is my code:

Please Login or Register  to view this content.

It's not clar what you are doing, what is your code intended to do? The line to open a workbook is not used.

Something like this

Please Login or Register  to view this content.

That has nothing to do with my code. The code that i gave you does exactly what you asked - opens the workbook then activates the workbook containing the code.

maybe your code is looking for a range in the newly opened workbook. Not sure without working my way through all the code. This doesn't specify which workbook you are using

Please Login or Register  to view this content.

Originally Posted by pradeesh

try this

Workbooks.Open Filename:="C:\Documents and Settings\randell.graybill.DOMAIN99\My Documents\17Cycle Count Logs.xls"

windows("macro file name").activate

Please wrap your code with Code Tags

windows("macro file name").activate - this is the workbook containing the code which can be referred to as ThisWorkBook!