macro to close excel
If I have a macro to automatically run a macro when the workbooks opens, what
do I add to make Excel close after the macro finishes running.
Followed by True to save the changes or False to save with out changing.
Leave blank after and excel will prompt you.
"Pam C" <PamC@discussions.microsoft.com> wrote in message
> If I have a macro to automatically run a macro when the workbooks opens,
> do I add to make Excel close after the macro fini...Default Excel Border Colors
I have Excel 2002.
When I try to add a border to a cell, the color defaults to light grey
instead of black, even though the color control under Format>> Cells>>
Border says "Automatic". How can I change the default color for
automatic to be black instead of light grey for ALL spreadsheets?
I've seen a similar string about this before, but there was never a
resolution that worked.
looking forward to your help!
See reply in .Misc
"Bobby" <email@example.com> wrote in message
news:firstname.lastname@example.org....CSV to .PRN
I am having trouble saving a .CSV file as a .PRN format - it is cutting the
information in the sheet off about 20 columns in - any suggestions? I am
doing the basic File - Save as.
Have you formatted the sheet with a fixed-width font so you can set the field
widths exactly? What is sum of field lengths? There used to be a limit of ~240
characters per line in PRN files.
On Mon, 18 Oct 2004 10:13:08 -0700, "Melissa"
>I am having trouble saving a .CSV file as a .PRN format - it is cutting the
>information i...cell formatting zero padding on binary no's
I'm struggling through doing some binary math on excel. Ugh. You'd think
Excel is written by programmers, so they would see the value of having
some programmer-friendly bitwise math and binary, octal and hex formatting
stuff in there, if for no other reason than they could use it themselves.
Anyway, that's my rant, here's my question
I have some numbers in cells that I convert to binary
C5: 55 DEC2BIN(C5) gives me 1010101
I'd really like to display that as
.... ie with a leading zero and a space between the nibbles.
It appears that ce...Importing CSV files problem
I am currently working on a project that invloves
importing of CSV files to Excel. Double-clicking the CSV
file opens the file automatically in Excel. We have
enclosed our data in quotation marks (i.e. "SomeData") to
prevent errors arising from strings that have commas as
part of the data. This works fine for us.
However, The problem arises when we import data that look
like numbers written in scientific notation but are
actually some other data which should not be expressed in
scientific notation (example "1E306" is expressed
...Usable memory in Excel
I seem to remember reading somewhere that there is a limit to the amount of
memory that Excel can use, even if you have much more RAM available is the
For example, if your computer has 512 mb of RAM, an Excel workbook might be
able to use only 50 mb (or whatever) of it.
I can't seem to find anything to confirm or refute this. Can anyone help.
I am using Excel 2003 on a Windows XP machine.
As you will see, memory constraints were a much bigger issue before Excel
"Joe Clement" <email@example.com> wro...Why Does Excel Do This ??!!??
Open a new instance of Excel and type a few characters into any cell.
Then, open an Excel file attachment from an Outlook message. From
this (attachment) book, click the top right (application close) 'X'.
Why does Excel try to close the first book in this same action ? In
the heat of a busy day it's very easy to confuse the 'Save Changes'
file dialog that appears as applying to the current (attachment)
notebook, and, especially if it's a book that's unimportant, quickly
click no and lose the original workbook. Word doesn't do this -
closing an attachment on...importing incredimail into outlook express
Is there a way, or an add-on. or a third party software to import
Incredimail mail into outlook express mail ?
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted w...Excel error while trying to import data from an Access database
This is just an FYI for anyone who might encounter this problem (as I
just did)... =-)
::: SYMPTOM :::
In Excel, while trying to create a query into an Access database the
following error occurred:
MSQRY32.exe has generated errors and will be closed by Windows. You
will need to restart the program.
::: CAUSE :::
The Access database contains 'unfavorable' characters in the filename
(e.g. "MyAccessDatabase v1.0 (15-Mar-05).mdb" -- it doesn't like the
"." and is probably better off without the "(")
Rename the database to use a 'safe' file n...Leading Zeros SQL query
I need to add leading zeros to every item in our RMS database that uses
UPCs. Is there an SQL query that could accomplish this?
Hi wesley ,
I tried this query and it update my itemlookupcode with leading zero where
the barcode format is 9(UPCA) but please backup your data before running this
and before running this ..try to ask for second opinion...I might miss some
files that needed to be updated...
update item set itemlookupcode='0'+ rtrim(ltrim(itemlookupcode)) from item
I hope it helps :)
"wessan...Formulas in International Excel
I've used Excel in english for a long time, now I'm using a version in
my native language (Portuguese).
The problem is that the formulas in Excel-pt is in portuguese too -
now I'm lost as I need to learn everything again.
Is possible to make/config my Excel-pt to use formulas in english and
not in Portuguese?
That is depending on version. If you use Excel 2007 then you can purchase
language packs to it and switch between the languages.
Best wishes Harald
"Defranco" <firstname.lastname@example.org> wrote in message
news:6b45b6eb-0a87-4abb-b9a5-cfae3000d4...importing account info into production CRM
Has anyone used the DMF to do a secondary import of data into a live CRM
environment? I know it is not intended for this purpose, however in this
client's scenario they have no data whatsoever in Accounts (they use only
leads and contacts currently, but a different department wants to use
accounts now). I want to import some account data that is totally unrelated
to their existing contacts. I figure I can use the DMF to do this. Anyone
have any thoughts/tips/cautions???
It is possible to do this. I have done an imp...Creating a csv
I have a spreadsheet with a list of email addresses in the first column. I
want to create a CSV file. If I choose Save as---> csv and then open the csv
file in Notepad the list is saved as a list with carriage returns after each
email address and no commas. So how do i turn the list into a continuous list
with no breaks and a comma seperating each one? I'm using Excel 2007
Open the file in MSWord and do an edit|replace (or the MSWord 2007 equivalent)
to change the paragraph mark (under the More button and then under the Special
button) to a comma.
Tony Williams wrote:
...CSV elements don't get split up in cells
I recently installed a German version of excel and now when I open m
CSV files they don't get seperated anymore by the commas. The whol
line is just written in one cell.
When I had the US version installed the data was split up after eac
comma and distributed into the corresponding cell.
How can I achieve the same thing in the German version
Message posted from http://www.ExcelForum.com
You could try renaming the file to .txt rather than .csv When you try to
open this in Excel it will start the Text Import Wizard which will give you
much more control over the import of th...Excel 2003 #9
Hi there I am unable to find the command "assign macro" to the command
button when I use it in a spreadsheet.
Is this only available in certain versions .
Thank you for any help
There are two toolbars that contain buttons.
The Forms toolbar has the button you wanted to use.
You used a commandbutton from the Control toolbox toolbar.
terry b wrote:
> Hi there I am unable to find the command "assign macro" to the command
> button when I use it in a spreadsheet.
> Is this only available in certain versions .
> Thank you for any help
> Ter...Import data from Excel with main tasks and subtasks
I'm new to MS Project and need help with importing data from Excel into
Project 2000. The data consists of Work Request numbers, individual phase
numbers for the Work Request, name of each phase, and (phase) start and end
I can open the Excel file in Project and map the fields, however, the data
shows up as individual tasks. I need to have the Work Request number and
project name be a main, or top-level, task, and the data related to the
phases be sub-tasks.
Here's an example of how the raw data appears in the Excel file:
Phase# P...how do I import footnotes to a publisher document ?
When I import a word document into plublisher, the footnotes do not show up.
How can I import the Whole document incluiding the footnotes
In Publisher 2002, one has to create headers/footers and then copy and paste
footnote text, because Publisher 2002 does not support footnotes directly..
Bear in mind that MS Publisher is a frame-based desktop publisher, as
opposed to MS Word that is a full blown word processor..
MVP - Windows Shell/user
"Tripleaxel1" <Tripleaxel1@discussions.microsoft.com> wrote in message
I'm trying to import e-mails from Thunderbird but I keep
getting an error that "The mail folder could not be
opened. If another application is using this file, please
close it and try again." There si nothing else using it.
I've rebooted, I've coppied the fiels to another
directory, I've renamed the files but I can't get my
Outlook 2003 e-mails back in Outlook.
"Brian E" <beshlemanREMOVE@aains.com> wrote in message
> I'm trying to import e-mails from Thunderbird but I keep
>...How to do listwise deletion in SPSS or Excel?
I asked similar question some time ago. However, I still can't
completely understand the feedbacks kindly provided. So, I try to ask
the question more specificly once again.
Imaging in the SPSS or Excel data set, the horizon from left to
right are variable 1 to variable 16; the vertical from top to down are
invidual reponses 1000 cases. Some individuals don't answer all the
16 questions (variables). I only want the individuals (cases) that
answer all the 16 questions (variables). I don't need the invidual
cases that don't answer all the 16 questions (variable...Excel & birthdays
How do I get excel to accept a birthdate by entering keystrokes 09201950 into
Regards Ron de Bruin
"Norma" <Norma@discussions.microsoft.com> wrote in message news:D68F1D36-5C5A-4803-9DFF-9891BD744BC0@microsoft.com...
> How do I get excel to accept a birthdate by entering keystrokes 09201950 into
> a cell?
Go into Format --> Cell --> Number tab, and select 'Custom'. In the box
labelled "Type", you should be able to type in MMDDYYYY.
"Norma" wrote...Saving As .CSV
Hello, here's the situation: I downloaded an .xls file from my broker and
opened it in Excel. The original file was delimited by commas and I had to
choose comma delimited in order for Excel to display it in columns/rows
correctly. I made some changes to the file, then saved it with a new name.
The problem is, I can find no way to save it as a comma delimited file
again. Saving it as a Workbook places quotes around the commas and creates
spacing between text (when I view it in Wordpad), and saving it as a Text
File (Tab delimited) does just that--makes it TAB delimited, not comma...Excel Reader/viewer
I went to MS support and found a reader for Excel 97 & 2000 for the poor
souls that don't have Office but...none for 2002 and later. Anyone know why?
this reader also can open files saved with Excel 2002/2003
> Hi folks,
> I went to MS support and found a reader for Excel 97 & 2000 for the
> poor souls that don't have Office but...none for 2002 and later.
> Anyone know why?
Will this reader work for XP Home? I can't find any Home readers for Excel, and I...footnote numbers not superscripted and are too big
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Power PC
For some reason the footnote numbers in my text are full-sized and not superscripted. The notes themselves are OK.
That's due to the formatting of your Footnote Reference style.
Use Format>Style to change it.
On 19/03/10 10:48 AM, in article 59bb581a.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <firstname.lastname@example.org> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Power
> PC For some reason the footnote number...Import of PST Files into Exchange 2003
I am setting up an Exchange 2003 environment and was wondering if
there was a limit to the PST file size that can be imported into a
We have a coupe of users who have PST files of about 1 1/2 GB and I
needed to know if I would have a problem importing files of this size.
Thanks for any insights.
> Hi All,
> I am setting up an Exchange 2003 environment and was wondering if
> there was a limit to the PST file size that can be imported into a
> users mailbox.
> We have a coupe of users who have PST files of about 1 1/2 GB and I
> n...Automatic import
Do you know a command line to import data from files ?
I just want to do an automatic import from a dbf file every day without any
intervention from a user.
Is it possible ?
I don't think there's a command line for it. You'd either have to write code
that uses the API to do what you want or use a button-pressing script to do
what you want.
"news.microsoft.com" <email@example.com> wrote in message
> Do you know a command line to import data from files ?
> I just want to do an aut...