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
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
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" <shwetaparekh.1w6ref_1128107133.3606@excelforum-nospam.com>
wrote in message
news:shwetaparekh.1w6ref_1128107133.3606@excelforum-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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks