I'm just finishing up  programming my file and i'm stuck. I need to
automatically save this file on Desktop for example but it will be used on
different computers. Directory names will be different. They are all running
windows OS.

How do I save the excel file with both comma AND quotation delimited fields.
i am using Office 2003 SP1.

I have a spreadsheet that I need to export to a image (GIF, JPG,
whatever...)
I found here in this newsgroup an example from Harold Staff
(http://www.mvps.org/dmcritchie/excel/xl2gif.htm) saying that works in

i created a macro in excel 11 and ran the workbook in 12 beta but i can not
find anything that looks like a way to edit the macro in 12. Do i need to do
all the editing in 11?

I need to have a button that programmatically unhides any row or rows
users have hidden manually.  The archives yield variations of this
type of code:
Range("A1").EntireRow.Hidden = False

I have worked with this for many months, and just when I think it's good it
gives me more problems!  The macro is in an Excel workbook.  It takes the
file name from the ActiveCell and the file path from the workbook's path,
and opens a Word document in the same folder as the ...

With:
Private Sub UserForm_Initialize()
UserForm1.TextBox1.Text = Sheets("Sheet2").Range("A1").Value
End Sub

Hello,
I've a quite complex (at least for me :-))  problem I should solve
within my excel (possible not using VBA).
Suppose you have this sheet:

Hi all and thanks for reading this.
I'm very green when it comes to macros but I've patched together various
bits from various places and come up with this:
Sub Tillfilepart2()

I have the following problem:
- 2 columns with amounts;
- the specific amounts can appear more than once;
- I have to compare both columns and mark (f. ex. with "yellow" filling) the

What is the asci combination required to create the equivalent of pressing
alt+enter when in a cell?
I.e. I want to print the words "Cat" and "Mat" in the same cell but on
different lines using VBA?

Hi People
I am trying to use the following code (you'll need to set up References
within the VB screen if you want to try this code):

I have a large spreadsheet that I have setup in groups of 40 rows of 60.  The
60
categories are separated by a row that is formatted with a yellow
background.  Is there a way to create a print macro that would recognize the

I need to call an application event from a standard module, the
difference here is that it needs to be called each time a new workbook
is opened.
This has been developed as an addin so that any user can install the

I'm doing a XLL file to customize excel with my own user defined
function.
It works very well.
But now, I want to make my own formula dialog to build the function.