ADO - Paste Links
 

Hi Everyone,

Few days ago I posted a question regarding the possibility of copying data
from a closed workbook and I've got some useful tips.

The problem is that I'd like to copy the data from the closed workbook and
to use Paste Links option in the destination spreadsheet, so as I can trace
back the data source whenever necessary.

Is this possible?

Many thanks,

Bogdan

ADO - Paste Links
 

No, not using ADO.

Just write the links to the destination

Sub Write Links()
Range("C1").Resize(5,13).Formula = "='C:\MyFolder\[MyBook1.xls]Sheet3'!A1"
activeworkbook.Save
End Sub

--
Regards,
Tom Ogilvy

"Bogdan" wrote in message
...
Hi Everyone,

Few days ago I posted a question regarding the possibility of copying data
from a closed workbook and I've got some useful tips.

The problem is that I'd like to copy the data from the closed workbook and
to use Paste Links option in the destination spreadsheet, so as I can
trace
back the data source whenever necessary.

Is this possible?

Many thanks,

Bogdan

ADO - Paste Links
 

If you want to have the values of a whole range maybe you like this
http://www.rondebruin.nl/copy7.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bogdan" wrote in message ...
Hi Everyone,

Few days ago I posted a question regarding the possibility of copying data
from a closed workbook and I've got some useful tips.

The problem is that I'd like to copy the data from the closed workbook and
to use Paste Links option in the destination spreadsheet, so as I can trace
back the data source whenever necessary.

Is this possible?

Many thanks,

Bogdan

ADO - Paste Links
 

Oops: if you want to keep the formulas then remove the part it the function
that make values of the formulas

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
If you want to have the values of a whole range maybe you like this
http://www.rondebruin.nl/copy7.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bogdan" wrote in message ...
Hi Everyone,

Few days ago I posted a question regarding the possibility of copying data
from a closed workbook and I've got some useful tips.

The problem is that I'd like to copy the data from the closed workbook and
to use Paste Links option in the destination spreadsheet, so as I can trace
back the data source whenever necessary.

Is this possible?

Many thanks,

Bogdan

ADO - Paste Links
 

Thank you very much. I hope it will work properly.

Regards,

Bogdan

"Bogdan" wrote:

Hi Everyone,

Few days ago I posted a question regarding the possibility of copying data
from a closed workbook and I've got some useful tips.

The problem is that I'd like to copy the data from the closed workbook and
to use Paste Links option in the destination spreadsheet, so as I can trace
back the data source whenever necessary.

Is this possible?

Many thanks,

Bogdan