I have Excel 2003 and I already have a macro to popup a open file dialog.
However, it always starts at "C:\My Documents" folder.  I want it to browse
files to open from a specific directory.  How is this done?  Note that I
already have the "ChDir" on the line above the ...

I tried to make a macro to do this, but I failed.
I need to do this: in the same row I want to copy the contents of one cell
and then copy the same contents into the next cell to the right, and then
delete the contents in the left cell.

I'm trying to check out repeated value on column Q and the hightlighted
entire cell on the left.I put the code that found from Sample,and trying
to modified it but I made a mistake.I can't select entire cell on the left,
I just can highlight 2 cell ( offset(0.-3) and the cell on ...

Using Excel 2003, I want to create a "report" with each row a separate page,
(printed), with my own custom formatted layout. (A dirty solution is to
transpose the page, and expand the columns so wide that they only print the
first+1 column on each page.)

Let me try this a different way...
I am using Excel 2003 and I've got a chart that is linked to data
located on another sheet within the same workbook.  It is a weekly
production report and it always records a 0 for the weekends since we do

How do you calculate two dates with hours, minutes and seconds included...
Also, the data is all numbers like 20080514235050 to 20080515000505
(yyyymmddhhmmss)...  Thanks..

Hi Expert,
Before when I saved an Excel file to .CSV format and open it from notepad,  
it automatically adds double quotes to cell values, such as:
"abc", "def","xyz"

I have problem with some of the macros in modules missing in
personal.xls . I have multiple macros in multiple modules in my
personal.xls. When I try to make a copy of the personal.xls on the
same machine, the new copy of the personal.xls has some modules

Using an older version, MS Excel 97
Some simple stuff, but I have a single column of numbers that for
some
reason, is taking up two row spaces, while everything else is taking

Is there a way to do a search for all fields that contain more than 1000
alphanumeric characters?

Aaaaargh... my Copy and Paste have stopped working.  I've tried on existing
spreadsheets, and new ones.  I've tried using a right mouse click, keyboard
shortcuts and the menu icons.  But nothing works.  What's happened???????????
Thanks.  Sue

sorry I might use the wrong english terms as I am using the German
version of Excel 2007.
I made a query with MS Query from one Excel-table to another Excel-
table.

hi,  
i got notify mail and when i try to open that it displayed blank page

I have a large spreadsheet with part numbers and prices. Have a second
worksheet with part numbers and  special prices. I want to have the first
sheet cell to format bold/colur if the part number appears in the special
list in the second sheet which is dynamic. Parts are being ...

I sometimes use Msft Access to run a query, and then revise the query,
or build off of the new query by creating a separate query of that
query.
However, in using excel, at least at first pass, I noticed that I was