,
We use word 2003 in our company. We have some shared folders that we want
our users to have a direct path to from word. We created a macro
Sub ISP()
ChangeFileOpenDirectory "\\Xpcdc001\Plans\ISP\"
SendKeys "^o" '
End Sub
This macro browsers to the \\Xpcdc001\Plans\ISP\ share and then does a
control O to open the open file box.
We added this macro under tools --> macros --> macros
then added the macros name and typed the vba code between the sub and end
sub into the editor.
Next we wanted to create a custom menu item linking to this macro so that
our users would be able to run it easy .
We went to tools --> custom --> comands
added a new menu and added the macro to the menu.
We get very odd results.
When word is started and you go to the menu and click the macro it opens the
open file box and defaults to my documents (which is incorrect because it
should default to the share specified) When you close the file open box and
reclick it without closing word you get the correct location in the file
open box. You get the correct location everytime then when you click the
macro till word is closed and reloaded. Always on the first time it
defaults to the my documents location.
I have downloaded all patches and service pack 2 from office website and
still did not resolve the problem.
Any input on this problem will help alot.
Danewman@ahrc.org