ANmarS - Search results

Excel/VBA expert since Sep 1997 (19 years 6 months)

18 Blog posts tagged with pc


Wed
Oct 26
2016

Frequent quick copy or Move



To copy quick to a certain location without jumping to copy and paste I usually get files in certain location, and most of the time want to move/copy them into same destination location A quick way to do that, is creating shortcut to that destination folder inside the source folder. Then when I want to copy/move a file, I just drag that file from the source folder (with CTRL to force copy, with Shift to force move) into the shortcut And it will be moved/copied as I intended to :-) Read more >>>

Wednesday Oct, 26, 2016 8:23
Tue
Oct 25
2016

Easiest way to unprotect Workbook or Worksheet without password


Looks like there is a bug in new Excel dealing with old Excel files
Tried that several times and it worked every time, it did actually remove the password for protected view of Worksheet and Workbook, it did not remove the protection, just the password.

So, If you have xlsx or xlsm with Workbook view or Worksheet view protected, do the following:

  • Save it as xls
  • Save it back as xlsx or xlsm
  • Now try to unprotect workbook or worksheet
Read more >>>

Tuesday Oct, 25, 2016 8:40
Wed
Apr 27
2016

My #LinkedIn #password



f(x) = Secure Strong Password

Having same exact password for multiple sites or logins is really something you should not do, am sure you already know that.

Having multiple passwords on the other hand is something you can easily forget, it is becoming very hard to remember which password goes with which? What was the password you created for this login?

Some folks (including me) used to have a list of passwords, but now you need to maintain it, update it, etc. again more pain

I used to have a list of my passwords saved in an Excel sheet, but after awhile it started to consume time just to maintain it.

So. Here is something I have been doing for few years now, and thought I can share the idea

Hint: Password function

Read more >>>

Wednesday Apr, 27, 2016 14:24
Thu
Nov 28
2013

LEGO again

Back to my hobby again, LEGO
After one year living in a small house, we moved into a bigger one.

Now I have my own LEGO place, I am back, have tons of pictures for my collection.

The important part is that I am now submitting my creations to LEGO CUUSOO website.
Read more >>>

Thursday Nov, 28, 2013 0:0
Tue
Feb 19
2013

Shutdown, restart, etc using shortcuts

Beow are the (Run) commands that you can create shortcuts to to shutdown, restart, hibernate and sleep your Win7. Where you can create shortcuts and double-click to run it:
Read more >>>

Tuesday Feb, 19, 2013 0:0
Sat
Feb 9
2013

Sites transfers and moves

Spent few hours (when was trying to fix one of my clients email issues) into moving most of my sites to my own server.
This was prepared for few weeks now, in addition to my client sites, I also moved File1.net, DCave.com, TrioCouture.com, VBAXLMan.com. Most of them were linked to this site.
The new challange now is to host email server on my own and start providing email services.

Saturday Feb, 9, 2013 0:0
Tue
Oct 2
2012

Send me a gift

Now you may send me a gift, I just started a project that I need some fund to do it, if you would like to send me a gift, please use the link below.

It is a BestBuy card, and I would love if you can contribute to it toward my project.



Thanks in advance

Tuesday Oct, 2, 2012 0:0
Fri
Apr 6
2012

Adding PHP+Wordpress on 1st Server

After few days of setting it up, I now have Microsoft SQL database along with MySQL database and PHP.
I needed also to install Wordpress, which I installed few hours ago.
I have these sites now on my own server:
- Uruk.us
- XLfxs.com
- ElizabethMaynard.com

These are the first three sites, in preparing to move in completely to host my own sites on my own server.

Friday Apr, 6, 2012 0:0
Tue
Mar 13
2012

1st own Server

Finally...!
I did it, I have now my own server, that is online, expandable to multiple sites, fast, and linked to certain IP.
IT took me around two months (actually around 36 hours) of trial and error attempts to work around the limitation of my ISP along with some resources online. Read more >>>

Tuesday Mar, 13, 2012 0:0
Sat
Dec 3
2011

Own server attempt failure

Attempt failed to establish my own server.
I was looking to a simple cheap easy-to-follow method to create my own server hosting my own website(s) on one of my machines, but it failed.
It is clear that the DNS/IP/CNAME settings where I don't have any experience in were the main thing against me. I tried to avoid that using No-IP.com or DNSExit.com with something called "cloaking" to stop showing IP to end user, but it wasn't what I am looking for. Read more >>>

Saturday Dec, 3, 2011 0:0
Mon
Nov 7
2011

Add event to Google Calendar with an email message

It has been a while since I start using Google Calendar (Since I got my Android phone), after few months of successful update and syncing between Google calendar and Outlook, I needed a quick way to add events to my Google calendar (Once added to Google, an app will sync it with my Outlook calendar).

This one will do that, an email address made specific for your calendar to add events to it. Read more >>>

Monday Nov, 7, 2011 0:0
Sun
Aug 8
2010

Another great application

Now this is another one, TreePad Lite

It looks like I am going to buy the full version, it has a lot of features

Read more >>>

Sunday Aug, 8, 2010 0:0
Thu
Aug 5
2010

Finally find it - LaunchBar Commander

It has been a while since I last explored and application, and when I do, I find the best one I was looking for.

It is LaunchBar Commander from DonationCoder.com

Read more >>>

Thursday Aug, 5, 2010 0:0
Sat
Jun 26
2010

New Clipboard software

This one sound promising, it has up to 25 slots for the clipboard plus easy to paste method.

http://m8software.com/clipboards/freeclip/freeclip.htm

It worth a try

Saturday Jun, 26, 2010 0:0
Mon
Jun 21
2010

My new toy

My new toy

Just bough this one with $2,058, it is great, and exactly the size I am looking for (I was searching for bigger on, but no luck). anyway, I will start enjoying it in few days.

Monday Jun, 21, 2010 0:0
Tue
Apr 21
2009

Matrix VS Windows

If Matrix run on Windows Read more >>>

Tuesday Apr, 21, 2009 0:0
Fri
Feb 20
2009

NetNanny - PC Family filter

I have been using NetNanny for almost a year now. It is great

Read more >>>

Friday Feb, 20, 2009 0:0
Fri
Feb 20
2009

TrueCrypt, encryption application

The best encryption software I have found during my 12 years with computer (Since 1997)

I spent sometime (around 4 years) with safe house application called SafeDisk, it was great, enables you to create logical encrypted disks.

< Read more >>>

Friday Feb, 20, 2009 0:0