Make csv files dependant on user windows settings such as semi-colon when saving using save as csv in VBA2 votes
make vba read dates the same format as in windows user region settings, currently dates in VBA work only for US format2 votes
Currently, if I write a UDF in VBA, I can arrange that the user sees help for that function in the Excel “Insert function” dialog box by using Application.MacroOptions. I can also hook the “Help on this function” link of that dialog to a help topic in a help file.
But I don’t think Application.MacroOptions lets me hook “Help on this function” to a web page. My suggestion is to make that possible please.5 votes
If you have any personal macros (or even a macro worksheet in your XLSTART folder), PowerPivot and Power Query both break—it's been a big bummer having to get rid of all my old macros to use my data models.3 votes
It would be so handy if one could check the status of the password setting of the VBA code in Workbook_Open() and reapply it if the password has been removed. That way only if you know the password can you unlock it in the VBA editor.4 votes
Range.Find modifies the settings in the Find dialog of the UI.
The default setting of LookAt in the UI is xlPart, but in VBA we usualy use xlWhole:
MyRange.Find(What, LookIn:=xlValues, LookAt:=xlWhole)
We need a function the get (all) the search settings, so we can backup the settings before we execute our macro. And when we are finished we need a function to restore the settings.2 votes
- Don't see your idea?