Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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!

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import data from txt file to an existing excel file shaji Excel Discussion (Misc queries) 1 September 12th 09 04:15 PM
User replaces existing file with blank during file open sjs Excel Discussion (Misc queries) 3 August 18th 08 06:16 PM
Importing text file, only option to edit existing file smokey99 Excel Discussion (Misc queries) 8 April 26th 06 09:08 PM
can i save an existing .xls file as a .csv file using command line craigkan Excel Discussion (Misc queries) 2 February 18th 05 02:01 PM
get path - save new file - same sub-directory as existing file tegger Excel Programming 2 October 21st 03 10:45 AM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"