Hi Paul,

I have uninstalled MS office 32bit and installed 64bit office - working fine now.

(My system configuration was office 32 on 64 machine - I think all the associated packages are related to 64).

Many thanks.

Hi Paul,

Thanks for your help so far - much appreciated.
I not quite there yet...
Positives:
MS Visual studio community 13 is working  - I can load the project :)
I tried using the NuGet for the linqtoexcel - that did not work - I was still getting the error message  ( I did follow the instructions and change the reference to the LOG4NET ).

Then I used the link you gave and downloaded the x86 / 32 bit version  ( at least I assume that is what is was...
https://code.google.com/archive/p/linqtoexcel/downloads
Linqtoexcel 1.7.1. zip.
I added these references in but still I have error messages...see attached file.

I will be most grateful if you can help.

Many thanks.

Error messages...

Warning               1             There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "LinqToExcel", "x86". This mismatch may cause runtime failures. Please consider changing the targeted processor architecture of your project through the Configuration Manager so as to align the processor architectures between your project and references, or take a dependency on references with a processor architecture that matches the targeted processor architecture of your project.               cAlgo4u Excel Example

Error      2             The type or namespace name 'Attributes' does not exist in the namespace 'LinqToExcel' (are you missing an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           9             19           cAlgo4u Excel Example

Error      3             The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           43           14           cAlgo4u Excel Example

Error      4             The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           43           14           cAlgo4u Excel Example

Error      5             The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           46           14           cAlgo4u Excel Example

Error      6             The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           46           14           cAlgo4u Excel Example

Error      7             The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           49           14           cAlgo4u Excel Example

Error      8             The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           49           14           cAlgo4u Excel Example

Error      9             The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           52           14           cAlgo4u Excel Example

Error      10           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           52           14           cAlgo4u Excel Example

Error      11           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           55           14           cAlgo4u Excel Example

Error      12           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           55           14           cAlgo4u Excel Example

Error      13           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           58           14           cAlgo4u Excel Example

Error      14           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           58           14           cAlgo4u Excel Example

Error      15           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           61           14           cAlgo4u Excel Example

Error      16           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           61           14           cAlgo4u Excel Example

Error      17           'LinqToExcel.ExcelQueryFactory' does not contain a definition for 'UsePersistentConnection' and no extension method 'UsePersistentConnection' accepting a first argument of type 'LinqToExcel.ExcelQueryFactory' could be found (are you missing a using directive or an assembly reference?)               C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           118        22           cAlgo4u Excel Example

Error      18           'LinqToExcel.ExcelQueryFactory' does not contain a definition for 'ReadOnly' and no extension method 'ReadOnly' accepting a first argument of type 'LinqToExcel.ExcelQueryFactory' could be found (are you missing a using directive or an assembly reference?)         C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs             121        22           cAlgo4u Excel Example

Error      19           'LinqToExcel.ExcelQueryFactory' does not contain a definition for 'Dispose' and no extension method 'Dispose' accepting a first argument of type 'LinqToExcel.ExcelQueryFactory' could be found (are you missing a using directive or an assembly reference?)         C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs             134        26           cAlgo4u Excel Example

Error      20           The type or namespace name 'Attributes' does not exist in the namespace 'LinqToExcel' (are you missing an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           9             19           cAlgo4u Excel Example

Error      21           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           43           14           cAlgo4u Excel Example

Error      22           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           43           14           cAlgo4u Excel Example

Error      23           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           46           14           cAlgo4u Excel Example

Error      24           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           46           14           cAlgo4u Excel Example

Error      25           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           49           14           cAlgo4u Excel Example

Error      26           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           49           14           cAlgo4u Excel Example

Error      27           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           52           14           cAlgo4u Excel Example

Error      28           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           52           14           cAlgo4u Excel Example

Error      29           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           55           14           cAlgo4u Excel Example

Error      30           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           55           14           cAlgo4u Excel Example

Error      31           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           58           14           cAlgo4u Excel Example

Error      32           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           58           14           cAlgo4u Excel Example

Error      33           The type or namespace name 'ExcelColumn' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           61           14           cAlgo4u Excel Example

Error      34           The type or namespace name 'ExcelColumnAttribute' could not be found (are you missing a using directive or an assembly reference?)               c:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.cs           61           14           cAlgo4u Excel Example

Hello Paul,

Many thanks for the cbot.

I am having some issue with the installation. Perhaps you can help me please...

When I try to run I see the following error message...

03/02/2016 17:47:31.134 | cBot "cAlgo4u Excel Example" was started successfully for EURUSD, h1.
03/02/2016 17:47:31.650 | Crashed in OnStart with InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
03/02/2016 17:47:31.697 | cBot "cAlgo4u Excel Example" was stopped for EURUSD, h1.

So looks like the error is related to OLEDB....

I checked your website and followed the instructions to download the access database engine.  After the download and install the same error message remains.

So, using visual studio blend...

I built the project in there....here i see more detailed error message....

Project "C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example.sln" is building "C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\cAlgo4u Excel Example.csproj" (default targets):

C:\Program Files (x86)\MSBuild\12.0\bin\Microsoft.Common.CurrentVersion.targets(1697,5): warning MSB3270: There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "LinqToExcel", "x86". This mismatch may cause runtime failures. Please consider changing the targeted processor architecture of your project through the Configuration Manager so as to align the processor architectures between your project and references, or take a dependency on references with a processor architecture that matches the targeted processor architecture of your project.

cAlgo4u Excel Example -> C:\Users\AK\Documents\cAlgo\Sources\Robots\cAlgo4u Excel Example\cAlgo4u Excel Example\bin\Debug\cAlgo4u Excel Example.dll

Done building project "cAlgo4u Excel Example.csproj".

The build has successfully completed.np

........

So, it seems a configuration issue...sounds to me related to 32/64 bit and the expected 32/64bit of the Linq to excel....

It looks like I am using linktoexcel 1.10.1 ( based on info I see in visual studio 2013 blend.

If you can help, I will be most grateful.

Many thanks.

Andy

Well done, thank you. :)

Thank you, your talents are much appreciated. Kind regards :)