Windows 10: Automated method to enable Excel security setting.

We have an issue in S3D Software. and they suggested to consult to you.

:)

 

Automate tasks with Automate tab - now in Excel for Windows and Mac

Source: https://techcommunity.microsoft.com/...r/ba-p/3705856

 

EXCEL automate download stock prices at end of day

Jimbo:

Didn't you have a thread on this a few months back?

I've never found a fully automated way that works LONG-TERM. I've had a bunch of methods that work for months or a year or two and then fail for reasons beyond my control---typically programming changes at the source site.

I've settled on a NON-automated method. It takes 15 or 20 seconds a day.

I swipe the mouse across what you see below and then paste that swipe directly into cell A1 on a specific Excel tab.

The data is then populated elsewhere in the same Excel file by formula.

It's manual, so it's going to work until and unless Bigcharts disappears or has bad data.....that hasn't happened in the 15 plus years I've been using Bigcharts. All you need is your ticker list.

Screen grab below taken about 5 minutes ago, but I typically grab a couple of hours after the close when all prices are in.

 

How to disable security warning? Excel 2019

Hi all, when I create a hyperlink in an Excel 2019 cell to a file in my PC (a PDF) and then click on the cell, before the linked PDF opens a security warning displays as shown in the attached screenshot. I tried this method to disable these warnings without success. Any suggestions? Thanks