I have two workbooks A and B.  When the user opens workbook A, I would like
to have Workbook A to create a link to worksheet1 from workbook B, which
resides out on the network.  I tried various UNC path syntax to workbook B,
but it didn't work.

I have a excel spreadsheet that contains the date a request is received and
the date the request is due to the customers.  How do I create a popup that
alerts the user three days prior to the due date, which request are due?  I
will need for the popup to activate everytime the ...

I'm wondering if anyone can help me on this?
I'm using excel 2003.
I have several sheets that have different statements.
This is what i want to accomplish through vba.

I am using the DocumentComplete event to grab the text from a web
page.  The MS documentation suggests of course I need to check the
page has finally loaded.
Private Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object,

We've got an application front we've built which uses an Oracle back
end.  It has poor graphics/analytics, and we'd like to use Excel for
that portion.
The only problem is that when we open Excel and connect to Oracle, we

I hope I can explain this ok!
Worksheet A is laid out as:
ID          Task1           Task2          Task3          Task4
1            dd/mm/yy    dd/mm/yy    dd/mm/yy    dd/mm/yy

I am new to VBA programming and I am getting Out of Memory Error 7
While I assign text to a named cell like here the text contained in
the variable is huge around 8 pages. I would really appreciate if some
one can tell me an alternative way to do.

From Excel VBA, with a spreadsheet open, I would like to store the
list of all files ending in .XLS, in filename order, in the directory
that spreadsheet is in.  I would then want to process each of those
files (in filename order) and, based on a certain string I'm looking

From one Folder, many workbooks, single worksheet, same format,
append All non blank rows in
a single Master workbook, one worksheet. No summing, No calculations.
I need to see once for all a simple skeleton code of these loops,

I have some code to open 2 templates and copy some data from one to the
other. The problem I have is that one opens (template-x.xlt) whereas the
other creates a new xls based on the template (template-y1.xls).
I've posted the code segments below:

I have a bunch of cells with strings like this: (RUP((x+7)*2 +45)*2).
The actual formulas don't matter too much, other than that they aren't
all the same - there are a number of different variables and
parentheses sets.

Hi,
We know that Excel allows us to format a cell in the “Format Cells Dialog”.
Then in the program, we can get the format string using
((Range)ActiveSheet.Cells[1, 1]).NumberFormat.

Hello Gurus!
Thanks in advance for your help. I'm trying to reformat a spreadsheet so the
data will be easily entered into a database. The basics are taking data in
rows, transposing it to columns like so:

Is there a way to search for a word or text string that would only
appear in comments?  I need to find only those records that have a
particular comment.

I have a filesearch.application running in my code that works fine.  I
need to somehow within that code, open each file that it finds, search
it for a reference, and then if found print the enite line into
excel.  I have the following code that give me errors on the open