Home |
Search |
Today's Posts |
#1
|
|||
|
|||
[newbie] better vba coding
hi i've setup a word template (working fine), which reads data from an excel file. my problem is that its not the fastest process. some formfields that read data and read/write data to an excel file on enter/exit events please bear with me as i'm new to vba coding. currently, i've separated all initialisation (of excel) for each code execution event i think the most time is wasted by the CreateObject and opening workbook lines. i thought of using GetObject instead of CreateObject but there's no guarantee that excel would be running at the required time. please give me some good ideas on how to make this more efficient. riyaz |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
[newbie] word counts.. and excluding stuff.. | Microsoft Word Help | |||
Complicated mail merge with html coding | New Users |