Pasting data from Excel
I'm not sure if I should be posting this question here or in the Excel
forum but here goes. Is it possible to copy data from multiple cells in
Excel and then paste them into multiple lines of the criteria section of an
Access query? For example, Given cells and values: A1- 1
I would like to be able to copy this data from Excel and paste it into an
Access query like : Criteria: 1
I am using Access 2002 SP3 and Exc...Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes.
However, the drop down boxes are not typical forms. These drop dow
boxes appear to be normal cells (They contain text). When I click o
the box, a little gray box shows up w/ a down arrow to the right of th
cell. However, if you right click on the cell, there aren't an
property options that are displayed.
I was wondering if anybody had any idea what kind of drop down box thi
is. How can I edit or create one
Message posted from http://www.ExcelForum.com
It sounds like it's under Data|Validation.
chris313 wr...how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem
unable to select all of them other than to click on each one individually.
Is there an easy way to select all of the text boxes at once?
To select multiple objects on the sheet --
Click on one object
Hold the Ctrl key, and click on additional objects
To select all the objects on the sheet --
Choose Edit>Go To, click Special
Select Objects, click OK
Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:
Select the Commands tab...How to use outlook address in Excel
I have an Excel sheet which I use as an invoicing-application. I would like
to retrieve address-data from Outlook where I keep all my contact-data of my
customers. So, I want to select a customer from my Outlook contactlist when I
am writing a new invoice in Excel.
In Word, I have a macro which does this, but unfortunately the
Application.GetAddress does not work in Excel.
Can somebody help me ?
"Henny Slokker" wrote:
> I have an Excel sheet which I use as an invoicing-application. I would like
> to retrieve address-data from Outlook where I...After Re-Install
HELP!!! After a crash and a re-install of Office we are now getting user
name and password errors in Outlook 2002. We can access the same accounts
via a www interface with the same account information. PLEASE help. I've
downloaded all the service packs for XP and Office and I've tried
un-installing and re-installing including deleting all of the profile
information I can find and deleting Outlook's registry, but to no avail. I'm
obviously missing something. Any help would be fabulous. Please e-mail
Thanks so much!!!
...excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it
prints smaller unlike older excel program.
Also when i set the margins for a spreadsheet the left hand margin wont move
over to the edge of page like right hand side?
In Page Setup: If you are using the Scaling option to print to a certain
number of pages wide by pages tall and/or you are using the columns to repeat
at left, try:
- clearing the number of pages tall value (so that it is blank), and/or
- if you are printing to one page wide, remove the columns to repeat at left
"Peter MB" wrote:
>...How do i navigate between sheet tabs from my keyboard?
It would help my data entry immensly by not having to use the mouse.
CTRL + PageUp and CTRL + PageDown to cycle through sheet tabs.
Gord Dibben Excel MVP
On Mon, 2 May 2005 17:02:02 -0700, Ryan T <Ryan T@discussions.microsoft.com>
>It would help my data entry immensly by not having to use the mouse.
ctrl-pgup and ctrl-pgdn will cycle through the worksheets.
ctrl-F6 and ctrl-shift-F6 will cycle through the open windows. (As will
ctrl-tab and shift-ctrl-tab.)
Ryan T wrote:
> It would help my data entry immensly by not having to use the mouse.
Da...Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing
Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
Is there still a way of accessing macros via Alt+F8?
Any suggestions appreciated.
ALT+F8 works for me in E2007. What do you mean by 'I get is a series of
ribbon help letters'
> In Excel 2003 I used to be able to list all macros in a workbook by pressing
> Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
> Is there still a way of...Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout
is perfect when printing to pdf (which is how the document will mostly be
used) but the layout changes if printing direct to our printer. Is there a
way that I can ONLY allow printing to pdf from this document?
You may consider using some VBA to achieve this.
One way is to use the Workbook_BeforePrint event and specify the pdf printer
in the PrintOut method, eg:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:"
Pl...Unable to change password
We have some users in domain A, who now have exchange
accounts in domain B.
They will log on to domain A as usual, then when they open
outlook it prompts them for a logon to domain B. Works
Problem is that we gave them all a standard PW for domain
B so we could check their mail was working. We now want
them to change their passwords for domain B, so we
selected 'user must change PW at next logon' in the AD.
Sure enough they are prompted to change password when they
open outlook, but the password change is never accepted.
Can anyone help?
...query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I
tell Excel to import the data it it appears to be working but never seems to
return the data. Running the same query via msquery.exe returns the data with
no problem. Can anyone tell me what the problem is ?
...EXCEL FORMULA #28
I'm trying to fine a formula which would show me how much money I would
save on a mortgage if I were to pay additional principal each month--in
addition to paying the additional principal how long would it take to pay
I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this
off as soon as possible by paying additional principal each month.
There are tons of free templates at:
Maybe you'll find something you like.
> Good afternoon,
> I'm ...OLE: Excel.Application
in VB.Net, I use Excel to display results :
dim xl as new Excel.Application // creates an Excel process
// snip (putting values into cells)
xl.Visible = true
If the user closes the Excel file and then my program,
the Excel process is killed in memory, which is good.
If the user closes my program first and then the Excel file,
the Excel process remains in memory !
How can I make sure the process will be killed ?
You need to set
(and before that ensure that excel doesn't halt and ask things like "save
changes?" on quitting) somewhere in your p...Export relationship information from Visio to Excel
Is there a way to export information regarding relationships from a visio
diagram to an excel spreadsheet?
In addition, is there a way to tell the excel spreadsheet to eliminate or
change a relationship and for that action to be applied onto the visio
as a general answer I'd have to say "no, not without custom code". You
didn't define what you meant as a relationship.
"Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message
> Hello all,
&...startup excel euro symbol
when i digit € symbol inside any application excel 2007 automacic startup and
for me is impossible to use this symbol anywhere, i use windows xp
professional ..have you a response to solve this problem?
...Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering
assignment and I have added a worksheet that is basically an
automatically generated report of all the calculations.
I have set the Print Area up in such a way so that the results are
printed out in well defined pages (e.g. page 1: title page, page 2:
summary of input variables, page 3: summary of calculation results
etc). The report is arranged vertically in the worksheet, so the pages
are 'stacked' on top of each other.
It prints out fine in Excel 2000 and 2002 but I recently upgraded to
Excel 2003 and now find tha...Size of sheet
I have created a small spreadsheet in Excel XP. I have hidden all the
unwanted columns and rows and it prints ok. However, when trying to email,
all the unused columns and rows are still present (though hidden) creating a
very large file too large to send. How do I limit the size of the sheet?
Unhide the columns/rows, select the first row (the whole row) that you want
press ctrl + shift & down arrow, then do edit>delete, save the workbook.
Repeat for the columns but press Ctrl + Shift & right arrow, finally hide
the column/rows again
...Sorting Multiple Sheets
I have a workbook with multiple sheets. The main sheet
has 2 columns, 1 for first name, 1 for last name. The
remaining sheets all have formulas to pull the first and
last names automatically from the 1st sheet. If a user
sorts the names on the first sheet, they will sort on
subsequent sheets, but the information that goes with
those names on subsequent sheets will not be included in
the sort, thereby misplacing information. Is there anyway
to remedy this, short of sorting each sheet each time
there is an addition to any one sheet?
...Linking multiple sheets
I need to set up a spreadsheet that links to 12 others. On each of the
others there may be 100 rows(or less) of information to bring in to the
master. Is it possible to write a formula that enables the link to pull in
only rows that contain information?
I don't want blank rows between each of the 12 groups of information
I'm sure an expert will chime in with something better, but I've done similar
with lookup functions. don't do it direct or it will be slow. I let
everything come over to one master workbook, then use a lookup page that
consolidates the data.
"...excel 2000 message
excel 2000 message - 'cannot use object linking and
Were they hit by the MSBlast worm?
One poster (Lutz Meyer) guessed that this was the cause of his problems. I
haven't seen any confirmation/denial, but you may want to read his post:
Post back with your results. I'm curious if that was the problem. (It's come
up quite a few times since MSBlast hit.)
bill bootle wrote:
> excel 2000 message - 'cannot use object linking and
email@example.com...Excel Graphing Line References off when chart is a sheet.
I have noticed that when any graph is created in EXCEL and you hover you
mouse over the dataline you receive that corect response. If you convert the
chart to a sheet, the hover of the data line is now not representative of the
the y axis directly below it. The data being graphed is correct now the hover
represents the "series" (x-Axis) correctly but does not represent the "Point"
(y-axis) correctly at all. Tne Y-axis datapoint reference is wrong. Any help?
...Editable Excel Spreadsheet Online?
I tried to recent find information on this, but could find very
little. How difficult would it be to host an excel spreadsheet online
where visitors to the site can directly view and edit it?
Right now, I can upload the spreadsheet to our web site and visitors
can view it, but if they edit it, they can only save it to their local
drive. I would like the users to be able to save the copy on the
What would be involved in something like this? I assume for starters
(if it's do-able) we'd need Windows hosting (we're not hosting
ourselves) and some ASP support. Any de...how do I delete documents from the start list in word and excel?
how do I delete documents from the start list in word and excel?
You can not clear it whenever you want. You can however set the no of file
names to be displayed to 0 which clears the list...
In Excel 2003
Enter 0 against 'Recently Used File List' of clear the check box.
Word has a similar option.
For 2007 versions or if you want to play with Registry Settings (not advised
unless you understand it well) see
http://www.mydigitallife.info/2008/01/13/how-to-clear-and-delete-recent-documents-list-in-office-2007-word-excel-p...Error saving Excel files in a network drive
I have a problem saving Excel files onto a network drive. I get an error
saying it was imposible to save the file. It creates a temporary file and
then I have to open it and save it as a new document. This issue doesn�t
occur saving the file in my hard disk. This happens with "Full control"
access to the shared folder...
I have Windows XP and Office 2000.
Thanks in advance
> I have a problem saving Excel files onto a network drive. I get an error
> saying it was imposible to save the file. It creates a temporary file and
> then I have to open it and sav...Import contacts from Excel into Outlook Contacts
I know this can be done from the import function in
Outlook but how does one control where each field goes?
There's a Map Fields step in the wizard.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Maurice" <firstname.lastname@example.org> wrote in message
> I know this can be done from the import function in
> Outlook but how does one control where each field goes?