Don't know how to make it work. A little help please.

[roofninja]

I have some code below that is only a test sample but it uses the ExcelCOM_UDF.au3. It basically out puts the data to a spread sheet. That part works great. What I want it to do is when there is no excel on the PC it would output the data to a txt file. Now I do have the code to output to a txt file, but I just can get the program to run. How do I do that? I have been looking for an answer for some time now and I haven't found one. Can it be done? Am I trying something that Autoit can't do? If you would point me in the right direction that would be great. Thanks.

$ts = FileExists("c:\Program Files\Microsoft Office\Office10\excel.exe")

;MsgBox(0,"FileExists",$ts)



if $ts=1 then

#include <ExcelCOM_UDF.au3>

MsgBox(0,"FileExists",$ts)

else

MsgBox(0,"","Yes the program runs")

EndIf

[PsaltyDS]

I have some code below that is only a test sample but it uses the ExcelCOM_UDF.au3. It basically out puts the data to a spread sheet. That part works great. What I want it to do is when there is no excel on the PC it would output the data to a txt file. Now I do have the code to output to a txt file, but I just can get the program to run. How do I do that? I have been looking for an answer for some time now and I haven't found one. Can it be done? Am I trying something that Autoit can't do? If you would point me in the right direction that would be great. Thanks.

$ts = FileExists("c:\Program Files\Microsoft Office\Office10\excel.exe")

;MsgBox(0,"FileExists",$ts)



if $ts=1 then

#include <ExcelCOM_UDF.au3>

MsgBox(0,"FileExists",$ts)

else

MsgBox(0,"","Yes the program runs")

EndIf

Most UDFs (#include files) are just a collection of constant and variable declarations. Functions cannot be declared conditionally, so it doesn't make sense to put an #include statement inside a conditional (If/Else/EndIf). They are normally all grouped together at the top of the script.

Other than that error, there is nothing hard about what you are trying to do and your If/Else/EndIf should work fine. What happens when you try it (after putting the #include back where it belongs)?

[roofninja]

PsaltyDS,

Thanks for the help. I was having a writer's block.

I was able to fix what I was doing and run a few tests on it. I chose the wrong thing to use in my example. Getting that to work was the key. Thanks again.

Edited March 11, 2008 by roofninja