[Couriant]

Originally Posted by Zack Barresse

Ok, gotcha. One thing I would like to know though, how and where do you want this code to execute from? Is this something you'd like as an Excel add-in? Where it's always available, perhaps its own custom menu item (or Ribbon if you have 2007)? Would you like this to be in a specific file, so users must open it, then run the code? Would you like this in a VBS file where users can double click it and run the program (would take some restructuring)?

We can either walk you through installing the code, or do it for you (i.e. if it's an add-in). From the sounds of it thus far, I'd recommend an add-in, but it's up to you. Before we go any further we'd need to know that.

Hmm... decisions decisions...

Actually I think an 'add-in' would be better for the client. The simpler the better.

[Zack Barresse]

Okay, so let's get the UI out of the way. What version(s) of Excel do you want to run this on? Put it this way, are you 97-2003, and if so what is the earliest version this will run on.. or do you run 2007? Do you want a custom menu, custom toolbar, custom ribbon? Do you have faceID preferences (button icons) and/or button text preferences? The file you presented is in 97-2003 format, so I'll assume you're not working with 2007. I don't think we're doing anything that won't run in all three versions, but it would be nice to know.

Oh, and what do you want it to be called?

Edit: And btw, yes I did notice you said you were using 2007, but don't know if your users are. We can do this in 2007 custom Ribbon if you'd like.

[Couriant]

The client is using MSO 2003, and I have MSO XP (2002) as well as 2007. I can use my earlier version for this instance.

[Zack Barresse]

Okay, make available for 2002. Gotcha. While I'm coding this up, is there anything else you wish to input about your UI? I.e. what the buttons should be called or anything?

[Couriant]

Whatever you feel a novice would understand

[Zack Barresse]

Okay, check out the file. It's pretty basic, let us know what you think. I called it "CSV Importer". Of course you can change to whatever you like. I can post the code to this thread if you like, just let me know.

HTH

[Zack Barresse]

Oh! I forgot to add this code to the ThisWorkbook module...

Option Explicit

Private Sub Workbook_AddinInstall()
    Call CreateMenu
End Sub

Private Sub Workbook_AddinUninstall()
    Call DeleteMenu
End Sub

Then you need to install the add-in (as opposed to opening it).

[Couriant]

Originally Posted by Zack Barresse

Oh! I forgot to add this code to the ThisWorkbook module...

Option Explicit

Private Sub Workbook_AddinInstall()
    Call CreateMenu
End Sub

Private Sub Workbook_AddinUninstall()
    Call DeleteMenu
End Sub

Then you need to install the add-in (as opposed to opening it).

Where do I put this code?

[Zack Barresse]

If you have the file open (as opposed to installing the add-in... if you have it installed, after saving the file uninstall it, close and restart Excel) in the VBE (Alt + F11), ensure you have the Project Explorer open (Ctrl +R). Find the file (CSV Importer.xla) and expand it, expand the folder and look for the ThisWorkbook module. Double click that and paste the code in that module. Save and close out Excel.

As stated above, if you have the file already installed, save it with the changes, uninstall it, then reinstall it. If you do not have it installed and you just opened the file, just save and close the file then install the add-in. If it's easier I could put the code in the file and repost. Sorry bout the confusion.

[Couriant]

Is doing right click small icon next to File the same as ThisWorkbook Module?

[Zack Barresse]

Yes, right clicking that icon and selecting View Code (Excel 97-2003) will bring up the ThisWorkbook module. Remember though, if you're trying this with an add-in, you won't be in the right module - not even the right workbook. Add-ins have a visible property set to False, which is the big difference between them and a normal workbook. You must do it from the VBE to access its ThisWorkbook module.

[Zack Barresse]

Did this ever work for you?