Keep source column widths: Preserves the column widths as well as all formulas and formatting. Formatting only: Pastes only the formatting, leaving all values and formulas out of the pasted range. Link cells: Links the pasted cells to their original location.

Click to expand.So. Sub testwidth() Sheets('sheet3').Activate screenres = 96 '96/inch mypoints = Sheets('sheet3').Range('A1').Width '> returns 48 points mychars = Sheets('sheet3').Range('A1').ColumnWidth '> returns 8.43 chars mypixels = (mypoints / 72) * screenres 'pixel width of column Debug.Print mypoints, mychars, mypixels '> returns 48 8.43 64 End Sub The column width is 48 points or 8.43 characters or 64 pixels.

I couldn't get ActiveWindow.PointsToScreenPixelsX to return anything but zero. Hello John, all Thank you very much for your reply. It works like a charm The ActiveWindow.PointsToScreenPixelsX returns zero when the cell is not visible (for example when the vba editor is in front of the worksheet). Any sollution with the ActiveWindow.PointsToScreenPixelsX would have required that the workbook and worksheet is visible and on top of all other windows, but your solution is much better.

The behavior of Excel when opening CSV files heavily depends on your local settings and the used list separator under Region and language » Formats » Advanced. By default Excel will assume every CSV was saved with that separator. Which is true as long as the CSV doesn't come from another country! If your customers are in other countries, they may see other results then you think. For example, here you see that a German Excel will use semicolon instead of comma like in the U.S To confuse you even more, that setting interferes with the decimal symbol which can be separately set up under Excel Options » Advanced » Use system separators or via regional settings as shown above.

A script that downloads Microsoft Office 2016 for Mac installers from the Microsoft Office CDN and performs installation of each installer. The script is a modified version of another publicly available script as attributed in the script source. Vmware script for mac os x 10.6.8. One can acquire skills on Xcode and use the new features supported by Mac OS X El Capitan and most importantly installing Applications on OS X El Capitan on VMware without necessarily having to install it. Running the OS X El Capitan on VMware on PC maybe somewhat hectic and may probably take a toll on one’s additional energy.

Excel can't use the same symbol as decimal tab and list separator. It will automatically use comma or semicolon as a backup separator. I will take your example to create 3 files. Each with a different separator and open it with Excel.

COMMA SEMICOLON TAB Not the same as your Excel does? I thought so. So lets manually change the extension from the same CSV files to XLS and look what happens now. First, Excel will throw up a warning that the file extension doesn't match the content and Excel tries to guess whats inside.

COMMA SEMICOLON TAB Conclusion: TAB + renaming + ignore warning = Win on every system? Zotero mac safari. Maybe, but I wouldn't be so sure for customers outside your own country. The best method is to instruct your customers to first open a blank Excel and then go to Data » Get data from text and manually select comma as separator.

In the short term if you only need to open a CSV file that has been sent to you from another country - Open the file in wordpad and use find and replace to change every separator the issuing country has used (eg.;) and replace with a comma. Just check the issuing country does not use a comma in place of another symbol (eg in Spain they use a comma where we use a decimal place so you would have to find and replace the comma to a decimal place then find and replace the other symbol with the comma). Not a long term solution but good enough to make the file itself readable if you are in a hurry and can't access the control panel at work.