K
kurt
Hi
I Have a funny thing
Wen I run a VBA macro with this code
Debug.Print Me.Name (
Debug the file name correct)
Debug.Print ActiveSheet.Name ( Debug
the actual sheetname correct)
Workbooks("filename.xls").Activate
Sheets("Sheet name").Select
But it dont select the new sheet (sheet name) ??
It doesent either work with Windows("filename.xls").Activate
I am using windows 2000 and excell 2003
Anyone have an Idea??
regards
Kurt
I Have a funny thing
Wen I run a VBA macro with this code
Debug.Print Me.Name (
Debug the file name correct)
Debug.Print ActiveSheet.Name ( Debug
the actual sheetname correct)
Workbooks("filename.xls").Activate
Sheets("Sheet name").Select
But it dont select the new sheet (sheet name) ??
It doesent either work with Windows("filename.xls").Activate
I am using windows 2000 and excell 2003
Anyone have an Idea??
regards
Kurt