|
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
|
|
|
|
|
For Excel Interop do I need VIsual Studio
|
|
|
|
|
Well you certainly need some compiled program.
One of these days I'm going to think of a really clever signature.
|
|
|
|