LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default Filepath and Updating Links

This is probably really simple and I'm just missing it, but need something
that will tell Excel that if I'm opening a file in the file folder "Loan
Recovery MIS" or if the file path name begins with
"\\Fl-aejf-fs1\Data\Data\RECOVERY\EXLDATA\Loan Recovery MIS" then do not
update the links.

I've tried

If filepath = "\\Fl-aejf-fs1\Data\Data\RECOVERY\EXLDATA\Loan Recovery MIS" _
Then UpdateLinks:=0

But I get "Expected = Expression" with the := highlighted.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Updating links ck13 Excel Discussion (Misc queries) 0 March 19th 10 01:29 AM
Links are not updating S.Latza Excel Worksheet Functions 0 April 18th 08 07:47 PM
Updating Links WhytheQ Excel Discussion (Misc queries) 7 June 1st 06 11:25 AM
Updating links Brisbane Rob Excel Discussion (Misc queries) 2 April 1st 06 09:54 PM
Updating Links hurlbut777 Excel Programming 1 November 19th 04 03:47 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"