Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
| Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 29th, 2004, 04:31 AM
Authorized User
 
Join Date: Nov 2004
Location: CHENNAI, TamilNadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to tks_muthu
Default Save the Existing Workbook to Other Filename

Hi all!
i am developing a application for accounting purpose using with Visual Basic 6.0 and Access.
then i was export the data's to existing excel workbook. (named Receipts.xls).
now i would like to save the existing excel workbook to another FileName.(i.e backup_receipt.xls)
how can i does like this?.

plz help me!

regards


Muthu
__________________
Muthu
 
Old November 29th, 2004, 10:41 AM
Authorized User
 
Join Date: Nov 2004
Location: , , .
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Put this in a module and tie it to form button:

Sub Whatever()
    Dim wbSource As Workbook
    Set wbSource = ThisWorkbook
    wbSource.SaveAs (ActiveWorkbook.Path & "\yourfilename.xls")
End Sub





Similar Threads
Thread Thread Starter Forum Replies Last Post
Handling Non-Existing Web Files with Workbook.Open white_wulff Excel VBA 1 May 14th, 2007 03:07 PM
Howto save a Filename uploaded file to db? GigaBear ASP.NET 2.0 Basics 10 June 22nd, 2006 05:10 PM
Workbook slow to save cunninb Excel VBA 1 February 17th, 2005 10:11 AM
How to save the different filename loveperson VB How-To 1 December 23rd, 2004 04:53 PM
Saving Excel workbook with new filename tsegal20 Excel VBA 1 May 21st, 2004 01:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.