Re: Unblock Excel

Excel Help for Re: Unblock Excel in Presenting and Reporting Data

Find Excel Solutions


Search Forums:
Recent Activity:
Can't Get It To Give Me The Report I Want
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?




Follow Business Spreadsheets On:
 
Forum TopicLogin

Re: Unblock Excel

Rate this:
(3/5 from 1 vote)
ConfusedThis is just a guess -  

To do this task you will need a macro.
You will have to initiate the hyperlink from within the macro so that you can count the time it takes to load. You will need to include code that can check the browser address so that it matches partof your hyperlink. I say this because most sites change the url by adding extrabits that may contradict your original link.

If there is no match for more that 5 seconds then
range("A1").select

This might redirect the attention back to Excel.

I haven't tested this yet as it will require some nail-biting, hair-pulling, chain-smoking coding.

 Posted by on
 
View the "Unblock Excel" Topic

Find relevant Excel templates and add-ins for re: Unblock Excel in the

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |