I am facing an issue with excel addin actually an xla file is pointing to an xls file but it cannot find it coz it is looking in a wrong location due to hardcoded paths in it... 

Can any one tell me a way of finding and replacing the hardcoded path in an xla file?

Thanks in advance 

Answer Summary:
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



Open .xla file

Press ALT+F11

Select the module/sheet incase you have multiple (Hope it is not password protected)

Press CTRL+F

Search for :\

Answered 02/20/2013 by: jagadeish
Red Belt

Please log in to comment