Copying cell contents
I am using Excel 2000. I need to copy a name that is located on Sheet 1
cell A5 to a certain cell on Sheet 2. I was hoping to put a formula in my
Sheet 2 cell that would automatically place the name there for me, but so
far I haven't been able to get anything to work.
I don't want to use a macro for this. Can anyone please help?
in the cell in sheeet 2 type
note exclamation mark <!> which is the key above tab
On Fri, 22 Oct 2004 08:43:37 -0500, John Kitchens <firstname.lastname@example.org>
> I am using Excel 2000. I need to copy a name that is locat...What file stores my letters
I am going to format my hard drive and I want to keep my letters. what
extension do I need to copy and in what folder are they in. BTW, my address
is book as well.
Try search. Asked and answered about a hundred times a month
"Berto" <Albertocarro@yahoo.com> wrote in message
> I am going to format my hard drive and I want to keep my letters. what
> extension do I need to copy and in what folder are they in. BTW, my
> is book as well.
> Thank you,
...Change in font and color
I have a spreadsheet and the font is all one type and color. Now I want to
add more data in in certain columns, but with all the new data i want in a
different font and color. how do i change the font and color for all of the
new data going forwards.
Select the cells you will be adding more data to and change the formatting.
You could do that automatically using event code.
Where do you currently have formatted data and where would you be entering
Gord Dibben MS Excel MVP
On Wed, 21 Jan 2009 12:04:01 -0800, dberger16 <email@example.com> wro...Changing display name in Windows Mail
Currently my email in Windows Mail displays just my wife's name when a person
receives an email from us. Would like to change that to both of our names??
In Windows Live Mail go to Tools, Accounts, select that account, click =
On the General tab, make changes to the Name field as desired. Click OK.
Gary VanderMolen, Microsoft MVP (Mail)
Microsoft MVP program: http://mvp.support.microsoft.com
"pickle" <firstname.lastname@example.org> wrote in message =
news:F4162B8D-0520-47DE-8F3A-13172B38D7A8@microsoft.com.....using parent (account or contact) info in Address change workflow
CRM 4 with Rollup 1
I've created a w/f to send an email alert when an address changes (talking
about the customeraddress entity, not the addresses on the account/contact
forms). The workflow fires as expected, but in the email body I try to use
the parent entity (either account or contact) name/full name and it's always
blank. There's data in the fields I'm trying to use, but they do not get
included in the email.
Anyone else seen this?
a while ago (pre-SP1) I reported some bugs around customeraddress to
Microsoft...They looked ...#if in .rc file
Can preprocessor directives be used in .rc files?
It's appearing to me they cannot. I am trying to do a conditional include
of resources in my app.rc file and it looks like it's including both parts
of the conditional.
#if defined (_DEFX)
#include "blah, blah"
#include "yada, yada"
"Eric Margheim" <NOSPAMemail@example.com***NOSPAM> wrote in message
> Can preprocessor directives be used in .rc files?
> It's appearing to me they cannot. I am trying to do a condit...how can I save a file as *.iif
I export my bank transactions to an *iif file. If I import everything I have
duplicate checks and other information such as "Imported Income" that I have
to change within quickbooks. I'd rather edit the *.iif file and imported a
correct one. I cannot seem to import the corrected file. *iif is not one of
my "save as" options. txt files won't import. Does anyone have a work
Do you have the All files (*.*) option? then you can specify your full
PS what is iif?
> I export my bank tran...Split cell content
I have a large spreadsheet which contains a list of equipment, the equipment
format is K-XX-ABCD-12, I want to remove the prefix K- from the cell, the
issue I have is within the 2nd part of the equipment ID there are some that
have XK-, so I can't just do a find & replace K-
Has anyone got any suggestions?
If the part id ALWAYS starts with K-, then:
=MID(A1,3,256) will remove the first two characters.
Gary''s Student - gsnu201001
> I have a large spreadsheet which contains a list of equipment, the equipment
> format is K...change the height in the detail section > 22"
How can I cange the height in the detail section of the form over the 22
You can't. It's a hard-and-fast limit.
Why do you feel you need to?
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Benno" <Benno@discussions.microsoft.com> wrote in message
> How can I cange the height in the detail section of the form over the 22
> inches limit?
"Douglas J. Steele" wrote:
> You can't. It's a hard-and-fast limit.
> Why do y...Q: Changing default contacts folder
I am helping a friend. He is on XP and using Outlook. The "About"
section says "2003 11.8313.8221 sp3".
He had an contacts folder named "contacts'. He created another foldr
called "contacts 1".
How does he make the new folder (contacts 1) the default?
When he starts typing a name in the "TO:" lines of emails, Outlook
still picks up emails from the older "contacts" folder.
You can't make another Contacts Folder the default. Nor do you need to. You
can easily select a different Contacts Folder as ...AppleScript to keep Office 2004 or X from opening files and database on wrong drive?
I've noticed that immediately after I've cloned volumes to the backup
internal hard drive with Retrospect's "Duplicate" feature, the first time I
click on a Word or Excel file alias, it leads to the wrong drive.
It seems that that the files on the backup drive at that point might be seen
by OS 10.3.x (and Office) as newer/more recent than what's on the primary
drive from which they've been cloned..
I was told that there "always" have been "minor issues" with Retrospect and
aliases. Unfortunately, I learned from experience that "minor&qu...Get size of file mapping
I have handle to a file mapping object (arrived from another process). I don't know
anything about it. I can only call MapViewOfFile to get address to read or write.
But how large is this block. Is there any function to get size of the file mapping?
Thank for any idea.
...Track changes #3
I am using Windows 2K Professional & Office97.
I have a macro in an access mdb that outputs various files in excel format.
Is it possible either:
to use access VBA instead of the access macro to specify that the excel
'Track Changes' option is automatically set to 'True'; or
to specify elsewhere that all new excel files to have the 'Track Changes'
option automatically set to 'True'
In either case, the sub-options 'When' should be set to All, 'Who' set to
Everyone, and 'Where' should be left blank (i.e. applies to the who...DPM 2010 RC + Hyper-V R2 CSV with EMC VSS Hardware Provider
Is the EMC VSS Hardware Provider supported for parallel backups of VM's on a
Cluster Shared Volume via DPM 2010 RC?
4x HP BL480c blades
connected via FC to EMC Clariion CX3-20 SAN
Windows Server 2008 R2 Datacenter x64 RTM + Hyper-V role
Hotfixes installed: KB975343 & KB975921 + KB975688 (required by EMC for
VSS Hardware Provider:
EMC VSS Hardware Provider ver 4.2 Rev: A03
EMC Solutions Enabler 7.1
DPM 2010 RC
I'm bumping this as I have setup my environment as listed below but keep
getting the following...Converting Outlook files #2
In a magazine article that I read, it said that when moving from Outlook 2002 or
earlier to Outlook 2003, you should convert the file to the new format that is
found in 2003, but how can I do that
BTW. I don't want to loose all of the documents and setting that are already
associated with the current file
Thank you in Advance
Merci a l'Avance
In Outlook 2003, File->New->Outlook Data File->Type->Personal Folders File.
Do not select the 97-2002 format. Then drag and drop your folders from the
old to the new.
Milly Staples [MVP - Outlook]
Post...Change Excel Icon
Is there any way that the Excel Icon can be changed (without creating a
shotcut) but still open as an excel application when clicked?
Right click the icon, go to properties, select Change Icon.
"kevin" <firstname.lastname@example.org> wrote in message
> Is there any way that the Excel Icon can be changed (without creating a
> shotcut) but still open as an excel application when clicked?
> Many Thanks.
AFAIK you cannot change the icon for the Excel.exe...Unintended change to Excel VBA code
A few days back, I posted a similar message to the main Access newsgroup,
due to a situation with a networked Access database, concerning VBA code
behind an Access user form. The feedback suggested that I re-save the Access
..mdb file as an .mde, and that seems to have solved the issue.
Now it's happened again, but in an Excel workbook. The workbook has much VBA
code, and the subroutines run in response to custom menu items. These subs
have been running for several years with no problems. The sole user of the
workbook has now encountered a compile error and tells me that the VBA shows
her..."Ask always before opening this file type" cannot be unchecked
Windows Vista Ultimate, Outlook 2007, no Google desktop installed
The following issue: When trying to open or save an attachment (word, excel,
powerpoint), you get a dialogue box asking whether you want to save/open the
file. In the last line, there is a checkbox "Ask always before opening this
file type". This checkbox is gray, and cannot be unchecked (view here:
http://www.poetzsch-consulting.de/test/Nachfrage.jpg). Strange enough, this
issue ocurrs with all attachments, except pdfs. For pdfs, for instance, the
box can be unchecked.
How the box can be made accessable? Any c...file locked
when trying to open my EXCEL file, I receive the message:
"filename" locked for editing
It seems, that I was editing this file, while ?? my computer crashed ?? And
since then the file is locked.
Fortunately, I can continue to work with a copy of the file. Nevertheless,
could you please tell me, what I have to do in order to delete this locked
I am running Windows 2000 and Excel 2002.
thanks, and best regards
Go clear out your temp files in C:\Windows\Temp. When you open a file in Excel, it creates a
copy of that file and stores it as ...the rc editor changes some contents without my consent when .rc files saved
My colleagues and I are using VS 2005. After I make some minor changes
to a .rc file (obtained from my colleagues) and save it, the compiler
greatly changes the .rc in addition to my minor changes. For example,
the following 2 lines
IDD_DLG_MODELIST DIALOG DISCARDABLE 0, 0, 270, 149
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
IDD_DLG_MODELIST DIALOG 0, 0, 270, 149
STYLE DS_SETFONT | DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
Or the following 2 lines become one line:
COMBOBOX IDC_POSTDLG_COMBO_UNITS,165,5,49,49,CBS_DROPDOWNLIST |
WS_VSCROLL | WS...How do I save autofilter data
I have a spreadsheet that uses autofilters. I want to apply some filters and
save the Excel spreadsheet with a different name and remove the autofilter.
I know I could cut and paste the data, but I'm looking for a better way.
Without code there is not a way of moving the data, you might consider
Advanced filter which will move the data to another part of the sheet, you
can then delete the original data and save as a new file (not sure that's
Have you considered using Custom views? This allows you to save various
filter settings and simply select the view to cha...VS2010 RC hogs VS2008 .sln files
In the past, clicking on an .SNL file generally spawned the version of
VS that created it. And r-clicking would bring up several options,
including "Visual Studio Version Selector", which essentiall did the
same as above.
After installing VS2010 RC on a machine that already had VS2008
Ultimate loaded, the VS Version Selector always opens VS2010, despite
the original files having been built with VS2008. And simply clicking
on one of the .SLN files (again, from VS2008) always brings up VS2010.
There is no context menu (R-Click) for VS2008, even after specifically
browsing t...How to suspend XP without exiting window?
For XP with SP3, I have tried sleep mode, but the fan and power for my PC are
still on, I would like to suspend XP, which the fan and power will be off.
Does anyone have any suggestions on how to suspend XP without exiting window?
Thanks in advance for any suggestions
You'll have to hibernate the machine.
> For XP with SP3, I have tried sleep mode, but the fan and power for my PC are
> still on, I would like to suspend XP, which the fan and power will be off.
> Does anyone have any suggestions on how to suspend XP without exiting window?
&...Office 2007. Save HTML
I have numerous Office 2003 (Excel) files saved as HTML. I've just upgraded
to 0FFICE 2007 and need to create some new HTML files but I can't find a
command to achieve this. Has it been removed or am I missing something?
Office button - click SaveAs
In the dropdown select HTML and save in the normal way.
"phil j." wrote:
> I have numerous Office 2003 (Excel) files saved as HTML. I've just upgraded
> to 0FFICE 2007 and need to create some new HTML files but I can't find a
> command to achieve this. Has it been removed or am I ...How do I get and install the PSTPRX.dll file for Office XP?
I am missing the pstprx.dll file in Outlook. Need help in finding the file
and installing. Can't use Outlook untill this file is installed. Any ideas?
1.. Close Outlook XP
2.. From Control Panel, double-click Mail .
3.. Click Show Profiles
4.. Remove All profiles.
5.. Click Ok.
6.. Run this to reconfigure your mail account:
"Alex" <Alex@discussions.microsoft.com> wrote in message
>I am missing the pstprx.dll file in Outlook...