Is it possible in Excel2007 to save an ActiveWorkbook as a DBASE4 file?
In Excel2000 I used the command which dosn't work in2007:
ActiveWorkbook.SaveAs Filename:="C:\FN.DBF", FileFormat:=xlDBF4,
CreateBackup:=False

Recently i upgraded my Office XP with (from memory) a SP3 patch file.
But now i get an alert message saying:
Micosoft Forms
This application is baout to initialize ActiveX controls that might be unasafe. If you trust the

Hi, I'm a newbie with macros and need some help. I have a spreadsheet with
data extracted by a macro and I've inserted Column A which is blank. I need
to include something in the macro to auto fill the row numbers in column A to
the end of the data. The number of rows is ...

Hi;
By default, my excel creates new worksheet with 256 columns
and column headings A, B, C, ...
I'd like to create a new worksheet with 4 columns only

I have several rows in a worksheet that are initially formated with
General (no number formatting).
However, when the user enters something like 3/8  or 3.8 Excel reads
it as a date and changes the input to its date equivalent and changes

I'm building an App where code in the Wbk Open event must execute.
I can't find where/how to test if the user has clicked the disable macro
button when Excel presents that choice.  (Note: I have a "gateway" Sub in the
works that will execute before every user-selected macro to be ...

will someone tell me why this does't call the macro. This is in the code for
a user form. It is acessed by an option button. Do I need to put the macro
procedure into the code of the option button?
Thanks

I had the requirement to write a function, which would be embedded in a cell
that could modify the values of other cells in the same worksheet.  However,
the function kept returning the #Value error.  I traced through the function
using Msgbox and established that the error was ...

I'm no vba programmer, I can record macros, do loops etc, but I'm not
sure how/why each statement is structured the way it is.
What I want to do is store the value from a specific cell.  The cell
is located in column B, and in the row of the current selection.  ie,

Hi all, I have a worksheet filled with students information (ID,name,
nationality.. etc.) and we are requested to give a print outs of
students with any information missing from his record, so my plan is
to create a macro that do the following:

I have written an AddIn (call it AddIn_2) which picks up where another
(AddIn_1) leaves off.
AddIn_2 uses events to identify when a particular worksheet is
activated to enable a menu item.

I have a userform with a series of buttons.  I want the user to be able to
click a button and the system will bring the 'Input Log' sheet into focus.
ideas?

I have been using the following code to run a Daily Report.  The input box
asks the user to enter a date, and the sheet uses the date entered to update
the sheet values.
Question:  I want to use a date picker instead of an input box to enter a

I have an excel application activated by the task scheduler in the middle of
the night
The spreadsheet executes a macro, saves itself and shut down itself.
If the security level is set to low, it works ok

I have a UserForm that asks the user to select the year, the month, and the
day.
How do I convert this to an Excel Stored Date without having to write it to
a cell then extract the cell's value via .Formula?