Messages

1

Support Questions / Re: Add Excel 16.0 Object Library

« on: September 09, 2022, 02:55:18 AM »

Hi Archie,
its easy when you know how 

Thanks for the help, i found several different packages there I will try them to see which one is the best "fit" for me.

Thanks again my friend 

2

Support Questions / Re: Add Excel 16.0 Object Library

« on: September 08, 2022, 09:36:14 AM »

Hi Archie, thanks for the prompt reply.

I do have MS office installed Home office & business 2019.

 ClosedXML which can be added to a project using the "Nuget Manager"?

is it possible to import AdvancedHMI into an existing project? maybe if i set up excel first then import AdvancedHMI i only have to re-write my application?

3

Support Questions / Add Excel 16.0 Object Library

« on: September 08, 2022, 08:53:10 AM »

Hi everyone,

Visual studio 2022 (64-Bit) V17.3.3 & AdvancedHMIv399yBeta38.

I'm completely stumped now.

I have written a windows application that extracts and displays a count value so the manager can insert comments next to the count value, the count, the time of the count and the comment are added to a DataGridView at the press of a "confirm" button. This part is working correctly and is not a problem.

my next step would be to load the data from the DataGridView into an Excel spreadsheet then continue to run my application for a different production line count.

My problem is I cannot get "Project -> Add Reference -> COM -> Microsoft Excel 16.0 Object Library" to install.
I get the pop up message "A reference to 'Microsoft Excel 16.0 Object Library' could not be added. This is not a COM component"

If i start with a new project (without AdvancedHMI) I can install the Excel library with no problem but then i cannot open the AdvancedHMIv335.sln to rewrite my application.

I know I am probably stupid but I just dont know a great deal about Visual Studio but i am in desperate need of help as i am completely stuck now so near to completing my application.

Thanks for reading, Shaun.
 

4

Open Discussion / First Experience!

« on: July 27, 2019, 01:31:03 PM »

Hi Archie,

I just wanted to say I have just finished my first project using AdvancedHMI for displaying production line / machine efficiency data on a large PC monitor in our production area.

My windows programming was very rusty as I was only used to writing applications in Delphi 5, but there was no support that I could find for Delphi to interrogate Siemens and Allen Bradley PLC's, so after a quick Google search I found AdvancedHMI and thought i would give it a try.

I purchased all the add-ins just so i could play with and evaluate them all.

I must say I was, and still am very very impressed with your components for ease of use and simple interface.
I should also say that I did struggle a lot with Visual Studio 2019 and the .Net commands / structure.

I did refer a couple of times to the forum and that there is a wealth of information there because the product is very well supported.

I guess what i really mean is excellent work Archie, very well done. Thank you.