Coding for Macro

[sandip]

Hi,


I want macro to create new workbook with specify name and take specify range data from main workbook. so please help me for same.


Regard's
Sandip Sable.

 

[Marc L]

Hi,

you should use the macros' recorder giving a basic beginner code …

 

[sandip]

Hi please provide me code

 

[Marc L]

​

Even if I would, I could'nt 'cause I'm not a brain scanner to devine your exact needs !​

​

So you should do it on your own by using the macro recorder …​

​

 

[Abhijeet R. Joshi]

Hi Sandip,

Welcome Onboard..

You can use the below....But I recommend you go thru some tutorials to have enough knowledge of VBA prior to working on VBA..

varfile = ActiveWorkbook.FullName
pth = Mid(varfile, 1, InStrRev(varfile, "\", Len(varfile), vbTextCompare) - 1) & "\"
Workbooks.Add
ActiveWorkbook.SaveAs pth & "1234.xls"

Moreover, to copy the range you need to mention what you want to copy and where you want it to be pasted,etc...