Recent content by Shake412

I'm currently migrating VB6 app to .net which uses a lot of excel automation. the vb6 code employs a number of ranges and loops using a second range object as follows For Each rngCell in rngFocus < Do Stuff> Next This doesn't appear to work in .net, producing an Exception "Member Not...

Thanks dalchri, I'll give it a try.

I'm fairly new to .net and am trying to create an app which uses Access as a back end. I need to create a table dynamically and populate it with data. This is no problem using a DataSet and DataTable, however I want to save this table in an Access DB. How is this done, good old DAO was...

Using VB5, I am writing a class which imports an external file and then repeatedly calling that class from a form module. There are a number of checks performed in which the results are passed back to the calling procedure via err.Raise. Also any errors encountered are passed back up the stack...

Firstly, thanks guys this came in very useful. But what about if there is more than one instance of Excel running? I’m writing an app which automates some excel report writing. I’ve found that if the user already has excel open and another is created in the background the GetObject function...

I'm writting a VB5 app on XP Home Edition and am having trouble connecting to a Jet DB. Using the CreateDatabase method I can create a database, then create a table and populate it fine. But when I close it and try to access in code simply using Set ws = CreateWorkspace(0) or ("", "admin"...

I could get the whole link in for some reason. Here's the rest of it library/en-us/dnwinforms/html/wnf_custdatagrid.asp

Hi I'm looking at this myself at the moment and have been working from the following msdn article. You may find it helpful http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwinforms/html/wnf_custdatagrid.asp I haven't managed to get it fully working yet, but will try tonight...

I know there are posts already for doing this in VBA and VB6, but does anyone have any pointers for achieving this in VB.Net I've tried adapting the code quoted in the existing forums and tried the streamreader and the binary reader but with limited success. With the Binary reader, I thought...

Thanks for that. I never knew that you could call a procedure from within that very same proceedure. Is that new to .Net or has it always been part of VB. Thanks again

Is there any way of analysing a directory using the Directory.GetDirectories class and returning all levels of sub directories as well as the top level? And/or geting all the files when using the Directory.GetFiles class? Is the only way to do this, by looping through the directories returned...

Cool. Thanks. I'll give that a go. cheers once again.

That would work. Just that there's not a much fexability on a list box. Thanks again.

Thanks for the tip I have used check boxes, but, as far as I know I can't select a range, i.e. Select 2 points while holding down shift to select each row in between. Do you know anyway that this is possible. I am also trying to write an mp3 editor, but to bulk change names, etc.

I'm using a continuous form with the Record Selectors active. How do I refer to records which are selected when selecting a range of records? If I want to return data from one record, I just refer to the value of that control. Is there a way to loop through some collection of all the records...