Range = mWSheet1.get_Range("A12", "O12") Īny help would be greatly appreciated. MWSheet1=(.Worksheet)mWorkSheets.get_Item("Basic Orders") MWorkBook = (path,2, false, 5, "", "", true.XlPlatform.xlWindows, "", true, false, 0, true,false, false)
T = (Trade)serializer.Deserialize(reader) String filePath = new XmlSerializer(typeof(Trade)) I am using Windows 7 Home Premium 32 bit and I have my Account for my service set to LocalSystem.This is the code that I am using: private void FSWatcherTest_Created(object sender, System.IO.FileSystemEventArgs e) But I am looking for a work around any way to be able to get this vba code running from a service. I know a Windows Service does not support opening MS Office files as there is issues with interacting with the UI and the User permissions it has. I attached a debugger to the application to try and see what was happening but there were no errors thrown and all the steps completed successfully. I have this working perfectly from a windows forms application but I cant get it working from my Windows Service application. At this stage I want to open an excel file and pass these values in to certain cells and run vba code from that work book. Once a file is added the content of the xml file is deserialized into object properties.
The Service is using a fileSystemWatcher to monitor a directory for an xml file to be added. I want to run some excel vba code from my Windows Service.
0 kommentar(er)
