Opening Word (from Outlook VBA) in Safe Mode -

-

i have word document attachment email need data out of pass url. i'm saving attachment local temp file, opening document, , using word object model pull data out of tables in document.

i'm having couple of problems when opening document in vba: firstly it's slow because have corporate macro stuff loads when word opens; , secondly if there messages ping when word opens (such document recovery stuff), code hangs , word never closed.

so, question can open word in safe mode vba nothing bare bones document available (because that's need)? or, there better way of controlling word gets around issues i'm having?

perhaps use shell open in safe mode, say:

"c:\program files\microsoft office\office11\winword.exe" /a

then use getobject instance.

more details:

dim wd object dim strword string, strdoc string dim intsection integer dim inttries integer      on error goto errorhandler      strword = "c:\program files\microsoft office\office11\winword.exe"     strdoc = "c:\docs\adoc.doc"      shell """" & strword & """ /a", vbminimizedfocus      ''set focus other word document     ''see http://support.microsoft.com/kb/238610     forms!myform.setfocus      intsection = 1 ''attempting getobject...     set wd = getobject(, "word.application")     intsection = 0 ''resume normal error handling      wd.documents.open strdoc      ''code here      set wd = nothing      ''exit procedure:     exit sub  errorhandler:     if intsection = 1         inttries = inttries + 1         if inttries < 20             sleep 500 '' wait 1/2 seconds             resume ''resume code @ getobject line         else             msgbox "getobject still failing. process ended.", _                 vbmsgboxsetforeground         end if     else ''intsection = 0 use normal error handling:         msgbox error$     end if

for sleep, needs go @ top of module:

private declare sub sleep lib "kernel32" _     (byval dwmilliseconds long)

/a starts word , prevents add-ins , global templates (including normal template) being loaded automatically.

the /a switch locks setting files; is, setting files cannot read or modified if use switch.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more