Hot answers tagged

52

Thanks to the link posted by harrymc, I spent almost a day investigating this problem and figured out it was Windows Server 2008 default domain policy. I suspect this problem only applies to Windows PC in a domain network environment. The default domain policy doesn't allow user to install additional certificate to Trusted Root Certification Authorities, ...


43

On Windows7 the VPN settings are stored here: C:\Users\<username>\AppData\Roaming\Microsoft\Network\Connections\Pbk So I copied the .pbk file to my other computer and opened it on there, and I managed to successfully connect to the VPN.


31

This is definately a kluge and it's the only thing I've figured out to do. I came here looking for a more elegant solution. I do have a slight improvement for this. Paste the data into the spreadsheet as is. Select all and format as text Paste again over what you did the first time but this time as values. This keeps you from having to count columns and ...


27

For Microsoft Windows OS, default Storage is in %HOMEDRIVE%%HOMEPATH%\VirtualBox VMs Which typically expands out to C:\Users\[username]\VirtualBox VMs The subfolders will be named with the Name: field contents entered in the Create Virtual Machine dialog where you're asked to enter Name and OS information. If you've decided to do a little more ...


22

The issue was explained here in the GnuPG bugtracker; I did not see that earlier today. The solution is: gpg2 --batch --import ~/.gnupg/secring.gpg


21

Convert the .eps file to .emf (Enhanced MetaFile, a spool file format used in printing by Microsoft software). There are several ways to do this conversion; for example by using the following webservice: https://cloudconvert.com/eps-to-emf In my experience, .emf files are the only way to reliably embed vector graphics in several Word versions on Mac and ...


19

The Most simple way. 1. Copy the original Data 2. Paste to Notepad (Prefer Notepad++) 3. Change the Cell Properties to TEXT 4. Copy All from Notepad 5. Paste back to Excel.


19

On your Windows 7 machine, navigate to the following folder: %AppData%\Microsoft\Sticky Notes Save the StickyNotes.snt file found within to an external backup device. On your Windows 10 machine, close all instances of Sticky Notes and open the following folder: %LocalAppData%\Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState Create ...


18

Current user: %AppData%\Microsoft\Network\Connections\Pbk or shared with all users: %ProgramData%\Microsoft\Network\Connections\Pbk


16

There is a weird bug in Excel. I'll explain here how to avoid (not fix, just avoid) it, and maybe it will fixed soon by MS Office programmers. Maybe it even WAS fixed in Excel 2013, I did not open it yet. So, this is the problem. The maximum length of the text cell is 32767, and it's OK. The maximum length of the number cell is 255, and it's OK. But if ...


13

Text to columns (in data tab) have almost the same functionality than your "import from text file has". You can split the text to columns by fixed length or at separators, select data type for each column...


11

Enable password export in Chrome by going to chrome://flags/#password-import-export, then you can export it to CSV file. Source: How to Export and Import passwords in Chrome browser.


11

This problem has been plaguing me for a number of years. I just discovered the solution and it's alluded to in the answers above but not explicitly spelled out. It's the space after the comma! This doesn't import into excel; HEADER1, HEADER2 "1,000", "2,000" While HEADER1,HEADER2 "1,000","2,000" Works!


10

You can also use this standalone tool called chromepass http://www.nirsoft.net/utils/chromepass.html ChromePass is a small password recovery tool that allows you to view the user names and passwords stored by Google Chrome Web browser. There is a option to export into your keepass password manager too. Note: If you feel unsafe to use third-party tools, ...


10

Before pasting, select column that will hold the non-date value. Right click. Select 'format cells'. Then select 'text' as the format and click OK. Now, go ahead and paste, but paste using the 'match the destination formatting' option.


9

The procedure is like this: (Parallels Desktop 12) 1) Prepare the Parallels VM by removing the Parallels Tools and anything that is “special" (mounts, shared folders, etc).. sudo /usr/lib/parallels-tools/install -r 2) Copy the HDD file from inside the PVM OS X package into the open file system (Finder, Right Click, Show Package Contents). Generally, the ...


8

If you simply insert the .eps file in word as an image it will look bad in Word, but when you print it to paper it will utilize the vector graphics and it looks fine.


8

Following procedure works: Turn off synchronization (Chrome menu > Signed in as > Disconnect your Google Account (do not forget to keep Chrome data saved on the computer) Close Chrome Replace Bookmark file in Chrome's User_Data folder with your own version Open Chrome Export your bookmarks as HTML (Chrome menu > Bookmarks > Bookmarks manager > Organize > ...


7

Change the .RefreshStyle = xlInsertDeleteCells to .RefreshStyle = xlOverwriteCells and it will replace the cells with the data from the file. This forces the refresh to replace the data in your table to be up to date with the text in the file.


7

First of all, you're doing a kind of "no-op". gpg is still GnuPG 1.4.20 on Ubuntu 16.04, while gpg2 made a jump from GnuPG 2.0.28 to 2.1.11. Then, while GnuPG 2.1 made some changes to the file formats (new keystore format "keybox"/.kbx and merging the secret keyring into the public one), it is still compatible and will do the secret keyring merging upon ...


6

I was unable to make Chrome and Firefox restore my bookmarks from the Bookmarks or Bookmarks.bak json files. But I found this really helpful online tool to convert those json files to an HTML file that you can then just import via the top-right corner in the chrome://bookmarks/ screen: https://rongjiecomputer.github.io/chrome/bookmark-recovery/#windows


6

Here is an up-to-date method answer: Export from Lastpass: Open your Vault Click on the three dots (More Options) in the bottom left corner and then: Advanced > Export Save the .csv file Import into Firefox Lockwise (source: https://www.reddit.com/r/firefox/wiki/switching-to-firefox#wiki_importing_passwords) Navigate to about:config in the Firefox URL ...


5

I found a decision how to show all your passwords from Chromium. Tested on Ubuntu 14.04 and Chromium: Version 40.0.2214.111 Ubuntu 14.04 (64-bit). I used js script found early in search. Output maked in format: url|login|pass Steps: Open in Chromium browser link to Chrome password manager: chrome://settings-frame/passwords Open console (F12) and insert ...


5

For years I've struggled with the same problem: Screenshots inserted via Cut&Paste (or Word's own function "Insert screenshot") sometimes get blurred, sometimes not. But it seems I've found a stunningly simple solution now (Windows 7, Word 2013): Switch your document to Print Layout (View->Print Layout). Set the zoom level to 100% (View->100%). Paste ...


5

Excel will auto-detect the format of a CSV field unless the CSV column is in this format: "=""Data Here""" This also works for Google sheets


5

At the risk of being scolded for not answering the EXACT question... On Ubuntu (and other Linux distributions?), the directory is: /home/[USER NAME]/.config/VirtualBox


5

Here is a simple python script to transform the export into import.csv file="Export.csv" print(""" "hostname","username","password","formSubmitURL","httpRealm","usernameField","passwordField" """ ) for line in open(file): l=line.split(',') first, rest = l[:1], l[1:] url=l[0] if url=="http://" : url = url + l[4] print('"'+url+'",'+'"'+l[...


5

Alternatively, if you have the text data on your clipboard, you can Use Text Import Wizard...  (I've confirmed that this works for Excel 2010+; not sure about older versions.)


5

It seems these temporary images are originating from the LPE folder. Basing on the explanation give on this answer: The LPE folder is used by Samsung's Camera and Photo Editor apps. The files inside are photos in a raw format. If you open the file in photoshop, you can make out the image somewhat. The specifics of the image bit orders are not known....


4

Excel treats numeric values starting with a tab character as text. <tabchar>000000100000200000,ABC,DEF Will appear as: 000000100000200000|ABC|DEF | is the cell boundary(for illustration purpose). So, for example, if your system generates the CSV file using utf-8 charset, you can add the &#x0009; (Tab Char in Hex) before your numeric value to ...


Only top voted, non community-wiki answers of a minimum length are eligible