Open and reuse network drives within a macro

[FABIS]

How do I create a network drive, move data to it, close the drive and reuse the same drive for a new network location? I have 15 branch locations that I need to send data to each server within the macro.

 

[griffindm]

Fabis,

Why not use UNC conventions? You can also shell out to call .bat files from within the macro, and those certainly can use UNC for file copies.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[FABIS]

Great idea, but how does that work? Can you give me an example of the script? Thanks..........

 

[griffindm]

Fabis,

Create the .bat file as:

xcopy \\srcserver\srcdir\fileslike \\destserver\location /options

Then put a shell command, as in

shell path.copier.bat

within your macro at the appropriate location

Give it a try and let us know if you have questions.

Hope this helps.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[FABIS]

Thanks Dave, I will give that a try.