how to keep formula un-changed when I chage to file folder?

G

Guest

Hi, now I'm meet a problem as follow on Excel 2000 and 2003
I have define one function in one Excel file named "file1.xls"
in another excel file(file2.xls) I wanna use the function defined in
file1.xls, so I write the formula as following,
=file1.xls!function1(A1,A2)

in my VBA code, I can sure file2.xls always work with file1.xls together (
that's means when file2.xls reflash, file1.xls always be opened)

my problem is: when I copy the file2.xls to another folder and file1.xls
still in current folder(for example: D:\test\test1\file1.xls, and file2.xls
move to C:\test1\file2.xls).

when I reopen file2.xls, the formula will changed to:
='D:\test\test1\file1.xls'!function1(A1,A2).

how I can keep the formula don't change when I copy & move file2.xls, anyone
can help me, thanks in advance !
 
T

Tom Ogilvy

close file2.xls (with file.xls still open) then close and move file1.xls or
do a file saveas.
 

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