ether:
>
> ActiveWorkbook.SaveAs Filename:= InputBox("File name, please?")
>
>
> Paul
>
> - Original Message ----
>> From: Rajesh K R
>> To: excel-macros@googlegroups.com
>> Sent: Mon, December 20, 2010 8:28:51 AM
>> Subject: Re: $$Exc
---
or remove the variable altogether:
ActiveWorkbook.SaveAs Filename:= InputBox("File name, please?")
Paul
- Original Message
> From: Rajesh K R
> To: excel-macros@googlegroups.com
> Sent: Mon, December 20, 2010 8:28:51 AM
> Subject:
Hi
I think using save as it can do, I crate a macro given below but its
not working well
Sub copyfile( )
Dim Filename As String
ActiveWorkbook.SaveAs Filename:=Filename = InputBox("File name, please?")
end sub
it save the file in the name of False.xls always.Pls let me know what
is the trouble.
Re
Yes,
Send your data sheet with ur requirements.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rajesh K R
Sender: excel-macros@googlegroups.com
Date: Sat, 18 Dec 2010 17:24:19
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Create a new
