Hi Folks, The situation is - When we start the server, bmp images and text is downloaded dynamically(run time) to a folder, and are pasted to microsoft word. This is a continuous proces, which means the bmps and text gets downloaded from another server and is continuously pasted in the Word. This goes on till the time the size of the document reaches above 512 MB. By default Word can handle 512 MB, anything above it closes with an error. Now the idea is to convert the bmp into jpeg(I have the code for this) and after any of the page pastes the bmp, the execution need to stop(I need help here.. what event should i fire to stop it on a page) and my code needs to convert the inline bmp into jpeg(i have the code for this) and then the processing needs to resume. http://msdn.microsoft.com/en-us/library/office/aa221371(v=office.11).aspx According to the above VBA for word has 27 events - I tried using "DocumentBeforeClose Event" but the problem is before this event is called Word reaches above 512 MB and crashes on it own. Then I thought of "WindowActivate Event" to stop the execution at an open window(page) and then my code converts the inline bmp image to Jpeg. But this did'nt help Appreciate any inputs !
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
