Good Evening,
I wonder if somebody could point me in the right direction with a query
I have?
I have a macro that currently parses a file looking for certain text

If I have 5 and you have 6, how many have you got?

I have some VBA that calculates the quantity of time that is required t
be entered and when.
This uses a table of release dates for various products.
I am producing a spreadsheet that will contain a simple list of projec

I don't know if I am on the good group, sorry.
I have the following thing :
AS400 <---------> Firewall <-----------> PC with client access & excel
If I want to connect to the AS400 with excel (with ODBC) it does not work.

Hi. I want to know how i can protect the access of non-authorized user to
view the content of one spreadsheet of all workbook.
The reason is my company has a sales report that it can be viewed for all
user but there are 1 spreadsheet that contain confidential information (in

So, I'm trying to make a user form where I can have the user select
some fields to search in a huge database. For example, they will be
able to choose Male/Female.... Age Group.... etc.
I have tried to record a macro and see how the code works to get the

Hi,
I have cell A1 = 10 and B1 = -
This must change A1 to -10
I have no other option, I cannot use any other cells for joining,

I have made a label for my site within my userform, how can I make it load my
site?

can anyone tell me where the standard directory is where Excel finds
dll-files that can be called in an API-function call?
In order to make PDF-files, I read this text:
"You will need to place the Ghostscript DLL where it can be found

I am currently using a macro that allows me to insert a row preserving
formulas by a doubleclick.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)

I am new to VBA and need help on the following problem:
I have  a workbook with 2 types of worksheets. 2 permanent worksheet in
the begining and 2 and the end of the work book. In between theses
worksheets are a variable amount of sheets which a user can create.

I'm hoping someone can help me out.
I've been running a data filter macro
Range("hist_data").AdvancedFilter Action:=xlFilterCopy, _
           criteriarange:=Range("job_crit"), _    

Is there a good way to test if the excel file hasn't been changed since it
was last saved?
We thought about computing the hashvalue but we noticed that when the excel
file is opened and closed without changing anything it changes its last

I have written a bit of a macro to email the active sheet in an excel (as
below).
I want the marco to look at cell A29 in the sheet and use the value that is
in that cell as as the recipient email address.  However not sure how to do

I'm using COM automation inside an xll to program Excel.
At one point in the code, I do the following to retreive a Range of
cells :
"range = range.GetResize(COleVariant(rows), COleVariant(cols));"