How do I get my macros to work consistently

K

Kathryn Pundt

I have created several simple macros to open up particular files. I test
them and they work at that time, but later they don't. It looks like the
macro was altered when I go to the edit screen. I loose the first line
"changefileopendirectory" and the path. I find that if I run a macro that I
created before to retrieve a file from the same directory that I want the
file from, then rerun the macro that isn't working and I created at a later
date, the latter one will work. It seems to use the path from the previous
macro to find the file. How can I get the macro to remain as I have created
it?
 
F

fumei via OfficeKB.com

It may help if you post your code. It is probably something simple, but it
is hard to say without your code to look at.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top