G
Guest
XP Pro; Office 2003 Pro
My company is reorganizing our servers. We have a lot of Access databases
that use macros and/or vba code to establish links to external sources for
both import and import. Many of these references have been "Drive Hardcoded"
(i.e. the macro exports to "K:\Shared\...\whatever.xls) (Don't blame me I
wasn't there when these were set up!)
I know how to use the VBE object to edit the VBA code within a database to
find/replace the "K:\" with something akin to "\\KServer\", but how do I edit
the lines in a Macro (e.g. a macro exports to "K:\", but I want to change the
export to "\\KServer\")?
I tried the KB and several Access sites as well as a Google search, but
can't find this specific solution.
I'd appreciate any help/suggestions you can offer..
BAC
My company is reorganizing our servers. We have a lot of Access databases
that use macros and/or vba code to establish links to external sources for
both import and import. Many of these references have been "Drive Hardcoded"
(i.e. the macro exports to "K:\Shared\...\whatever.xls) (Don't blame me I
wasn't there when these were set up!)
I know how to use the VBE object to edit the VBA code within a database to
find/replace the "K:\" with something akin to "\\KServer\", but how do I edit
the lines in a Macro (e.g. a macro exports to "K:\", but I want to change the
export to "\\KServer\")?
I tried the KB and several Access sites as well as a Google search, but
can't find this specific solution.
I'd appreciate any help/suggestions you can offer..
BAC