see this example
[B14] =  filename
I want to paste the variable filename on the actual cell selected (not b14).
How i can modify the this string?

Any help would be appreciated... this is using Excel 2003 SP1 on WinXp SP2
The following statement works fine. It inserts a blank cell at F1 and shifts
the column down.
Range("F1").Insert xlShiftDown

Hi, I have a pivot table in Access, but there was some issue when printing.
So I am thinking of using the 'Export to MS Excel' button and then use some
VBA programming to do some grouping and sub-total.
Suppose that rows containing accounts starting with 600 are in group1, I

I have written a large spreadsheet containing several macro's. These
all work great on my pc. However, when I forward them to a colleague
the macro's cease working and require debugging.
Does anyone have any tips on to avoid this?

i noticed that my excel files are being appended by random numbers when i
open them.
eg. a file named myfile.xls, when opened will be come myfile2.xls,
etc..etc..

Hello, I would like to convert a PDF to Excel using a simple linux
command line tool.  Anyone know if that is possible?  The tool coul
also be a windows tool, but I am looking for a tool that is completel
automated, with no user intevention.  

I have two files that I rename every day.  I would like to have a
macro that I can initiate (button) that I can push every day and
rename the ex_costprday.xls to ex_costprday-(todays date).xls and then
rename the second file ex_cost.xls to ex_costprday.xls.  I then can

I import a .txt file into excel and need to format numbers to currency.
I tried to format cells with no luck, excel adds .00 to current numbers
I need a way to take 12345 and format to $123.45.  The only way is t
go to tools, options, edit and click on fixed decimal places.  Thi

I'm trying to pretty up a workbook by adding some shapes and I'm curious if
there was a way to cause a cell (and it's contents and formatting) to appear
above a shape. More specifically I'd like to add a sort of frame around a
range with a color fill gradient and shadows but have ...

Is there a way to find the # character by using "Find" when it is displayed
because the column width is not wide enough to display all the characters in
a cell?

i've this macro string for write a filename (that i select) in a cell
without the extension.
In this case the filename remove only the 3 letters of extension. I need a
macro that

I have a macro that is built to 1)update a report daily,
then 2)save it to two different locations (into two
workbooks).  I need both to be password protected to
modify.  The end of the macro looks something like this:

The scrollbar on one of 6 worksheets in an Excel program
approximately 6MB in size mysteriously stopped working. I
can no longer scroll down the page and when I try to do so
the scroll bar moves but the page is idel.

How do I load a Windows 95 database into an Excel spreadsheet?

We have 50 users, running on Windows 2003 Server, MSOffice 2000, under
Terminal Services.
On trying to open an Excel template file (invoicing) previously saved to My
Documents, the following error is displayed: