I wrote an Excel macro for saving a sheet of Excel Book by reference of a cell text. I want to do is if that f

Suppose............

1. I have a sheet called Garment & its contain ramesh in Cell A10. Then my macro saves it ramesh.xls with garment sheet. Again I run my macro in Home sheet & it鈥檚 also containing ramesh in Cell A10 then a dialogue box display {a file named ramesh.xls already exists in this location. Do you want to replace it?}. So, I want to save it as Home Sheet in existing file i.e. ramesh.xls. If it contains deepu then save it as deepu.xls with Home sheet.

Use "on Error go to " a new subroutine say "add()"
In this one ("add()")you do a "open" on the existing workbook. You do worksheet.copy on the "home" in the original workbook (now referred to as workbook(2)) and paste in "ramesh". save and close.

By the way you can turn off all warnings with "Application.DisplayAlerts = False" but remember to turn it back on ("=true") before you exit the sub.

Tags

　　General - Computers & Internet 　　Software 　　Security 　　Programming & Design 　　Facebook 　　Flickr 　　Google 　　MSN 　　MySpace

Related information

Can someone please tell me how to make a website?

You can find step by step guide on how to make a website at website like ...

C programming Probelem..Money changer?

You currently have the following currency. Peso Notes 5 10 20 50 100 200 500 1000 centavos 1 5 10 25 Take the input and divide it in turn by each amount starting with the highest...

How to program to copy the content from a word file to a .html file and keep the original format?

u need to know the format of word file to do that (.doc file format) .html file is a pure text file, hence no prob creating it. U have to read the .doc file and process it to create a .html f...

Where is the best place to get free table quiz quistions????

If this is homework, your textbook. If it's for a qualifying exam, a textbook for that exam.

...

Problems with website building?

Dear... > You Can Use The Web View Buttone On Bottom Left Area, And See how IT Will Be After Saveing As Web. > You Don't Have To Use Ms-Word To Build A website, You Can Use Frontpage, ...

Creating tables in sql?

CREATE TABLE `person` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR( 64 ) NOT NULL , `age` INT( 8 ) NOT NULL , UNIQUE ( `id` ) ) ENGINE = innodb; Simple example that works for me.

Ftp swf html question. First time uploading into server.?

You can edit the .htaccess file placed in your wwwroot directory and add the line: DirectoryIndex index.html index.htm index.php Using this line you can specify (the order in) which documents...

I need a script that can verify if a link is on a certain page. Please read all details before answering, Thx!

getElementsByTagName('a') will return an array of all anchor elements in the page. Compare the href attributes of those items to the requested url until you find a match or fail. <h...