Type: Posts; User: csharpit
Search took 0.01 seconds.
July 27th, 2013, 09:25 PM
I am trying to write a Macro in Excel which makes a copy of some of the information entered and a timestamp of when the change was made. It also creates a new entry if existing information is edited...
February 11th, 2013, 02:49 PM
I want to connect this program to a copy of the database on my local machine. I have downloaded SQL Server Express 2005 Management Studio and have made a copy of the database and restored it to my...
public class ExcelTest
static void Main(string args)
Excel.ApplicationClass excelApplicationClass = new...
I need to write a simple program to do the following in a very large and complex Excel worksheet:
1. Create a new worksheet (tab)
2. Copy the data from the original worksheet to the new...
September 12th, 2011, 04:43 PM
September 12th, 2011, 09:56 AM
Thanks, but I am having trouble coding this and can't get it to work.
Also, I have another requirement where the time difference needs to be applied to the previous line of the searched word. So...
September 6th, 2011, 08:45 AM
Yes it would be correct to assume that duplicate items always follow the next line and yes I did
mean a duplicte of the date time stamp no the whole line.
The solution you have described was...
September 5th, 2011, 04:56 PM
I require help with a very simple program which needs to remove the duplicate lines as well as other defined lines in a text file.
The program will be run on a similar file like the one below:
July 20th, 2011, 05:41 PM
Ah yes, I will include the sw.Close() statement within the try block.
Thanks for the updated catch statement.
Next question, If I wanted to display the results of the time difference so that...
July 20th, 2011, 11:32 AM
Thanks guys. Is the following correct?
So the bulk of the code is within the try block, this way all of the variables are in scope.
Then the catch block wil handle any errors found in the try...
July 20th, 2011, 06:46 AM
Hi, I have tried to encorporate try and catch blocks into my code as follows:
string entries = File.ReadAllLines("J:\\sourceFile.txt");
July 19th, 2011, 04:16 PM
Your solution worked a treat! Thanks.
I have made some minor modifications in the way the time span is displayed but other than that the process is the same.
One thing I have...
July 14th, 2011, 04:32 PM
Thanks, this worked. I think I may have made a mistake and changed it. Sorry.
I understand how this works but how would I get it to scan through my existing text file and apply the...
July 14th, 2011, 02:53 PM
Thanks for your reply.
To try and figure out how complete this, I first tried your code soI could understand the basis and work from there. However it did not work. The output is only the...
July 14th, 2011, 06:05 AM
Thanks very much for your reply and useful information.
Yes you are correct, it is massive overkill to use .Net for this, however it needs to be programmed in C# .Net.
July 12th, 2011, 05:03 PM
I am writing a simple program which reads through a text file and searches for a specific string. As it finds each instance of this string it needs to copy the date and time of the line (not...
Click Here to Expand Forum to Full Width