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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

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

Answered 02/20/2013 by: jagadeish
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share