I created a macro that was to sort through records and give two different
formats depending on what was located in column C. When I tried to export
the macro as an xla file so others can use it as an independant macro, it
didn't work as I intended it to. I had to first enable the macro, and
afterwards it looked for the file that I had created the macro on. When I
took the file out of the directory, it gave an error message saying that it
couldn't find the file. How do I configure the macro so that it doesn't try
to look for that file?