OK Workbook is always open. because I need to see the result of the calculation in Excel, it's like a "GUI" type of thing. 'Your Code: Run Program>C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE C:/Program Files/Folder1/Folder2/counter1.xls Excel macro is ( replaces the Import macro for now) Su...

Finaly, I found this link http://www.mjtnet.com/forum/viewtopic.php?t=3104&highlight=odbc&sid=f8b15e1ea17b704fefa4dd8a5ad8cd72 Makes sense somehow, where do I go and alter the code to get connected to Firbird and see what's inside Firebirds database because i will require to constrruct a database so...

OK, Bob Hansen, according to your code as posted and corrected by SkunkW. Interim Test; I have set up a special Excel Workbook and all it has is a "counter" macro So each time the log file changes, the "do something" is to Activate the counter macro in that Workbook.This is to get it all working rig...

Thankyou for the welcome to, Bob Hansen and SkunkWorks. Going by the current server's scripting language, in structre it all looks similar. I know it starts with: sub DefineGlobals const("xyz",varBoolean,True) const("xyz",varString,"Demo_WRKSHP") const("REFERENCE",varString,"Demo") const("TESTING",v...

Thanks SkunkWorks; So, look at how you can get an ODBC connection to the server. This site has TONS of examples for this. Are these examples specific to Firebird Server or generaly to any server ? What do I look for in this forum as in terminologies for search to read up a bit on doing these OBDC co...

OK, here we go, I will try to explain. My excel workbook/macro is fine except for this final phase as to why I am here ! The process "logic" is this: Server uses Live data feed going to Server's database. Script in Server ( ironicaly similar to your product) does stuff and the product is the log fil...

Hello all, this has been an ongoing search for a solution and I ended up here. I need to know if I can learn to write a script that will detect if a particular log file has increased in byte size, and when it does it will then Activate a specific macro in Excel ? The log file is created by a Server ...