I am trying to format a number field so it can be exported to a text file
for import.  I need to format numbers and remove the decimal (if it has
one), zero fill to the left (field is 15 characters) and include a positive
or negative sign on the far right.  The 15th character is ...

Is it possibe to transfer an excel worksheet over to word, and preserve the
page layout that it had in excel?
Thanks in advance
David

i'm trying to build an excel application that lets users select from a list
of choices on sheet one by checking a check box next to each line that they
want printed on a report.  I have the checkbox linked to cell z.
I want to copy columns b-k for each line to the second tab for ...

Obviously new to VBA.
I want to run a while function depending on the number of rows on
second sheet.  ex..
a = 1

I have a user form that I want to have open when

I just dont quite grasp Loops yet. :sigh:
Mainly because I rarely need them.
Any how, I'm stuck so to speak, I have 60 TextBox's to iterate thru an
check a condition, how do I complete this?

I have created a workbook that records the user name, date and time the
workbook was opened in a hidden worksheet, but as it is updated it asks
the user whether to save the workbook of the changes or not before exiting.
I would like the workbook to automatically save ONLY the ...

I am trying to match a part number with a separate .csv file to update
inventory.  My dilemma is I am using VLookup to accomplish this but
there has been some changes to the .csv file format and now the
inventory on hand is on a separate row with the part number.  Now if my

I need help with a satement that will verify the date in one
row(sheet1.A3) and a second value(sheet1.c3) are equal to set values.
If they are both equal i need to start a running total. then display
that total on a diffrent sheet.

Does anyone know where can I find information that can be useful to
understand the BIFF formats?

I have entered this VBA to change a row color if a certain condition i
met. However if is condition then changes to something other then th
specified condion I would like the row format to change back to th
original. How can I get this done? Here is what I have to change th

I'm having trouble with Excel sorting in a VBScript.  I have a number of
cells containing data, starting at row 4.  I'm trying to sort each column
from row 4 through to the end using the following code:
Set objRange = objExcel.Range(Chr(64+column)+"4", Chr(64+column)&row ).Select

I'm trying to do a comparison operator that is being printed on an export
text file.  What I am trying to do is this.  See below:
1) If columns N and M in the worksheet have data, then I want them both
stored into a string variable and then it is to be exported onto a text file.

I'm just trying to send a basic message to a list of people with
Microsoft Outlook using Excel.  I thought that it would be a great idea
to, once a macro finished, put a snippet of code that sends an email to
others that are waiting on this particular macro to finish that says

I had to format a row of numbers depending on the value above it.
I have to compare A2 to A1 and change A2 accordingly.
Problem is when A1 is a negative number the conditional formattin
doesn't work.