Excel 4 macro File Functions Add-in

[MOBreault]

A client is using XLM macros that work in Excel up to version 98. Excel 2001,
X, and 2004 do not. The macros use the File Functions Add-in (specifically
CREATE.DIRECTORY and FILE.EXISTS). Can anyone point me to information on why
this add-in no longer works and how to fix the problem. They would like to
buy new hardware that will allow them to move on to Office 2004 or 2008 but
these macros have to work.

Thanks,

Mike

 

[Bob Greenblatt]

A client is using XLM macros that work in Excel up to version 98. Excel 2001,
X, and 2004 do not. The macros use the File Functions Add-in (specifically
CREATE.DIRECTORY and FILE.EXISTS). Can anyone point me to information on why
this add-in no longer works and how to fix the problem. They would like to
buy new hardware that will allow them to move on to Office 2004 or 2008 but
these macros have to work.

Thanks,

Mike

These were components of the ancient File Functions add-in written in XLM.
You should be able to take the file from the Excel 98 installation and use
it with Excel 2008.

Well, I take that back, I resurrected fiefuns.xla and installed it and it
did NOT work. Although it appeared to try.

 

[MOBreault]

These were components of the ancient File Functions add-in written in XLM.
You should be able to take the file from the Excel 98 installation and use
it with Excel 2008.

Well, I take that back, I resurrected fiefuns.xla and installed it and it
did NOT work. Although it appeared to try.

Hello Bob,

Yes it appears to load but the add-in functions don't work. It looks like
sometime between Excel 98 and 2001 the add-in was disabled. Possibly
something to do with the Register.ID or some other DLL that was written into
the code of the File Functions Add-in. But I can't find any documentation
about the change.

Thanks,

Mike

 

[Bob Greenblatt]

Hello Bob,

Yes it appears to load but the add-in functions don't work. It looks like
sometime between Excel 98 and 2001 the add-in was disabled. Possibly
something to do with the Register.ID or some other DLL that was written into
the code of the File Functions Add-in. But I can't find any documentation
about the change.

Thanks,

Mike

The register functions and Calls were probably set up to call into OS 0 (or
probably 7)> I don't have a clue as to what will happen in OS X since
Classic is not even present. Don't expect to find any documentation about
the change(s).

You can use =directory(...) to do the same thing as file.exists. And, you
can easily call out to an apple script to create and/or delete a directory.
Thus, you code will probably work fine after some minor modifications.