You could also use the macro recorder, which you probably know is a good way to learn VBA. The only piece of code that you can't get by the recorder is the first line that you'll need before you open the workbook:
Application.ScreenUpdating = False
Dave Gathmann
--- In ExcelVBA@yahoogroups.com, Girish <girish_punch@...> wrote:
>
> Hi Hafizullah,
> Â
> Thanks for Reply. Can you please send me code for this.
> Â
> -Girish
>
> From: Hafizullah <hafizullah@...>
> To: ExcelVBA@yahoogroups.com
> Sent: Wednesday, 1 June 2011 3:29 AM
> Subject: [ExcelVBA] Re: Enter Values to Closed Wrkbk
>
>
> Â
> The workbook will have to be opened to modify it. However, it is possible to do this without the user seeing it happen.
>
> Hafizullah
> @}->-`-,---
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar