Hello Excel Team,
Please provide help to run the below with macro or sql...
I have a space seperated text file which has the following layout ...
ACCUM  HAOPT  ABSPRI ABSGRP OUTNM  HABLIM HABTXT

Dear All
Please any one can help me.
If My Data Like
NAME                   PASSPORT    NO. ISSUED DATE          PASSPORTEXPIRY

I have a date sturcture hold information about worksheet. I need to update
this data structure when somebody close/delete worksheet.
Thanks,
Samir.

I want to search an excel sheet of around 4000 records.Now I am using file
searching.
But for each data,searching  will take around 10 sec.I want to search for
around 2000 records.Then it will take 2000*10sec=5 hrs.

Dear Excel Gurus,
I am thinking of ways to optimize a slow Excel VBA program.
Will using fixed array size instead of dynamic array significantly speed up
the operation?

Hi NG.
I have a UserForm
Private Sub UserForm_Activate()
 '// Add value to field

Usually, once I set a property like a cell's format:
Range("A1").NumberFormat = "@"
I don't need to "remember" it.  I can just read it back with:
Dim s as String

I have a visual basic 6 DLL sub that is called from a vba sub in
Excel.  I can't get the DLL to find the used range in the activesheet
and loop through each cell, categorize it and put it into an array.
Any suggestions much appreciated.

I have one problem in create a data in userform.
The problem is:
1)  I want to type the staff ID and the name will appear. I try to use
function "If" but its limited to 64 k only for every function. I also

I can't seem to get the following code to work. I want to hide / unhide a
series of rows on sheet1 based on the value in a cell in sheet2.  Once I
understand how to get it to work, I want to expand it to approx. 40 cells on
sheet2 to hide / unhide groups of rows on sheet1.

I have the following code (partial)
 Dim CurrentPrinter As Variant
   Workbooks.Open Filename:="C:\Quotes\Quote Form.xls"
   Application.CutCopyMode = False

The following is an example of the numbering format that I am using to
identify items and retrieve data in another worksheet using the VLOOKUP
function. One reason that the number sequence is not working may be related
to the gaps between each number. Or is it a limitation in the ...

Oh Wise Ones,
I have a sheet that inserts a row and formats some cells including this line
that works:
Worksheets("Open Red Tags").Range("Q4").Formula = "=IF(J4=$K$1,H4,"""")"

Hi Experts,
I am trying to repeat the procedure below (delete "Back To Contents" in 45
sheets and 11 workbooks), but I can not find the right code. I am doing with
For next, but is deleting that only in the Active worksheet.

I have the following part code included in macro 1:
Dim spath As String
spath = Range("B3").Value
  ActiveWorkbook.SaveAs spath & ".xls"