Hello,

I am trying to create an application that looks like this:
http://img406.imageshack.us/img406/7015/picture2so.jpg

So, this is going to be a .exe application that will allow the users to browse for an excel worksheet and with the click of the "Format!" button, it will run the excel vba macro that I have made. What is the best way of doing this? Thanks!

You can create a VB6.0 Application and create a Exe file. You can use CommonDialog in VB Form to select the Excel file.

You can add Excel to the list of References of the VB Project and can use Application.Run to call your macro

If you do not need .EXE, you can create the same application as Excel Workbook and Excel Addin and create the same userform functionality in Excel too

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thank you Shasur! But I think I will be using C++ instead, from this posts that I found:
http://www.codeproject.com/KB/buttons/CBrowseCtrl.aspx
http://www.codeproject.com/KB/office/ExcelwithMC.aspx

Now I got to figure out how to combine these two projects together to do what I want it to do. I also have to figure out if I am able to call a .bas file for Excel to run the macro that I made.

Okay I'm using VB6.0 to create the application and I don't know why I am getting this error: Run-time error '5': Invalid procedure call or argument and it goes back to Shell(Text1.Text)

Here are my codes:
Private Sub btnBrowse_Click()
On Error GoTo MyError
With CommonDialog1
.CancelError = True
.Filter = "Excel Files(*.xls)|*.xls|All files (*.*)|*.*"
.FilterIndex = 1
.Flags = cdlOFNHideReadOnly Or cdlOFNOverwritePrompt Or cdlOFNPathMustExist
.InitDir = App.Path
.ShowOpen
End With
Text1.Text = CommonDialog1.FileName
Exit Sub
MyError:
If Err.Number <> cdlCancel Then
MsgBox Err.Number & " - " & Err.Description, vbOKOnly + vbExclamation, "Save"
End If
End Sub

Private Sub cmdFormat_Click()
Shell (Text1.Text)
End Sub

Because shell is a function contained in an API, you need to declare it first (google about it).

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

I've tried to google but I couldn't find the answer.
If I type in cmd or calc.exe into the textbox and click the button it will run, but if I type in for example "C:\IDS499\Chapter2\google.jpg" I get a run-time error 5.

Well, it's trying to execute that command. Probably you don't have anything asociated with that kind of file (I doubt it, but according to what you said looks like that).

Anyway, if the command works sometimes and not other, then the problem is not the command, is the input.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

Is there any other command to run instead of using Shell because I hard coded Shell("C:\IDS499\Chapter2\google.jpg") and it's still giving me error 5.

Again.. the problem is not the shell.. what happen is you try to execute that in a command line???

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

I figure out a way to fix this problem. Instead of using the Shell command, I used:
Set oWB = oExcel.Workbooks.Open(Text1.Text) and this is perfect! Thanks for all your help!