ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a new excel file from an existing file using macro (https://www.excelbanter.com/excel-programming/335771-creating-new-excel-file-existing-file-using-macro.html)

Macro

Creating a new excel file from an existing file using macro
 
Hi, I never did any macro before. I need to have a macro that will
capture some specific cell/rows and save/create those info in to a new
excel file. Is that possible? Please help!


Ron de Bruin

Creating a new excel file from an existing file using macro
 
Hi

Yes you can do this

Here is a mail macro that send the selection
http://www.rondebruin.nl/mail/folder1/mail4.htm
You can delete the mail part

If you need more help post back



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Macro" wrote in message oups.com...
Hi, I never did any macro before. I need to have a macro that will
capture some specific cell/rows and save/create those info in to a new
excel file. Is that possible? Please help!




jose luis

Creating a new excel file from an existing file using macro
 

Try to Record a macro, (Tools/Macros/Record) do what you need and then
look at the code in the Visual Editor.

Jose



Macro Wrote:
Hi, I never did any macro before. I need to have a macro that will
capture some specific cell/rows and save/create those info in to a new
excel file. Is that possible? Please help!



--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=390943



All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com