Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default macro for processing one excel file and saving it to other


can a macro pick up data from one file,process it in a certain way and
then put the output back to an excel file.
i need help with how to do it
thanks


--
shwetaparekh
------------------------------------------------------------------------
shwetaparekh's Profile: http://www.excelforum.com/member.php...o&userid=27692
View this thread: http://www.excelforum.com/showthread...hreadid=472193

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 692
Default macro for processing one excel file and saving it to other

For most files - this is very possible.

A lot depends on what kind of file is holding the data.
If it is another Excel workbook - it's just transferring cells, worksheets,
etc. Very quick and relatively easy.

If it is a text file or a database file - you will have to import it into
Excel. Relatively easy.

Once you get it into excel you can do just about anything you can dream up.

But we need more info and what is what, and where to where, and what you
want to do.

Post back and we'll work with you...

--
steveB

Remove "AYN" from email to respond
"shwetaparekh"
wrote in message
news:shwetaparekh.1w6ref_1128107133.3606@excelforu m-nospam.com...

can a macro pick up data from one file,process it in a certain way and
then put the output back to an excel file.
i need help with how to do it
thanks


--
shwetaparekh
------------------------------------------------------------------------
shwetaparekh's Profile:
http://www.excelforum.com/member.php...o&userid=27692
View this thread: http://www.excelforum.com/showthread...hreadid=472193



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
Excel 2007: Saving a file with a Macro Gary Excel Discussion (Misc queries) 1 April 28th 10 03:13 PM
Saving a copy of excel file in macro but have it auto write pano Excel Worksheet Functions 4 March 27th 07 11:54 PM
Saving text file in excel format through macro... Trevor[_4_] Excel Programming 3 June 14th 04 06:24 PM
how to run recorded macro without showing processing excel sheets christine Excel Programming 10 January 4th 04 10:57 PM
Saving an Excel file as a CSV using a Macro doug Excel Programming 2 July 24th 03 03:00 PM


All times are GMT +1. The time now is 03:14 AM.

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

About Us

"It's about Microsoft Excel"