Copy a network file and paste locally using a Macro

  • Thread starter Thread starter Presto
  • Start date Start date
P

Presto

Access 2003 macro nubie here.

I have to copy two files from a network location. Both are Access Databases
that need to be stored locally,
then run one of them.

It is currently done via a DOS batch file called by a macro, but I feel this
is a bit clumbsy.(the fewer files the better)
I would like to be able to do this directly within the macro.

So in a nutshell :
1. Copy \\networkpath\mydatabasefile1.mdb and paste to c:\pcdata
2. Copy \\networkpath\mydatabasefile2.mdb and paste to c:\pcdata
3. Run c:\pcdata\mydatabasefile1.mdb

Thanks in advance for your assistance.
 
find solutions of problems and solution regarding CISCO, CCNA, CCNP, MCSE,
LINUX, WIRELESS, SECURITY, NETWORK, IT NEWS

http://www.theitstuff.co.cc/

http://www.theitstuff.co.cc/understand-ospf-lsalink-state-advertisement-types/

http://www.theitstuff.co.cc/explore-different-types-of-ethical-hacking/

http://www.theitstuff.co.cc/what-network-management-covers/

http://www.theitstuff.co.cc/simple-network-management-protocol/

http://www.theitstuff.co.cc/important-consideration-in-designing-of-the-server-room/

http://www.theitstuff.co.cc/router-as-a-dhcp-server/

http://www.theitstuff.co.cc/assembling-a-motherboard-help-with-video-tutorial/

http://www.theitstuff.co.cc/ccna-and-ccnp-tutorial-vlan-trunking-protocol-vtp/

http://www.theitstuff.co.cc/nat-configuration-on-a-cisco-router/

http://www.theitstuff.co.cc/how-to-make-a-cat-6-network-cable-video-tutorials/

http://www.theitstuff.co.cc/types-of-network-attacks/

http://www.theitstuff.co.cc/advantages-of-optical-fiber-over-other-media/

http://www.theitstuff.co.cc/learn-tcp-ip-with-beautiful-animation-video/

http://www.theitstuff.co.cc/firewall-techniques/
 
Presto,

No, you can't do file amnipulations with macros. You will need to use a VBA
procedure. The syntax would be:
FileCopy "\\networkpath\mydatabasefile1.mdb" "C:\pcdata\mydatabasefile1.mdb"
Application.FollowHyperlink "C:\pcdata\mydatabasefile1.mdb"
 
Presto said:
Access 2003 macro nubie here.

I have to copy two files from a network location. Both are Access
Databases that need to be stored locally,
then run one of them.

It is currently done via a DOS batch file called by a macro, but I feel
this is a bit clumbsy.(the fewer files the better)
I would like to be able to do this directly within the macro.

So in a nutshell :
1. Copy \\networkpath\mydatabasefile1.mdb and paste to c:\pcdata
2. Copy \\networkpath\mydatabasefile2.mdb and paste to c:\pcdata
3. Run c:\pcdata\mydatabasefile1.mdb
Click to expand...

Are you willing to try/use code in place of a macro?

The vba code to do the above is:


FileCopy "\\networkpath\mydatabasefile1.mdb",
"c:\pcdata\mydatabasefile1.mdb"
FileCopy "\\networkpath\mydatabasefile2.mdb",
"c:\pcdata\mydatabasefile2.mdb"
Application.FollowHyperlink "c:\pcdata\mydatabasefile1.mdb"
 
Back
Top