Feb 23, 2010 07:48 PM|hans_v|LINK
this requires you to use a third party assistance/script. I need this to be done with just Visual Studio .vb codebehind
You can't do this without a third party control. What is the problem with that?
I am able to save, change the file name,
That's easy using the System.IO namespace
access the worksheet with any name given to it, as well as add columns with information to the woorksheet inside the file.
You can't do that without a third part control. Most likely you've office installed on your development machine, and you're using the Mircrosoft.Office.Interop namespace, but as rptHarry already sais, this isn't supported, nor recommended by Microsoft:
"Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit
unstable behavior and/or deadlock when Office is run in this environment."
I'm assuming that changing the name of the worksheet would be something similar to these previous procedures.
When using Mircrosoft.Office.Interop it is just as easy/difficult