/build/static/layout/Breadcrumb_cap_w.png

Finding and replacing hardcoded file in an xla file..

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 

Asked 11 years ago 2520 views
0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: jagadeish 11 years ago
Red Belt
0

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 :\

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ