How can I get the path of the Excel application from VBA code?  This would be
like coding CurrentDB.Name in Access.
Thanks in advance,

        Thanks to all for the HELP I'm getting from this group!
   I have a macro set to clear all the cells in a work schedule
spreadsheet and a button to run the macro.
    When I push the button I need a WARNING BOX to appear

I was wondering if there will be a new BIFF9 or something format for the
.xlsx files that are creating using the new Excel 12 or 2007.
I have an application that reads and writes BIFF3-BIFF8 files, so I would
like to know if a new format is created and if there is any ...

I am trying to insert into a SQL table the results of some variables.  Let's
say I have variables called; PHONE,LNAME,FNAME  and I want to insert them
into a table called CONTACTS with Field names (FIRST, LAST, TELEPHONE)
What syntax can I use to insert the value from these ...

I have a large number of SpinButton/TextBox combinations on a userform
(~50).  I'm trying to figure out if there's a better way than writing
this type of code 50 times:
Private Sub SpinButton_MeltPower1_Change()

I'm having trouble copying values from multiple worksheets into my summary
sheet.  What I need to do is, look at the value in column C, go to the
worksheet with that name, find the bold cell, copy that value and paste it
back in column L of the first sheet.  I can do this for one ...

I have recorded a macro in Excel that imports a text file into Excel - so
Data > Get External Data > Import Text File and then follow the wizard. How
can I import another file using the same macro without having to go over the
same steps..i.e using the wizard, etc.

We have an Excel spreadsheet that was created by someone who left the
company and who did not document what they had done. This spreadsheet is
supposed to be connect to a SQL Server to extract data for a report, however
the server on which the data resides was changed, by the ...

This is probably beyond what an Excel Macro can do but I thought I'd ask
anyhow.  Using Excel 2003, is it possible to run windows commands from
within Excel and return the results to a spreadsheet?  What I'm trying to do
is ping a range of IP addresses, 192.168.1.1 - 192.168.1 ...

I've added a right click popup menu to a range ("Orders" = A15:E40) that
works fine (bar my other FaceID problem - see "FaceID not available" post
earlier today).
The problem is that if I right click on a row or column header the popup,

How can I grab MS Excel diagram to bitmap?

Would like a macro that would Filter the rows by Col I and then print all the
data based on Col I
Col A = No.                   Col F = Place
Col B = Name                Col G = Best Time

Is there a command tcon for wrapped text?

I can use this code when using a Private Sub ToggleButton1_Click().
Me.ToggleButton1.Value = False
However, I'm trying to use this in a standard Sub routine.  When attempting
it that way, it gives me an error.

I'm having a problem with a FaceID property of a control button on a popup
menu.  Basically it doesn't appear (in Intellisense) to be available (so for
the moment I've commented it out).  Can anyone tell me why it's not
availble?  NB- I'm using Excel 2003 and the code below is ...