Copy to another workbook

  • Thread starter Thread starter Soniya
  • Start date Start date
S

Soniya

Hi All,

I have to copy data from one sheet to another workbook.

i have custom menu in my first workbook and this menu is
deleted when work book deactivated. so when i copy data
and try to paste it to another workbook the paste option
is not available since the delete menu macro runs
(probabley)

is there a work around. ( copy and paste is done thru
macro)

TIA
Soniya
 
Soniya,

If you do

Activesheet.Copy

this will automatically create a new workbook from that sheet.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Move or Copy Stopped Working? 0
Copying a value from one workbook to another 3
Cell values to an array, then array transpose to another workbook 8
Copy cell value from one worksheet to matching worksheet in another workbook 4
Copy entire row(s) to another workbook based on partial cell crite 3
Copying Data from a workbook to another workbook 1
Copy to another workbook - prompt for input 3

Back
Top