Here are the main items you need to know:
- set up your new site, adjust NTFS security settings on the directory for the app pool you are using
- install self-signed certificate – I am using 7.5 – so it is SUPER easy (yes – something in IIS is easy)
- if you are installing a real certificate – use this link
- adjust bindings on your new site and use a new port (click on site, then on the far right – click bindings and
- add a new https with the new port and …
- use your new SSL certificate on the new port you are binding
- reconfigure your router to point your new SSL/secure port for external access
- Use a redirect or two to get http traffic to your new https address and port
ARRRGGG!! Another 1/2 hour is wasted. How many times have us VBA’ers did a paste and then realized the paste split the columns for us – using commas – but then the data gets all wonky on columns that are off the page so-to-speak. So – how do we reset the paste parameters to the proper values before we begin – well you to fake a Text-To-Columns on a new sheet or fake cell – then do a paste. It is really annoying. A quick google showed others are quite annoyed to. Why can’t we check what the parameters are currently? When I find out – I will post them here. In the mean time, follow this guys advice.
When I, and others, open my Excel VBA toolbox of macros – a message saying ” <<details to come>> you are about to open an ActiveX control. Are you sure … or something” appears. Here is the solution – you need to sign the macro with a certificate. Really this inflates people’s heads because we are doing something advanced – but really – it just annoys me as it is just a lot of extra work for me. I hope this helps others.