P
Phil
Ok.. I have a database and a spreadsheet on a network drive. The
spreadhseet has a series of links, both direct cell references and a
coloumn of formula's with links, to a different worksheet. Don't kwo if
that makes a difference or not.
If I open this database on MY machine, under Access 2002 sp3, and run
the Macro which includes a TransferSpreadsheet command, (and not much
more), It all works. It complains about two records not importing, and
other than those two records, all workds great.
However, an another machine running 2003 SP1, if I open this SAME
database, from a network drive mapped to the same drive letter, and run
the same macro, I get the same complaint about the two records, and no
error reports, but two or three of spreadsheet coloum don't come
through, and the field in the table are blank.
What's up with that? Any Ideas?
spreadhseet has a series of links, both direct cell references and a
coloumn of formula's with links, to a different worksheet. Don't kwo if
that makes a difference or not.
If I open this database on MY machine, under Access 2002 sp3, and run
the Macro which includes a TransferSpreadsheet command, (and not much
more), It all works. It complains about two records not importing, and
other than those two records, all workds great.
However, an another machine running 2003 SP1, if I open this SAME
database, from a network drive mapped to the same drive letter, and run
the same macro, I get the same complaint about the two records, and no
error reports, but two or three of spreadsheet coloum don't come
through, and the field in the table are blank.
What's up with that? Any Ideas?