Jump to content
Sign in to follow this  
13lack13lade

Excel Dashboard with Autoit?

Recommended Posts

13lack13lade

Hi Guys,

Thinking of making a Dashboard for works Excel files however i hate using shared files (really annoying to deal with) in regards to having just a main excel Dashboard file that everyone opens up (just wanting to improve performance speed and over all durability of the excel Dashboard)

Was tempted to use Access as this would be 2nd easiest option however we dont use Access at work so tempted to try and make an Autoit Excel Dashboard.

Just wanting to know has anyone tried this and how much luck did you have with it? or am i better off not even wasting my time and just sticking with making the Dashboard in Excel.

Share this post


Link to post
Share on other sites
water

Shared access to an Excel file shouldn't be a problem.

To create a dashboard with graphics you could have a look at the ExcelChart UDF.

Ptrex has created a great example of a >dashboard.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
13lack13lade

Shared access to an Excel file shouldn't be a problem.

To create a dashboard with graphics you could have a look at the ExcelChart UDF.

Ptrex has created a great example of a >dashboard.

Not a problem as such to run in excel, ive already made a great dashboard in excel but sometimes using windows server 2003, xp & win7 ive found that random errors happen with shared excel spreadsheets and it gets very annoying was just thinking i might be able to have more flexibility or less issues with an Autoit Dashboard but am not aware of any limitations etc thats why im asking if theres any benefit to creating one in autoit... 

Plus i like playing with autoit, helps improve my skills! :)

Will take a look at Ptrex!

Muchly appreciated as always water! :)

Share this post


Link to post
Share on other sites
water

To make sure you have no problems with shared Excel spreadsheets I would make sure that only one system has write access and all other just open the sheet in read-only mode.

That's easy with the rewrite of the Excel UDF.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×