Tag Archives: windows

Windows().Activate works on every computer except one

Questions: I have encountered a strange problem, I made macro about a year ago and it is being used every month without problems. Yesterday my boss told me, he cannot use it anymore, that it gives him some errors. I now tried the macro on 8 computers and the macro ran perfectly. Why is it… Read More »

How to handle csv mime type on windows machine

Questions: I am using an angular-file-upload to upload multiple files.I have a filter that allows only csv files to be uploaded. However this filter fails on windows (chrome and firefox) as csv files exported from ms-excel have mime type as “application/vnd.ms-excel” instead of “text/csv”. How to handle this so that it works on cross-platorm and… Read More »

Excel 2003 on 64-bit Windows 7 automatically changes reference to SysWOW64\MSCOMCTL.OCX so 32-bit Excel complains

Questions: In an Excel 2003 VBA project I am using controls from MSCOMCTL.OCX. That is the VBA project has a reference to System32\MSCOMCTL.OCX. When I open that project in Excel 2003 on my 64-bit Windows 7 system, Excel automatically changes the reference to SysWOW64\MSCOMCTL.OCX (which is the correct location). However, when I send that project… Read More »

MS Access 2010, Excel 2010, Windows Server 2008 R2 64-bit: SaveAs method of Workbook class failed

Questions: Services used: MS Access 2010, Excel 2010, Windows Server 2008 R2 (64-bit) In our MS Access database, we wrote a process that exports queries to .xlsx format and saves them on the network drive. It uses this syntax: objxl.ActiveWorkbook.SaveAs filename, FileFormat:=xlOpenXMLWorkbook and xlWBk.SaveAs filename, FileFormat:=xlOpenXMLWorkbook where objxl is declared as: Private objxl As Object… Read More »

Excel VB Open File OSX and Windows

Questions: I’ve got a spreadsheet that uses some basic code to get the user to select a file (txt file). It works flawlessly on Windows but fails on OSX obviously due to the difference in FileDialog calls. I’ve done some research though and can’t seem to find much information about opening a File Dialog on… Read More »

Copying arabic text in Windows

Questions: I have translated Arabic content in Microsoft Excel. Whenever I am copying it to my WordPress site with Polylang Arabic language support, the letters get messed up like this: الهاتف (اختياري) Although the original text was like this: I’m using Windows 7 with Office 2010 and this applies to every application I want to… Read More »