ExcelBanter - Forcing names of linkfiles

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Forcing names of linkfiles (https://www.excelbanter.com/excel-programming/360187-forcing-names-linkfiles.html)

Mark McW[_2_]

Forcing names of linkfiles

I want to use a macro to replace a link using a new file name. Can I do this
without having to clear the current linked file name.

Thanks for your help...... Mark.

Tom Ogilvy

Forcing names of linkfiles

Look in Excel VBA help at the ChangeLink command.

--
Regards,
Tom Ogilvy

"Mark McW" wrote:

I want to use a macro to replace a link using a new file name. Can I do this
without having to clear the current linked file name.

Thanks for your help...... Mark.

Mark McW[_2_]

Forcing names of linkfiles

Dear Tom,

Many thanks.

"Tom Ogilvy" wrote:

Look in Excel VBA help at the ChangeLink command.

--
Regards,
Tom Ogilvy

"Mark McW" wrote:

I want to use a macro to replace a link using a new file name. Can I do this
without having to clear the current linked file name.

Thanks for your help...... Mark.

All times are GMT +1. The time now is 05:31 AM.