New answers tagged

2

I'm pretty sure its one of your card reader slots that's Q:, it's just labelled wrong due to Office being previously installed. You should be able to change its label by heading into the registry to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\DriveIcons\Q, and then editing the (Default) setting in the DefaultLabel sub key. Not ...


0

This is a "USE AT YOUR OWN RISK" solution. Download the Click-2-Run removal tools from KieSeyHow's skydrive below http://sdrv.ms/11hV2PR Unzip package Run offcln.exe Reboot Run CleanC2R.exe Reboot I ran the exe's on my win 7 comp without issues. I also scanned them for viruses, they are clean. That being said, they are not verified and supported by ...


0

I assume this is not a real space. If this is a real space character the below answer is not relevant. I don't know the reason this happens, but I have found possible workarounds. When I copy/paste the text to a brand new document the space around reference disappears. Another method I found is to save the document in Word 97-2003 format (DOC), and then ...


-1

I think the following link will be helpful trying to figure a solution for yourself. Userform startup position - MrExcel A couple of suggestions that are given there: Base the position of the userform on named ranges in your Excel workbook Place the UserForm window in a specific position in relation to your Excel-program every time it loads or activates.


0

The Office "Online" applications are basically crapware. They are "light" versions of the full install applications. They are adequate for creating simple documents and viewing or doing simple edits of documents created on full versions of the application. They are missing most features. Specifically, they do not allow you to change font substitution nor ...


1

If sh1.Range("A" & RowNum : "O" & RowNum).interior.color = rgb (127,187,199) is the actual line from your macro, you have a typo sh1.Range("A" & RowNum : "O" & RowNum) should be sh1.Range("A" & RowNum & ":" & "O" & RowNum) The colon : needs to be concatenated like everything else, since it's part of the range string


2

First thing I would recommend is to enable "Track Changes" under the "Review" tab in Word. When this is enabled, edits made by different authors (as specified in the Word options) will be highlighted and can be searched easily using the "next change" option. With "Track Changes" enabled, you should have an easier time when trying to merge manually. This is ...


0

You can use a screen recording software to record the presentation, use softwares like iMovie to edit it, and burn the movie with whatever app you like. But honestly, it'd be better if your friends see you do the presentation in front of the screen, so maybe use a DV to record it. And finally, this is really a elementary question. (Do you know that Apple ...


1

You have several options: Create a GIF. You can use an online tool for that, just google "gif creator" or something similar. High loss of quality and limited control on the final result, but fairly simple. Put all the images in the same slide and use animations and timing to have them appear & disappear accordingly. Quite the hassle to set up and ...


0

In Windows, just add ".zip" as a filename extension and you'll be able to open in in Microsoft Office. See here for more details: http://osxdaily.com/2014/07/16/open-pages-format-file-in-windows/


0

Use the Consolidate feature to "summarize and report results from data on separate worksheets, you can consolidate the data from each separate worksheet into one worksheet (or master worksheet)". This feature is found in the Data Tools group on the Data tab. Sounds like your data is formatted the same on each sheet, so you should be able to consolidate ...


2

I've had a spare virtual machine at hand with Office 2007 installed on it and fully updated, so I've decided to create a snapshot, uninstall Office and see what happens with Office updates. Here's a screenshot before doing anything. Note that total number of updates is 59. Here's the same window after uninstalling Office and rebooting the system, 20 ...


0

The updates still remain on your system. They are located in a sub-category as shown. View Installed Updates


0

It sounds like a corrupt installation. Try uninstalling and reinstalling and see if it resolves your issue. If you have other versions of Microsoft Office installed, I would uninstall those first before reinstalling. I've had trouble with having multiple installations of Microsoft Office on the same machine before.


2

Nothing is going to do (c) (automatic update) without some help. The simplest way to achieve almost everything else is to put all your shared material in a single document (or in fact, you could use multiple documents). Bookmark each item. To use the item in a "client" document, use an INCLUDETEXT field that specifies the fullname of the document and the ...


1

PowerPoint has no method for doing this. Something similar could be accomplished using a bit of VBA (ie, a macro), but it wouldn't be a beginner project to write such a thing. If you'd like to have a go at it, I can outline how you might go about getting started. Then if you run into difficulties, pop back into StackOverflow.com with your code, a ...


0

Based on Inigo, Duncan and Maria's answers, this works for shapes, tables, groups, SmartArt: Sub ChangeProofingLanguageToFrench() Dim j, k As Integer Dim languageID As MsoLanguageID 'Set this to your preferred language languageID = msoLanguageIDFrench For j = 1 To ActivePresentation.Slides.Count For k = 1 To ActivePresentation....


-1

I fixed the problem by going to Tools/Language, then selecting English (US), then I unchecked Do not check spelling or grammer. Unfortunately, I did have to do it for each table in my Word doc, but it worked and I am now happily checking my spelling as I type.


0

There is no direct way to delete only the empty text boxes in PowerPoint, but you can use a macro instead. Open your PowerPoint presentation and press Alt+F11. The VBA window will appear. Insert -> Module Copy&Paste the code below. Sub RemoveTextboxes() Dim SlideToCheck As Slide Dim ShapeIndex As Integer For Each SlideToCheck In ...


0

Select items for action \ deletion: this can be done with ether CTRL-A or you can select items within a square box using your mouse (hold down the left button). Then punch DEL


-1

Use a program called NEWT Professional. Great for an Audit Can tell you pretty much anything remotely. http://www.komodolabs.com/product-downloads/


2

I've created a vbscript based on an earlier out-of-date version of DSCunningham to manage that job. Enjoy! '========================================================================== ' ' VBScript Source File 2.0 ' ' NAME: PingSweep-OfficeVersion2.vbs ' ' AUTHOR OF THE FIRST VERSION: DSCunningham 08/03/2011 ' AUTHOR OF THE SECOND VERSION: Laurent Mander 07/...


0

In addition to answer provided by Mastergalen and to address comments regarding newly type text: If you will notice, that language will automatically change back whenever you start to type new text (which is very annoying), you have to change current default language for PowerPoint: make sure PowerPoint window is an active window in the Windows Taskbar (...


1

After hours of frustrated research, the only fix I found is to create a new category with the EXACT same name as the unwanted category. This assigns the unwanted category a color, and you can then delete it. Not sure how technical of a fix this is, but it will get unwanted categories out of your navigation pane. Hope this helps.


0

Why pay for Omnipage final when an OCR text scanning software package comes bundled with Microsoft Office 2007, 2010, 2013 and 365? A friend of mine discovered that his Microsoft Office installation doesn't have OCR Document and Imaging. This is often not true, the matter is attributable to the default installation with Microsoft Office, the OCR Document and ...


0

Alternatively use AutoHotkey (https://autohotkey.com) with the following script block. This filters to only apply the shortcut if OneNote is active and in this case detects CTRL + SHIFT + V and translates it into ALT + H V T for paste keep text only. #IfWinActive ahk_exe ONENOTE.EXE ^+v:: SendInput !hvt Return #IfWinActive


0

A macro from ExtendOffice to save the tabs in your Documents folder: Sub ExportSheetsToCSV() Dim xWs As Worksheet Dim xcsvFile As String For Each xWs In Application.ActiveWorkbook.Worksheets xWs.Copy xcsvFile = CurDir & "\" & xWs.Name & ".csv" Application.ActiveWorkbook.SaveAs Filename: = xcsvFile, _ ...



Top 50 recent answers are included