Save as Activeworkbook but not .xls
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Save as Activeworkbook but not .xls

  1. #1
    Guest

    Default

     
    Hello.....Everybody
    If I want to Save as Activeworkbook by using the same name but Lastname (.xls) I want to use .tmp , How can I do (by Macro Command) .....Thanks

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you mean like this?

    Sub savename()
    Application.ActiveWorkbook.SaveAs ("c:filename.tmp")
    End Sub

    you could also use:

    Application.Activeworkbook.savecopyas

    to save a copy instead of the actual file. Hope that helps

  3. #3
    Guest

    Default

    I use this Command but it show Run-time Error 1004 ,How can i do next ?

  4. #4
    Guest

    Default

      
    Hello...again
    Yes it work perfectly, last time i do something wrong with this command (human error) now it work already ...thank you GUY

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