Excel 2016 64-bit Crashes (Seems to be caused by Macros)
We use the MSO version, not Office 365. There was a rather simple fix that other readers may wish to know. If you open the workbook in Excel 2013 and save the macro workbook as xlsx …
Ms Office Excel 2016 APPCRASH When Open Microsoft Excel …
1. Open the workbook in Excel. Normally Excel will disable macros in a worksheet until you click a button to enable the macros. Do not enable the macros just yet. 2. Open the VBA editor. You …
Microsoft word 2007 (randomly) creates a Temporary file and a …
The problem lies with microsoft word 2007 when using the save as option (we use it programmaticly in vba), it sometimes creates a XXXXXXX.tmp file and not the filename we …
Word 2016 Index shows incorrect page numbers only when using …
I believe I have encountered a bug in how Word determines page numbers when it builds an index — but apparently only when it is using an OpenType CFF type of font and when the …
Extract email from Word doc - social.technet.microsoft.com
The following sample will show you how to get the email address from the table in Word document, and out put to the Excel workbook. Put the following code into Excel VBA project …
Disabling the "Do you want to disable macros" Prompt When …
I want the file to open, and run its macros WITHOUT me (and other users of this workbook) seeing these annoying multiple prompts. Actually I would be happy if the workbook opened …
Microsoft 15.0 Object Library issues - Excel instant crashes
I have had countless issues with my excel files working fine and then at some random reason excel crashes whenever I try to save or mostly even just open the file. The reason always …
Mailmerge Database Access read write issue on migrating to 64bit …
1) Open the Excel database directly to check if the file is occupied by other user/program process. 2) Create a test excel database locally on the system and then try to perform the mail-merge …
Losing settings and formatting when copying Excel files to new …
Based on your description, at first you copied the .xlsm file from old computer to new computer but you can't open it. Then you solved this issue by copying personal.xlsb to the new computer …
How to search and replace a string in Excel Shape (textbox) using ...
Aug 27, 2014 · I have been asked to write a PS script to search/replace a string when found in Excel Shapes when they are textboxes. I have seen lots of simplistic PS scripts and even I can …