Reputation
12,637
Next tag badge:
114/100 score
11/20 answers
Badges
5 36 81
Newest
 Altruist
Impact
~1.6m people reached

2h
comment Windows 7 - What is “Date Created” file property referring to?
Please explain why you added those images. I don't see how they are related to your question. Pick one image
2h
comment How to keep history of data changes in one excel workbook or sheet to another workbook or sheet
You might want to check your server certificate since chrome complains: This server could not prove that it is www.officeautomata.com; its security certificate is from *.squarespace.com. This may be caused by a misconfiguration or an attacker intercepting your connection.
2h
awarded  Altruist
2h
comment How do priorities work on task-manager and when should/n't I set this?
Worth a bounty. I learned something
3h
comment How to create a desktop shortcut to an MTP folder?
Related: How do I access MTP devices on the command line in Windows?. I googled around a bit to see if Powershell can utilize a Win32 class and somehow access the MTP device. No luck so far. Seems hard/impossible
4h
answered Moving foobar2000 to another drive (+ cant listen to previous music, + global hotkeys not working all the time)
4h
revised How to open the Save As dialog and save as PDF
added 24 characters in body; edited title
4h
comment Moving foobar2000 to another drive (+ cant listen to previous music, + global hotkeys not working all the time)
Please ask only one specific question per thread.
4h
revised How to count occurences of strings in a cell using VBA
added 7 characters in body; edited title
4h
comment VBA macro crashes when using variable Ranges instead of fixed ones
An On Error Resume Next without an On Error goto 0 is not good practice. Add it after the command which can produce errors. Also: Without a working Example sheet filled with data, I'm not able to reproduce anything and we can't help you further
4h
revised VBA macro crashes when using variable Ranges instead of fixed ones
added 109 characters in body; edited title
5h
revised Delete duplicates and keep the row with more data
deleted 1 character in body; edited title
5h
comment How to create a desktop shortcut to an MTP folder?
Erm, why should this question be off topic (not about computer hardware/software)? It's tagged with Windows and Shortcuts. It's a valid question as I see it
1d
answered Windows batch script to add new character into middle of filename
2d
comment Word exports empty non-working Bookmarks additionally to the working ones I generated
I just saw that you selected Create bookmarks using headings. But if there are already correct bookmarks set by your TOC, you should use them. Switch this option and see how it fits your needs
2d
comment Word exports empty non-working Bookmarks additionally to the working ones I generated
Does your word file has a table of contents with clickable (hold ctrl) hyperlinks? _Toc*** is an indicator for this. You can unlink them with Ctrl+Shift+F9
2d
comment Word exports empty non-working Bookmarks additionally to the working ones I generated
What do you see in Word when go to Insert tab, in the Links group and click Bookmark where you get a list of all bookmarks. Are there any unwanted bookmarks? Note that there is an option to view hidden bookmarks
Aug
30
revised video player that shows milliseconds
added 118 characters in body; edited title
Aug
30
answered video player that shows milliseconds
Aug
30
comment Splitting an excel 2010 spreadsheet into multiple workbook files based on column value
It's always nice to see SQL in VBA. But I haven't understood your example yet. Where does the user select at which destination XLS the record should go? Something like the country name or in your example Book1. Oh, and a +1 is the minimum for your effort