I have 2 files open that I need to go back and forth with.
File 1 is defined with a variable name oWB.
File 2 is called Update.xls
When I am in Update.xls and want to go back to oWB, how to I do that?  

I want to open a txt file, read it until I find a line that contains certain
info and then append additional data on to that line.  The line may be in the
middle of the file.  How can I do this?

I know this has been done ad nausiam but can someone give me the code, that
when a user clicks into a textbox the calender should pop up so as to enter
the date? This will be done in the form and not in the worksheet
Thanks

I have two workbooks (wb1, wb2). wb1 looks like this
  A     B
  2     CAT1
         cust1

This code shows updates the worksheet cell when ComboBox1 is changed.  Then
it updates CombBox2 to reflect this new change.
Private Sub ComboBox1_Change()
Worksheets("sheet1").Range("C16") = Me.ComboBox1.Value

I hope I can explain this coherantly.  We have put together a small trading
system which we plan to send out to users.  In order to accommodate future
updates, we want to be able to take the name of the user's file (which we
don't know for sure) and identify that name so that we ...

I would like a way to be able to scan a bar code into a cell then have the
cursor move automatically to the next cell to the right, or go to beginning
of next row, without having to press the "enter" or "tab" keys.  I am using
Excel 2003

I have a sheet where I originally created a global const as:
Global Const RAMPUP = "RU"
Well I decided that rather than that I wanted to do an enumeration. So I
deleted the global const and created:

I've got my combobox to apply the change made to it immediately with:
Private Sub ComboBox1_Change()
Worksheets("sheet1").Range("C16") = Me.ComboBox1.Value
End Sub

Could somebody can provide with a formula to sum Column B data for all
the data that start with "009" in column A
Ex - The formula should give me 100 as answer.
Column A    Column B

Hi Experts,
I have the following code toset a filer on a sheet called "datadga"
Private Sub but_filter_click()
Dim choice As String

I'm going to have many controls that get their values from sheet1, all on a
multipage.  Then I'll have sheet2, & sheet3, and also pages on the multipage
that are identical to the first page, except they get their data from sheet2,
sheet3.  Their are 40-50 controls each page, each ...

Why would I get a "false" error 55, file already open when doing this:
Open ThisWorkbook.Path & "\logdtls.log" For Append As #1
I am careful to always issue this:
Close #1

Hello i am hoping that you can provide some help.
I have a workbook with 2 worksheets -
Workbook A contains a record of custoemr orders - one order per row -
columns H to M contains the qty of a specifec product (each column

Just wonder anyone could advise of any code to split a file into two
before importing the files into excel....this is because the file data
has exceeded the limitation of excel(too many lines). I am looking for a
way to split a file into two(one with 30000 line of data)  while ...