Thread: How do I copy a worksheet form a workbook in my workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Atkinson Neil Atkinson is offline
external usenet poster
  
Posts: 13
Default How do I copy a worksheet form a workbook in my workbook

Hi am using the following code to open a workbook

sFileName = Application.GetOpenFilename
If sFileName = "False" Then Exit Sub
Workbooks.Open sFileName

I need to copy sheet2 from the open workbook into the workbook that is
running the above code.

Also another thought if the workbook mentioned above is already open
what is the code to stop an error showing and activating the open
workbook?

Many Thanks
Neil

*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote