Hi to all
I would like a macro which can copy a sheet(sheet1) from workbook1 while workbook is closed, into sheet2 of workbook2, i need to copy the whole sheet, please help me in this regard I am very thankfull for all of you.
Have you tried to record a macro for this problem?
Create a button and put it on sheet2 of workbook2
'Open the data download file
Workbooks.Open "C:\Documents and Settings\yourname\Desktop\book1.xls"
'Update information from cells A:VI on the download sheet to the database
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
'Close the download sheet
Thanks for your reply I appreciate it sorry for replying you late
I try to use your code but I have a problem in it and the exact line where I debug it is
as your cide is stuck here its on the basis of debugging result
as I try several option here
but it also not working
What do u think