HI;
I m writing excel vba, i would like to execute a SQL query :
select *  from receiver_line
where purc_order_id+'/'+cast(purc_order_line_no as varchar(3))

Here is sample code:
If  Worksheets("Sheet1").Range("E5").Value = "1" Then
  Worksheets("Sheet1").Protect
Else

I have the following code:
Do
       Msg = "Is the BILLING DATE below correct?" & Chr(10) & Chr(10) _
           & "If not, Enter correct date ..."

I have written a macro to open 19 workbooks, copy a few rows of info, and
then write the copied rows to a consolidaton workbook.  Everything is working
fine except I get the screen updated every time a new workbook opens even
though I have explicitly included Application ...

I would like to use the conditional format function to change the
background color of a cell.  My spreadsheet contains the following
columns:
A)Today's Date     B) Date of Last Visit   C) Date of Next Visit

I've got an excel application which on opening shows an message box
compiletime error 1004:application or object defined error when I click
ok the whole application is closed not allowing me to view the vba code
.It also closes other workbooks which are open .kindly suggest a soln.

Please offer me some help and education with this;
I have a named cell on a sheet.
There are a large number of buttons that will each toggle a row
hidden/unhidden.

I want to find and use a control like that which is used when inserting
functions in a worksheet and selecting cells. I will design a userform that
is comparable with this used for functions
In the first step there is a symbol for the worksheet to click on to make it

I want to use the "Before Save" event to force users to save a template with
a certain naming convention.  (The name must contain the words Air
Container)
Is this possible.  For example in the Before Save event procedure it may say

I've had an Excel workbook given to me to examine because it fails to work
as expected when converted from Excel 97 to Excel 2003.  There is no run time
error or any such problem.  What I have identified is that the subtotal
command behaves differently in 97 to what it does in ...

I compiled a macro using the macro recorder to put borders around a
selection of cells.
However, I'm getting the following error when I do two cells.
Run-Time Error '1004':  Unable to set the LineStyle property of the

As part of an Excel model, the user would like to maintain a list structured
with multiple Categories and within each category, there are multiple Items.
It will be displayed in multiple columns. A sample is shown below; I am using
the hyphen '-' to indicate the break between ...

I often load CSV files into Excel and then re-save them as Excel Workbooks
(*.xls) format.  The loading of the CSV file is handled by a command-line
that invokes Excel and loads the CSV.
After the CSV is loaded into Excel it would be VERY nice if a macro could be

I am creating a document catalogue in xl, listing documenst of several
types, e.g. xls, doc, msg, pdf etc I have the code to open xls files
from excel, and the code for word dobuments. However a couple three
things I am seeking:

Re: Excel 2000, SR-1, Auto-running Macros
I would like to know if it is possible to program Excel to automatically run
a macro after a Refresh Query event is automatically run? If so, can you
provide the VB command/s or other that will enable this process?