Code to save file

**Jumpy** · 11-14-2007, 05:41 AM

Hello, I am new to this forum and need some help.

I have this code to save a worksheet into a specific directory:

Please Login or Register  to view this content.

Cells B9 and B7 give the name to the file.

If the file already exists, I get a warning. If I click YES, it will overwrite the file, if I click NO, it will give me a run time error 1004.

What I am looking for is a code that closed the warning when clicking on NO and does not give me the run time error.

Thank you.

**jindon** · 11-14-2007, 05:49 AM

try not to error out

Please Login or Register  to view this content.

**Jumpy** · 11-14-2007, 05:57 AM

Thanks for your reply.

Sorry but I am getting a error on line

Please Login or Register  to view this content.

**mudraker** · 11-14-2007, 07:52 AM

Jumpy

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

**Jumpy** · 11-14-2007, 08:35 AM

Sorry. This is the part of code that does not work. Appreciate your help.

Please Login or Register  to view this content.

Thanks.

**mudraker** · 11-14-2007, 02:27 PM

Try this

Please Login or Register  to view this content.

**royUK** · 11-14-2007, 03:17 PM

Are you using Excel 2007?

**jindon** · 11-14-2007, 08:21 PM

Originally Posted by Jumpy

Sorry. This is the part of code that does not work. Appreciate your help.

Please Login or Register  to view this content.

Thanks.

Sorry missed " at the end

Please Login or Register  to view this content.

**Jumpy** · 11-15-2007, 03:20 AM

Thank you. This works better but still need some help.

The following code informs me that a file with that name already exists.

Please Login or Register  to view this content.

I need to add two more buttons on the warnings.
One asking if you want to replace the existing file.
The other, NO, abort the command.

Thank you.

**jindon** · 11-15-2007, 03:36 AM

try

Please Login or Register  to view this content.

**Jumpy** · 11-15-2007, 05:02 AM

Thank you. Still a problem.
Please see how I have changed the code:

Please Login or Register  to view this content.

When I click on the button, even if a file with name similar to cells B9 and B6 does not exists, I get the message, Is Already Exists.
Obviously, if a file is not present in the above directory, it should save it automatically.

Last issue. Is there the change to add another cell range to the aboe FILE NAME criteria? Example, I want to add B1?

Thank you.

**jindon** · 11-15-2007, 05:25 AM

try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**Jumpy** · 11-15-2007, 05:53 AM

Sorry but cannot get it to work. I am not very familiary with VBA but I will try to go over the code so that you can better understand what I am trying to achieve:

1) I need a cmdbutton on a worksheet to save the workbook as an excel file in a specific directory. In this directory files are named by First and Last Name. In my worksheet the range of cells which are used to give this data is B9 and B7. The code will verify if a file with a similar name exists. If YES, I need a message asking if to replace. If not, a need a NO button to abort and go back to the worksheet.

Let's now check the code:

Please Login or Register  to view this content.

Thank you for your patiente.

**jindon** · 11-15-2007, 05:56 AM

Sorry I need to go off-lline now

I'll be busy tomorrow, so I will look at it on Sat here.

Code to save file

LinkBack

Thread Tools

Rate This Thread

Display

Code to save file

Code to save file

Code to save file

Code to save file

Code to save file

Code to save file

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions