Help Needed in VB

29 Sep 2006 10:46 PM

Craigbob

Hi,

I'm new here and it has been several years since I've done any serious VB
coding. I used to do a lot of VB6 development and have not really touched it
in about 8 years. .NET is brand new to me as well.

I need to create a quickie application either in VB6 or preferably VB.NET
that does the following:

Reads through a directory of .XLS files reads the contents of 2 cells and
renames the file based on the contents of those 2 cells.

In the old day's I'd have whipped this out in a couple of hours, but I've
discovered that I've forgotten a lot of my VB syntax etc...

Can any one help by providing me a sample to get me started?

Thanks

Craig

29 Sep 2006 11:15 PM

Dennis

Google for VB.Net and Excel and you will see lots of examples on how to read
cells in an excel spreadsheet file. Then use the File Class to copy, rename,
move, etc the files.

--
Dennis in Houston

Show quoteHide quote

"Craigbob" wrote:

> Hi,
>
> I'm new here and it has been several years since I've done any serious VB
> coding. I used to do a lot of VB6 development and have not really touched it
> in about 8 years. .NET is brand new to me as well.
>
> I need to create a quickie application either in VB6 or preferably VB.NET
> that does the following:
>
> Reads through a directory of .XLS files reads the contents of 2 cells and
> renames the file based on the contents of those 2 cells.
>
> In the old day's I'd have whipped this out in a couple of hours, but I've
> discovered that I've forgotten a lot of my VB syntax etc...
>
> Can any one help by providing me a sample to get me started?
>
> Thanks
>
> Craig