Forgive me if this has been posted here. I'm new and am having a huge
problem searching for an answer on the net.
I have a column with item numbers, and another column with letters
listed where each letter is a version of that item number.

i try to insert a file (*.pdf) wich is referenced in an xl-sheet into a sql
database.
the required fileformat is blob.
I found the following code for doing this in VB.

Hi,
I have a worksheet of data.
I would like some code that will search down column F for 'RBK' when found
copy cells C:J of the next row, paste this into next avaiable row in column

Hoping that some kind soul can help me here.
My custom spreadsheet employs a split pane view. So there is a
vertical scrollbar for the
top pane and a vertical scrollbar for the lower, more important pane.

I am attempting to find the monthly payment of a loan, for example a
car loan. I have found the formula P=(C*r*((1+r)^N))/(((1+r)^N)-1)
* ,
where C- Loan Amount; N-# of Payments ; r = ARP/ compounding

Could someone please tell me what I'm missing with using the goalseek
method?
A test spreadsheet taken from MSDN: GoalSeek Method [Excel 2003 VBA
Language Reference] illustrates the problem. Calling the VBA

I would like a popup message to inform the user that the budgeted value they
entered in a cell is larger than 1.0825 times the old amount.  This is for
departments submitting budget for 2007 and there is a cap of 8.25% on
increases.  The message box would serve as a reminder to ...

I have added a combo-box control to a worksheet.
The ListFillRange for the combo-box is a named range
(DespList1!AllDepartments)
This works OK.

Has anybody got a piece of code that can convert a nuber in a cell, say A1
and display it as a 7 digit binary number in B1?
I have tried to do this working from the 7th digit backwards using
combinations of 'if' and 'and' functions, but by the time I get to the 5/4

From Excel I want to open a MS Access Database and run a macro within it.
Can anyone please tell me the Excel VBA line code to do this?
Thanks KEN

How can I guaranteed that fractions ("5/16" etc) are displayed rather than
dates or decimals in my user forms, Excel cells, and Word bookmarks?
I have tried many things, including formating the Excel cells (Format
Cells...), using Format(data,"# ??/??"), using Application ...

Is there any way that I can identify macros that are defined but not
used (ie, not assigned to a button, not called from other macros that
are assigned to buttons, etc.)?
This would be very helpful!

I have set my regional settings to English(UK). Is it possible to
change the number format to Arabic(Saudi Arabia) and back to
English(UK) by code?
So that I will run a report using either of the number format.

Hi,
After developing a macro to create worksheets based on inputted employee
names contained in C10:C408 on my Summary Sheet (5th sheet), I need to update
links to these constantly changing 200+ spreadsheets (6th sheet and on).

I use excel to track information on a couple hundred switches and was
wondering if the following is possible.
Each row contains information on each switch including its IP address,
is it possible to launch an external application and pass the IP