thank you
On Mon, Feb 27, 2012 at 5:57 PM, NOORAIN ANSARI wrote:
> http://www.mrexcel.com/forum/showthread.php?t=354
>
> On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
>
>> is it possible to save a particular worksheet of a workbook with a save
>> command button on an userform ?
>>
>> --
http://www.mrexcel.com/forum/showthread.php?t=354
On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
> is it possible to save a particular worksheet of a workbook with a save
> command button on an userform ?
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise
For workbook -
ActiveWorkbook.Save
For active sheet only -
ActiveSheet.Select
ActiveSheet.Copy
ActiveSheet.SaveAs Filename:="YOUR DIR" & YOUR FILENAME & ".xls"
HTH
Abhishek
On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
> is it possible to save a particular worksheet of a workbook w
is it possible to save a particular worksheet of a workbook with a save
command button on an userform ?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Hi all,
I have some Excel sheets that I want to save as a UTF8 file in .txt
and .csv formats, using a VBA macro. I've found the following code:
'Function saves cText in file, and returns 1 if successful, 0 if not
Public Function writeOut(cText As String, file As String) As Integer
On Error GoT
