Invoking excel thru a .bat file
-
Hi I need some pointer withe following process 1) having a .bat file kicked off by the creation or the Change whitin a .txt file 2) the bat file will then cut the data whitin it And paste it on excel worksheet Any pointers with this or what technology to Look at e.g object linking (I think object linking Invokes Microsoft products) Would be helpfully Thanks in advance
-
Hi I need some pointer withe following process 1) having a .bat file kicked off by the creation or the Change whitin a .txt file 2) the bat file will then cut the data whitin it And paste it on excel worksheet Any pointers with this or what technology to Look at e.g object linking (I think object linking Invokes Microsoft products) Would be helpfully Thanks in advance
Sure you can invoke Excel trough a batch file but you would not be able to interact with the Excel instance. This sounds more like you want a regular application using a FileSystemWatcher and Excel interop. Or, you might be able to do this from a PowerShell script.
Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
-
Sure you can invoke Excel trough a batch file but you would not be able to interact with the Excel instance. This sounds more like you want a regular application using a FileSystemWatcher and Excel interop. Or, you might be able to do this from a PowerShell script.
Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Please stand in front of my pistol, smile and wait for the flash - JSOP 2012