sisthenameofanewworkbook" and close
>
> '------------------------------------
> ActiveWorkbook.SaveAs _
>
> Filename:="C:\Users\(*youruseridgoeshere*)\Desktop\thisisthenameofanewworkbook.xlsb",
>
> _
>
Close
End Sub
I hope this helps.
Paul
-------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
Abhishek,
snarky...I like it!
:)
Paul
From: Abhishek Jain
To: MS EXCEL AND VBA MACROS
Sent: Wednesday, October 7, 2015 2:37 AM
Subject: Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save
it on desktop
Yes, we can.
On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR
Yes, we can.
On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR KOKNE <
pradeepkumar...@gmail.com> wrote:
> Hello all,
>
> Can you write code for to filter(Column S)-> select the complete visible
> data and paste it in new workbook and save it.
>
> Example: Column S can have 50 lines data with 10 name
Hello all,
Can you write code for to filter(Column S)-> select the complete visible
data and paste it in new workbook and save it.
Example: Column S can have 50 lines data with 10 names
Thanks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !