I am trying to publish a C# application that does two main things. First, it runs a VBScript that goes into the SAP (Software solutions business) service and retrieves information in an excel type format. Then my program runs the main C# part and manipulates the data and then stores it into an excel file on the desktop. It works very well on my computer; However, I need to publish this application on three other computers and I am not sure how to do this since the VBScript file I am running is ran through a specific WorkingDriectory that is found on my computer. Is there another way I should be trying to run the VBScript or can I put the file in a spot that has the same working directory no matter where it is installed?
I cannot seem to find many resources for this (probably because I do not know the specific buzzwords) and have only seen VBS files run by using a directory as opposed to being part of the program itself. All other searches to find ways to run other scripts have resulted in the same outcome, running from a specific directory. I have also seen a lot of people say that it is not possible to have the VBScript as a file in the solution and run it right from the program itself.