Excel user name
A while ago there was a thread here asking about excel user names -
cant find it now but id like to know how i can create a MSGBOX that ca
use names - for example the macro reads the excel user name, vlookup
short (nick) name, then gives a more personalised message.
Can anyone help?
Message posted from http://www.ExcelForum.com
"LB79 >" <<LB79.firstname.lastname@example.org> schrieb im Newsbeitrag
> A while ago there was a thread here askin...Run report on multi selected records.
I try to make a report for a custom entity that works like the Account
Summary: let's say that it's Customer's Inquiry Summary for entity Customer's
I made the report so that I'm able to run the report on Customer's Inquiry
But when I select multi records in the list of Customer's Inquiry and run
report, only one record is show in one page of the the report.
I would like to have the selected records appear in the report with each
record on each page.
How can I do this?
...Combo box list selection based on earlier selection by user
I have a form that has a combo box 1 (Product) that reads a the Product
table and has a unique id attached to each product (RO#). There is a second
combo box 2 that is RO#. Now what I would like to do is when a user selects a
Product in combo box 1, the system should lookup the Product selected from
combo box 1 and upload the corresponding RO# in the combo box 2 list. Now I
am using both combo boxes as Unbound and in the combo box 2 I have the two
columns Product and RO# - in the Criteria row of RO# I have the following:
Like IIf([Forms]![xa_f_lookup]![RO#]=" ",[Forms]![x...Can't select objects in Excel 2007
I'm trying to create a form in Excel 2007, and although I can manipulate,
copy & paste controls (check boxes, etc)
I can't select multiple objects to align them, etc.
I've checked on-line help (and have followed the instructions), and other
websites, but no one seems to have indicated a problem.
It is extremely cumbersome and I need a solution. Any ideas?
Thanks in advance,
I know this is about a year too late, but it may help others who have stumbled across this page looking for similar help.
On the Home tab, in the Editing group, click Find & Select....Lot Selection not Showing when I select PO on Receiving Entry
Usually, the Lot selection screen would pop up when I select a PO at the Line
Detail of the Receivings Entry, now it does not! And GP will let items post
without a lot number! It seems as if a setting has changed. Any ideas
Any help is appreciated.
Are you sure the item is marked to track lots? This wiould be set item by
item on the Item Maintenance Options window.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
&q...Excel Comments Indicators when viewed in IE
I have two workbooks that have been published and viewed
in Internet Explorer. Both work books have comments set
in various cells. However the first one worked fine and
when I view this in IE it shows as a small little red
character allowing me to still see the contents of the
However on the second sheet all done in the same way when
I view the comments in IE it shows as something similar
to this [_] in purple. This unfortunatly covers up the
contents of the cell. Anyone got any ideas why this is
happening and how I can change it??
...SOAP Webservice Data Source (Input object type)
I am using a SOAP webservice as the datasource for my report.
How should i specify the report query to retrieve data from a SOAP web
The input to the web service is of type 'filter' which has teh following 4
The web service wants the request to be of the form:
<PolicyID...how do I identify an unfamiliar symbol in an excel cell
The symbol underlined r has appeared in a cell but I cannot get rid of it
Strange stuff in a cell might be some kind of picture or other object. Place
the cursor on the "thing" and right-click. See if clear or delete shows up
as an option.
> The symbol underlined r has appeared in a cell but I cannot get rid of it
is it a symbol or a broken link refference... check insert symbol
MDOTJR's Profile: http://www.excelforum.com/member...Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard
I recently uninstalled and reinstalled Office 2003 and now all the built-in
custom charts are missing from Excel!
When creating a chart using the Chart Wizard, under the Custom Types tab,
there is supposed to be a list of built-in charts, when the Built-In radio
button is selected. Now, there are none.
Does anyone know how to restore those built-in charts? I have tried
reinstalling, and that does not work. Also, I could not find an option
related to this using "Modify" in Add/Remove Programs.
I have Macros that use those charts, and I also need those charts for
certain rep...named excel lists
I'm somewhat of a newbie, so I may not be asking this question with
the correct terminology. I'd like to define a name and attach it to the
range of an "excel (2003) list". If I add a new row or column to the "excel
then the range is suitable extended. How?
Try Debra Dalgleish's nice coverage of Dynamic Ranges at:
Look for "Create a Dynamic Range"
Please respond, in newsgroup
"hidden" <email@example.com...Excel Formula #10
Sorry, this will seem really simple but I haven't used excel in about 10
years and have been trying to get this sorted for hours. Here goes:
I have column C and D and need to get the sum of these two columns
calculated and shown in column E.
e.g C D E
I have no real idea how to add a formula, apparently, as every way I tried
did not work
Please help me before I go insane.
Thanks in advance
E2: =E1+C2+D...Select contact then hangs
Hi, please help. I have a user that when she selects a
contact using To: in a new email, after selecting 2, it
closes outlook??. Spec is W2kSP4\office2k with all
windows updates and office updates installed. Profile has
been deleted and re-created, plus i have set up personal
folders and moved contacts into there, and set that
folder as a default, but makes no difference.
..."Disk is full" error when opening Excel 2000.
I am getting a "disk is full" error when opening MS Excel on my laptop (not
connected to any servers/LAN). I am running Windows 2000 and my Excel
version is 2000 as well. Additionally I can not open MS Word or Adobe
Acrobat either as these applications are giving errors that it can not find
the file. Have others experienced this and if so, do you know of a solution
for fixing it?
...Selecting rows from various sheets
I have several sheets with a few columns in each. One colum
in each sheet has a unique value. Most of these unique values are th
same in each sheet but not all. Is there any way that I can set up
new sheet that will have the unique value in column 1 and th
corresponding column values frommeach sheet beside it. For example
aa 1 1 1
bb 2 2 2
cc 3 3 3
aa 4 4
cc 5 5
aa 1 1 1 4 4
bb 2 2 2
cc 3 3 3 5 5
shav's Profile: http...Embedded PDF object in web page: OneNote is launching and opening PDFs at the same time as Adobe Reader
I have a Windows 2008 Server machine with Office 2007, Adobe Reader 9, and
IE8 installed. When opening a web page with an embedded PDF control (using
<object> tag and Adobe Reader's CLASSID) in IE8, the PDF appears properly in
the Adobe PDF control embedded in the web page, but at the same time,
OneNote launches separately and opens the same PDF. How do we stop OneNote
from doing this?
We have XP Pro machines with Office 2007, Reader 9, IE8 that do not exhibit
-------- Original-Nachricht --------
> I have a Windows 2008 Serv...Tiger causing font problems with Word, Excel and PowerPoint
I upgraded my Panther operating system on a G5 to Tiger and now Word,
Excel and PowerPoint and giving me font conflict messages for all my
fonts. What do I do?
That's the notorious font corruption error that some Tiger users are seeing,
and unfortunately, there's no real solution to this. However, there are a
couple of suggestions on this page
<http://word.mvps.org/Mac/CorruptFontErrors.html>. Post back if you manage
to get it to work; the more information we can get on this topic, the
On 05.06.06 3:57, in article
firstname.lastname@example.org,...Error: Object could not be found
Using Outlook 2003 on XP Home with the MS Mail 'hack
(http://www.outlook-tips.net/howto/msmail.htm) installed, and I'
having a problem.
When composing a message, all goes well until I click Send. It the
pops up an error saying that "Operation could not be completed: Objec
could not be found". Initially, the titlebar of the messagebox sai
Microsoft Word 2003, so I assumed it was because of the editor, bu
after changing the editor (to Outlook), the error persists, only wit
the titlebar value being Microsoft Office Outlook 2003.
Any idea how I can fix thi...Cell display in 2007
After revising a formula in Excel 2007, the new number is presented overlaid
on top of the previous number in the cell. If I minimize EXCEL and then then
maximize, the cell data presents correctly. Formula, Calculation Options is
set to Automatic. The size of the spreadsheet/file does not matter. I've
only had EXCEL 2007 a few weeks and my PC is new. Our IT shop has changed
PC's virtual memory to 5120-8192 with no improvement.
There have been reports of a bug in a windows update for office 2007
Can cause "visual leaking" from one sheet to an...use of xpp & old version of excell ver 5a
Are these compatible
they seem to work ok initially
I keep getting unabe to open file after a period of use ( say 1 hour)
grateful of any help
...Slow Opening Excel Files
I have a computer that is very slow when viewing files to open from
excel(and word for that matter). The files can be accessed very quickly
from My Computer or explorer but when doing an open in Excel the list takes
forever to generate what files are in the network shares. This does not
happen when logged in as administrator, only as a standard user. Any idea's
on how to fix it? Its a optiplex 280 with 512 memory so its plenty fast
...Resizing activated embedded object in Office apps
I created sample project in VC with compound document support = full
I used simply MFC Application Wizard. Sample.Document - is prog id
run MS Word -> insert Object -> Sample.Document - object is inserted.
Try to resize embedded control - about one second object has changed
size but then it goes to original size (size of metafile picture in
what i see in MFC code:
after resizing (COleResizeBar) mfc calls
(Word doesn't change metafile size in doc file)
it calls back COleServerDoc::XOleInPlaceObject::SetObjectRects where
MFC moves...Excel Headers #2
great. that looks like it should work, but where can I put that code in
MWHCrew's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1507
View this thread: http://www.excelforum.com/showthread.php?threadid=26696
...HTML Signatures in 2007 without attachment
I am trying to set up an HTML signature with a logo in Outlook 2007 that does
not send out as an attachment. In the Microsofts Help guide there is a
posting titled- "Why cant I use HTML code in my signature anymore?" with this
The Microsoft Office Word 2007-based e-mail editor is the only e-mail editor
provided in Microsoft Office Outlook 2007. This e-mail editor does not
support HTML code in signatures.
Further into the reference it advises users to research an alternative way.
I have not found anything so far. I am assuming 2003 supported this
I used to have this option by right clicking and selecting split. However i
don't have it now. I had it on WIN2000 and now I have XP proffesional
not possible in Excel
"Roy S" <Roy S@discussions.microsoft.com> schrieb im Newsbeitrag
> I used to have this option by right clicking and selecting split.
> don't have it now. I had it on WIN2000 and now I have XP proffesional
I bet you're thinking about a table in MSWord????
Roy S wrote:
&g...select text in Calendar
I'm working on a calendar in Publisher. I'm adding text into a cell by
spacing down 1 point, then typing in 8 points. Doing fine until April. At
that time, I can only select cells (whole days). It will not let me select
the text. Help is no help. Any hints out there. Did I accidentally select
something to do this?
Have you added a picture to the cell or a shape? If you have send it to the
back, make the cell no fill and try again.
Mary Sauer MSFT MVP