Search:

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...

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...

Hi,

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...

using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Globalization;
using System.Configuration;

namespace inter
{
class clsProgram

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...

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...

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:
...

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...

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...

Hi, I have tried to encorporate try and catch blocks into my code as follows:




try
{
string[] entries = File.ReadAllLines("J:\\sourceFile.txt");
...

Hi fcronin,

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...

Hi,

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...

Hi,

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...

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.

Hi,

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...