calling a template which has macro to open file and format t
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: calling a template which has macro to open file and format t

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Here is what i want to do:-
    1. a query runs from mainframe thru DAF i can open c:MSOFFICEOFFICEEXCEL.EXE and creates mainframe.xls file in c:data
    2. i want to use a template test1.xlt which i have stored in template folder. In this template i have written a macro which goes in c:data and opens mainframe.xls file and formats it.
    i am not able to open this template by using this command

    c:MSOFFICEOFFICEEXCEL.EXE /test1.xlt do u know how to open this template or any other method.
    Thanks


  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please help!!!!!!!!!!!!!!! i am stuck

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please help!!!!!!!!!!!!!!! i am stuck

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dave can you please help me with this.
    Thanks

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Basically i want to open a template from DAF which would format the xls sheet created by daf.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com