4,771 reputation
1952103
bio website security.stackexchange.com
location Florida
age 32
visits member for 4 years, 4 months
seen yesterday

I'm not the droid you're looking for.


Oct
7
revised Windows search using file version field
added 1 character in body
Oct
6
revised Windows search using file version field
added 21 characters in body
Oct
6
answered Windows search using file version field
Oct
6
comment Windows search using file version field
@elderelder I'd hardly call it a "Hack" in PowerShell. I'm pretty sure it's a standard property of file objects that support it.
Oct
6
comment How did the Marriott block wifi hotspots?
It's really too broad of a question to be good for anywhere in StackExchange. Layer 1 jamming would be the most effective, but would mean that other hotspots sharing the channel your APs use would have to be left alone and you'd still have considerable cross-channel interference from the jammers. Spoofing deauth packets would let you target same-channel hotpots without significantly impacting your own, but I'm not sure how it would keep users from being able to see their own hotspots - certainly, they might not be able to join them but they should still be able to see them.
Oct
6
comment Is there a way to use Regex( or comparable solution) in Excel formulas?
I think we need to know a bit more about what data you're looking to match and how you're going to use it, and what the "data" cells will normally look like. Depending on those parameters, matching could be done to be as simple as "this line contains a stock ID (TRUE/FALSE)" or "this is the stock ID on this line".
Oct
3
comment How to find and replace text in embedded excel spreadsheets in word?
This is incredibly vague, and currently impossible to answer. At the very least, we'll need some samples of the data you're looking to change and an idea of how you're wanting to change it.
Oct
3
answered Editing every cell in an Excel sheet
Oct
2
comment Excel, using cell text references as input for formula
Short, incomplete answer: I think you need to familiarize yourself with the Excel naming conventions for references that cross between sheets and/or workbooks. Then, fix your formula with INDIRECT and CONCATENATE. However, I'm a little unsure that I properly understand your problem. Can you re-phrase/re-format your post to be less wall-of-texty, and perhaps include some sample data and expected outputs? Also include what formula(s) you're currently using which apply to this problem.
Oct
2
comment Can I disable the warning when a group policy restricts program execution?
@trlkly Fair point. But on a managed system, you should have users see this also. It means either that something legitimate didn't make it into the whitelist, and so some functionality is probably broken that shouldn't be, or some unauthorized software has been installed and sysadmins need to be quickly notified. Event log review/alerting is great, but a user who's gotten a scary-looking notification is usually going to draw attention & action faster. You want that in the case of a possible security incident.
Oct
1
revised What is shell-shock and how does it effect me?
added 598 characters in body
Oct
1
answered What is shell-shock and how does it effect me?
Oct
1
comment How to connect 100 bluetooth devices to a single pc
If nothing else, you're looking to create a metric crap-ton of RF noise with all those devices paired (I'm assuming most, if not all, will also be concurrently active) at once. Keep in mind that Bluetooth operates in the same band as 802.11b/g/n, as well as many wireless phones and many other intentional and incidental RF emitters.
Oct
1
comment Cannot load router interface in Win8.1, even though ip address, DNS, etc all set correctly
Also, until you've established access to the web interface, all troubleshooting should be done via a wired connection with WiFi on the laptop turned off. This eliminates potential interference from two possible issues: 1.) You may be inadvertently to the wrong WiFi network. 2.) Your router may be configured to disallow admin access over WiFi.
Oct
1
comment Cannot load router interface in Win8.1, even though ip address, DNS, etc all set correctly
It's possible, however generally unlikely, that your router's web address might be hosted on a different IP than the primary gateway service. Try 192.168.1.254, like @happy_soil suggested. Also, have you tried both http:// and https://? Have you tried using different browsers? Have you tried running those browsers in "Safe Mode" (not Windows' Safe Mode - the browser's Safe Mode, where all plugins are disabled)? What error(s) do you see when trying to navigate to the web interface? Output from ipconfig -all, route print, and tracert 8.8.8.8 could be useful.
Sep
30
awarded  Explainer
Sep
26
comment Importing multiple CSV files
Please provide some example sheets so we have an idea of the data you're trying to work with. I'm not sure if Excel has built-in user-friendly features that can help with this, but it might be something that can be done with VBA or PowerShell.
Sep
24
comment Appending Year to Excel Date
If they're formatted dates, the last bit of my solution might not work - it assumes they're string values. Let me know if it's broken and I'll look into what's needed to fix it. Or, if you manage to fix it yourself, please let me know what you did.
Sep
24
revised Appending Year to Excel Date
added 748 characters in body
Sep
24
answered Appending Year to Excel Date