Copying data from one spreadsheet to another

D

DSTDIVA3

I have this posted in Excel programming maybe I should have posted it here.
I have an Access application. In the application I have to copy data from
one spreadsheet, called source, to another spreadsheet, called target. I get
the data from the source by accessing the range of data. That was
successful. In the target spreadsheet the tables are defined, or their
ranges are defined. I see the data for that one also. When I try to update
the data in the target using vb, Iget errors saying it is not updateable or
the object is not recognized. I have been looking for a solution for 3 days
now. Can someone help me?
 
S

sk

I have not idea about Access, but at least i can try to help.
I have this posted in Excel programming maybe I should have posted it here.
I have an Access application. In the application I have to copy data from
one spreadsheet, called source, to another spreadsheet, called target. I get
the data from the source by accessing the range of data. That was
Click to expand...
Do you acctually get the handle to the target sheet?

How about you do this in the same excel sheet by defining two different
range one
called source and source for the other? Can you update the target range from
source range?

Mind posting the source here. otherwise you will only get the help from
people like me, not really smart.

Shinya
 
D

DSTDIVA3

I solved my problem. I put a where clause in my sql statement to specify the
month the data will be placed in the cell.
 
Top