I'm new to VBA programming, and I'm trying to run the code found at:
http://www.microsoft.com/technet/scriptcenter/resources/officetips/may05/tips050
3.mspx
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True

I have a spreadsheet with a column of numbers, ie
1
2
3

is it possible to apply auto filter to a workbook that is not open?
May be you will ask why do I want to do this.
Here is my situation.
I have a software that outputting records to excel.csv file.And

Master sheet is named 'Input' data located at L6:n6.
Child named '11' and data needs to move to F14:h14.
macro need to select proper child sheet by  adding (D4*10+D6) = 11
and the proper line on child by value stored at D3  = 1 as the child has a

I have a variable named " number", which can range from 1 to 10( entered via
inputbox
Now I need a VBA script which, depending on the value of " number", selects
a series of columns. Example: if "number" =1 than columns T:Z to be selected,

count IF cell IS yellow

I've used VBA code to automate various Excel data analyses and
charting. For code security's sake I'd like to transfer most of this
functionality into DLLs. (And, to be honest, as an exercise for
learning VB6 - yes I know VB6 is now unsupported and we're all

Using Excel 2007 I have a combo box with a row source of dates linked to a
column of worksheet cells. The cells on the worksheet are UK formatted as
dd/mm/yy and appear as such. The form opens and when a user clicks on the
combo box the dates can be viewed correctly - so far so good ...

Hi I have a macro in my workbook which appears to be activated whenever data
changes. For example, if I delete a piece of data or paste data.
Here is the error:
Run-time error '13'

Have made some posts already to resolve some problems I have but am stuck
Let me explain:
For a daily reporting system we use a workbook in which the guys in the
field report activities each day. Sheet for day 1 is named "1", day 2 named

How can I keep users from selecting thisworkbook without using APIs or
a custom file extension?
Thanks!
Cliff Edwards

I have written this macro to set page breaks once all info is added to the
spreadsheet.  Is there anyway to have the Macro run automatically when the
user prints or previews?  Or is it better is attach it to a button for them
to click before printing?

Hi Experts
Ned help with a little problem.. her it goes :
Got a Shared Workbook with som Comments around difrent sheets
Now i need to edit these Comments but

I have an Add-In that has some code in it to connect to an Oracle database
and retrieve data... that part works fine.
But, at theend of processing, I'd like to not only uncheck it in the AddIns
list, but also remove it from the list altogether.

Dear Friends
I am trying to use sample code by Ron de Bruin for sending mail from Excel
I want to send text string as well as html image in the body of the mail
I am unable to use both at a time