Posted to microsoft.public.excel.programming

JohnQ[_2_] JohnQ[_2_] is offline

external usenet poster

Posts: 1

change links by a macro

I'm using the macro below to change the input file.
I have to do this for 20 spreadsheets which contains 5
similar links each.

The problem is that excel is not been able to locate the
new file and or path.

Sheets.Select

Cells.Select

Selection.Replace What:= _
"H:\2004\[source.XLS]", _
Replacement:= _
"H:\2005\[source.XLS]", LookAt _
:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I change the links in Excel at one batch?	LunaMoon	Excel Discussion (Misc queries)	1	April 24th 10 12:59 AM
change multiple links at once	TaralearningExcel	Excel Worksheet Functions	1	April 8th 10 05:32 PM
Change named cells and keep the links	BCN	Excel Discussion (Misc queries)	1	April 2nd 08 10:11 AM
Change links between 2 spreadsheets	Russell-stanely	Excel Discussion (Misc queries)	0	September 20th 06 05:46 PM
Writing a macro to change external links to manual updating in Excel 2000	John Wirt[_5_]	Excel Programming	6	February 16th 04 08:03 AM

All times are GMT +1. The time now is 03:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us