I have inherited a small project where we handle inventory data in
excel. The way it's done now is simple: Use fixed columns and import
data about the products from database 1, then loop through the colums
and import details about the products from database 2 and so on.

is it possible to connect my Excel Sheet via VBA to a socket Server on the
same machine?
In my situation I hava a service, that listen on port 13000 and sends by
accessing special data to the client. So I do only need to send data to this

What's the best way to limit scrolling on a worksheet.  I've several
differnt examples that just didn't seem to work properly.
Any ideas?
ep

In Excel I have named ranges, for example rows 13:23 are a named range
called "RijenFundering". When I select a cell in row 23 and use the
macro below to insert a row, then the empty row will be row 24. That is
outside the named range.

I'm kind of hoping that not toom much programming is required here.
What I am trying to do is have a drop down list (not on a form but using the
validation option) where the options are for example:
AN - Delivery

If column B had data ranging from Row 1 to Row 100 say, I would then want my
range in Column A to increase/decrease to match the number of rows Column B
encompasses.
Can someone help with a VBA code to do this for me?

Hi all, I have a column of over a 1000 account numbers , some of then end in C.
I would like to filter out these values into a separate column . for eg
IF last character = C then insert value else blank.
Thanks for you r help again, everyone.

I tried to write a macro in Excel VBE which should work as follows:
When I activate the macro the row where the activecell is in, should be
deleted, but only if the cell in column A (in the same row as the
activecell) is not 1. Otherwise there should be a message displayed.

Here is a curly one....I have the automatic worksheets being renamed by
a vba code. The problem I'm having is there is a macro button to hide
and unhide these same sheets. Once the names have been changed, the
sheets won't open for THAT exact reason, the macro can no longer find

anyone can do a micro for me please?
a1 has 1 number and it changes manully by me.
say a1 is 7,
what i want is when i click the button(with micro), b1-b30 will fil

I have the following code for closing the current workbook withou
saving changes >>
I want it to be developed to close all active workbooks
Code

I am using excel 2002. I want to compare a string variable with an
integer variable. i.e.
dim i as integer
i=1

could you provide me with some VBA coding that will count the tota
numbers of rows and return the value or displaying it when it is bein
run..thanks:
--

Has anyone tried doing this :
I developped a .NET Windows custom control, that I would like to insert in
an Excel Sheet when pressing a Add-in CommandButton.
I'm currently struggling with Excel Interop and OleObjects collection, hope

Am I able to run procedures as per the following code? I thought seeing
as it is a Private Sub in module "B4Close" that it would run
automatically before the workbook closes.
Private Sub Workbook_BeforeClose(Cancel As Boolean)