Pasting data from ExcelHello everyone,
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
A2- 2
A3- 3
I would like to be able to copy this data from Excel and paste it into an
Access query like : Criteria: 1
or: 2
3
I am using Access 2002 SP3 and Exc...
Excel Drop Down BoxI'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 use outlook address in ExcelHello,
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:
> Hello,
>
> I have an Excel sheet which I use as an invoicing-application. I would like
> to retrieve address-data from Outlook where I...
Unable to create email rules! Any suggestions...??Hi, I would like to create a rule for Outlook 2003 email, but I find no
"rules and alerts" option under the "Tools" menu. It is entirely absent, not
grayed out.
(When I've looked up how to create a rule, it states you click on "rules and
alerts" under "Tools")
Would appreciate suggestions.
Do you have a mail account installed? Are you in the in-box when you look
for this option?
--
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 wi...
how to select multiple text boxes in excel for formattingI 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:
Choose Tools>Customize
Select the Commands tab...
excel margin issues on landscapeWhen 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
Simon
"Peter MB" wrote:
>...
Excel macro listIn 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.
Hi,
ALT+F8 works for me in E2007. What do you mean by 'I get is a series of
ribbon help letters'
Mike
"pbaker6" wrote:
> 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...
why can't I get outlook to send when I'm emailing a webpage?Hi. When I try to email a webpage to someone, Outlook immediately opens with
the email template but it is always missing the send button and there is no
option under actions to send it either. What is going on? Thanks!!!
If you tell us your Outlook version and Windows version, and exactly what
you're doing to send the page, then you'll have a better chance of getting a
response. The Internet Explorer version might also be helpful.
--
TechieBird
http://bwain-dump.blogspot.com
"reinadelmar" wrote:
> Hi. When I try to email a webpage to someone, Outlook immediately...
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?
Hello
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:"
End Sub
Pl...
query will not write to excelI 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 ?
...
Shared/Group EmailI'm coming from having worked with FirstClass as an email and calendar system
and had access to a shared group that all members of the organization could
both post and read mail items in. Is there a way in Outlook that this can
also be done? thanks
"Jo-Anne" <Jo-Anne@discussions.microsoft.com> wrote in message
news:FEA38DD5-1895-455B-BAA4-0D5FB8DE5D4A@microsoft.com...
> I'm coming from having worked with FirstClass as an email and calendar
> system
> and had access to a shared group that all members of the organization
> could
> both ...
EXCEL FORMULA #28Good afternoon,
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
off.
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:
http://office.microsoft.com/en-us/default.aspx
Maybe you'll find something you like.
Kam1999i wrote:
>
> Good afternoon,
>
> I'm ...
OLE: Excel.ApplicationHello,
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 ?
Thanks !
Hi
You need to set
xl.quit
(and before that ensure that excel doesn't halt and ask things like "save
changes?" on quitting) somewhere in your p...
Where can I delete an old/incorrect email address?
I'm using Outlook 2003
So I have, say, Sandy in my contacts book.
Her email is SW@......
Later her email changes to SAW@......
I make the change in my contacts.
But when I'm creating a new email and I start to type "Sandy..." in the TO
field, it still finds the old "SW@..." address. Why?
How can I delete that old & incorrect address forever?
(Without starting from scratch and loosing all my old email?)
Thanks
Gary
use arrow keys to highlight 'bad' address then hit delete btn
"jabadoodle" <jabadoodle@yahoo.com> wrote in message
n...
startup excel euro symbolwhen 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?
thanks
...
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...
Export relationship information from Visio to ExcelHello all,
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
diagram?
thanks,
ivan
as a general answer I'd have to say "no, not without custom code". You
didn't define what you meant as a relationship.
al
"Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message
news:6332A594-E4AF-4E8B-BA2D-7A4BC17962B3@microsoft.com...
> Hello all,
>
&...
how do I set up my email with outlookI have just installed outlook but I can send emails form outlook, what do I
need to set up and to link to yahoo?
tokyo gyoza wrote:
> I have just installed outlook but I can send emails form outlook,
> what do I need to set up and to link to yahoo?
You have to pay Yahoo if you want to use it in Outlook (via POP).
...
Undeliverable email message..._My ISP migrated to a new smtp server and I had to make
the necessary changes to relay my messages correctly.
However, when I forward an e-mail or reply to a cashed
mail address I receive the following:
From: System Administrator
Sent: Monday, October 04, 2004 4:26 PM
To: email@domain.com
Subject: Undeliverable:RE: Message
Your message did not reach some or all of the intended
recipients.
Subject: RE: Message
Sent: 10/4/2004 4:26 PM
The following recipient(s) could not be reached:
email@domain.com on 10/4/2004 4:26 PM
You do ...
How to paste animation in publisher for an email messageIn a MS Publisher document, I have pasted animated bmp & gif files. When I
send the doc by MS Outlook email, the animation doesn't work when the message
is pulled up. Is there a special way to paste & activate animation in
Publisher?
This is not an option in Publisher. Publisher automatically changes the
animated images to normal images.
--
Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Flyboy" <Flyboy@discussions.microsoft.com> wrote in message
news:...
excel 2000 messageexcel 2000 message - 'cannot use object linking and
embedding'
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:
http://groups.google.com/groups?threadm=3F3971AF.FA4490F5%40msn.com
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
> embedding'
--
Dave Peterson
ec35720@msn.c...
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?Hi,
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
server.
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...
outlook 2003 missing emails offlineI am trying to setup a user with an offline folder in
outlook 2003. The problem is it does not download all his
emails. ON the server it shows he has 200 emails, but in
his offline it is only 30. I checked and there is no
filters or anything on it. I tried recreating his offline
folders and everything, to no avail. Any suggestions?
It looks like the emails he is missing are a month or so
old, although he has older ones from a few years ago?
Did you check to see which folders are set for offline synch? Is this user
using Exchange Cached Mode?
--�
Milly Staples [MVP - Outlook]
Post al...
Allow Account Description changes in "Mass Modify" screenIn the "Mass Modify" screen of Account Maintenance "Cards", there should be a
selection for Description changes. Some of our Accounts have 45-50 account
combinations. If an account needs to be renamed, I have to go into each card
to update.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click ...