Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: BAT File to update files  (Read 4895 times)

0 Members and 1 Guest are viewing this topic.

AAB

  • Guest
BAT File to update files
« on: January 07, 2007, 08:48:32 AM »
Hii

i want to create a bat file that would update a file upon running it

the master files lies on the business network

the address of the master file is \\data-server\e\masterfile.xls
the address of the file that needs to be updated is located in the user's desktop

Thanks

Amrykid



    Beginner

  • Piplup rules!!!!!!!!
    Re: BAT File to update files
    « Reply #1 on: July 03, 2007, 01:02:38 PM »
    you need a source to update this file from.
    @echo off
    copy masterhead.xls+source.xls
    exit
    that might work.
    Laptop Specs:
    Manufacturer:Gateway
    Model:MT3705
    OS:Windows Vista Home Premium
    Processor:Intel Pentium Dual-Core Mobile Processor 1.60 GHz, 533 MHz FSB
    Graphics:ATI Readeon Xpress 200M Graphics with 256 HyperMemory
    Memory:1024 MB DDR2
    Network: B/G WLAN Card, 10/100 mbps Ethernet LAN, 56k Fax/Modem

    ghostdog74



      Specialist

      Thanked: 27
      Re: BAT File to update files
      « Reply #2 on: July 03, 2007, 07:36:59 PM »
      you need a source to update this file from.
      @echo off
      copy masterhead.xls+source.xls
      exit
      that might work.
      you can't just update excel files like that. the proper way is to open both excel files, one for reading, one for writing.