Microsoft Office Forums - View Single Post - [Solved] Macro to update ole links not working

Thread: [Solved] Macro to update ole links not working

View Single Post

Old

02-05-2013, 03:52 AM

JohnWilson JohnWilson is offline

JohnWilson is offline

JohnWilson uses Windows 7 64bit

Windows 7 64bit JohnWilson uses Office 2010 32bit

JohnWilson uses Office 2010 32bit

Office 2010 32bit

Programmer

Join Date: Nov 2008

Location: UK

Posts: 1,913

JohnWilson has a spectacular aura about

JohnWilson has a spectacular aura about

Default

So to clairify: (for others)

By adding vbTextCompare you are essentially saying Ignore Case. This is why the lower case drive letter is accepted. The unstated default in Replace is vbBinaryCompare which IS case sensitive.

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

Reply With Quote