View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vacation's Over Vacation's Over is offline
external usenet poster
 
Posts: 279
Default Copy empty cells from one workbook to another - Code

3 suggestions
1) copy Values so that any formulas or other file specifics are left behind
2) since you know the file name close it by name, avoids issues if you add
more code later
3) clear the clipboard after copy

Sub Dataacquire()
Workbooks.Open "data.xls"
Worksheets("sheet1").Range("b1:d19").Value.Copy _
ThisWorkbook.Worksheets("sheet1").Range("b1:d19")
Application.cutcopymode = False
Workbooks("data.xls").Close SaveChanges:=False
End Sub

"David Choen" wrote:

Hello,

Sorry for posting 2 times. Date & time in my computer were not correctly
set.

In addition to what I've written before, here is the code I wrote:

Sub Dataacquire()
Workbooks.Open "data.xls"
Worksheets("sheet1").Range("b1:d19").Copy _
ThisWorkbook.Worksheets("sheet1").Range("b1:d19")
ActiveWorkbook.Close SaveChanges:=False
End Sub

My problem that empty cells are not copied as empty and
because of this I get an error messages in other worksheets (like #VALUE).

How Can I solve this problem ?

Thank you
David Cohen