View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StephanieH StephanieH is offline
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.