moving normal.dot, excel customizations to new computer
Excel 2002 SP3
Win XP Pro
I have customized my toolbar with custom menu items for macros, etc.
I am now migrating to a new computer with same version of Excel; but
would like to take with me the customizations, both as to tool bars and
menu items, etc.; and macros (I guess I'll have to import the files
containing the macros).
For the customizations, is it just a matter of exporting/copying a files
such as normal.dot (as in Word), etc.?
Any suggestions in helping me achieve a smooth transition and replicate
same setup on new computer as in old, would be very appreciated.
Do a wi...Is it safe to post WM_COMMAND to the main window?
I'd like to programmatically invoke a command that is 'normally' invoked by
a menu item. Let's say there is a menu item with command ID_FILE_OPEN.
When a user clicks on a the menu item a file dialog is displayed. I'd like
to invoke the same command programmatically (e.g. from one of CWinThreads
that my app creates). I think I could do that by simply posting a command
message with wparam set to ID_FILE_OPEN. Example:
AfxGetMainWnd()->PostMessage(WM_COMMAND, ID_FILE_OPEN). If I post the
message to the main window then - I think - command routing should properl...Customizing Excel Titlelbar???
Is it possible to customize the Excel titlebar display or selectively
eliminate the titlebar entirely using visual basic or manual settings???
>Is it possible to customize the Excel titlebar display or selectively
>eliminate the titlebar entirely using visual basic or manual settings???
...PHP pages with IIS 6
How to integered PHP in IIS without GDI errors in Internet explorer
Thanks for advance
Sorry, this newsgroup is for questions about Access, the database product
that's part of Office Professional.
Your question should be reposted to a more appropriate newsgroup, such as
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"fm" <email@example.com> wrote in message
> How to integered PHP in IIS without GDI errors in Internet explorer
&...Export DataTable to XML using XSL file
I'd like to get a populated datatable, create an in memory xml document
(file shouldn't be more than a couple of meg), load an XSLT file, do a
transform and stream it to a browser. What am I Missing please?
MemoryStream strm = new MemoryStream();
XmlWriter writer = XmlWriter.Create(strm);
DataTable dataTbl = new myBLL().GetAll();
// Load the style sheet.
XslCompiledTransform xslt = new XslCompiledTransform();
// Execute the transform and output the results to a file.
xslt.Transform(?, f...Adding hyperlinks with parameters
I have a batch file which needs to be run from an excel sheet with a
parameter, like this:
But when i try to run the Hyperlink, the Excel shows an error message
saying it can't open the specified file (probably because the is a
space between the file and the parameter)
is there any known way to run the link from the excel?
On Mar 2, 12:45=A0pm, Pasha <pavel_v...@mailto.mod.gov.il> wrote:
> Hey everybody
> I have a batch file which needs to be run from an excel sheet with a
> parameter, like this:
> c:\1.bat myParameter
> But when i ...Adding Blank Rows after the last Detail of the Report
I've used this code from Dwayne:
Private Sub Report_Page()
Dim intNumLines As Integer
Dim intLineNumber As Integer
Dim intTopMargin As Integer
Dim ctl As Control
Dim intLineHeight As Integer
intNumLines = 12
intTopMargin = Me.Section(3).Height
intLineHeight = Me.Section(0).Height
For Each ctl In Me.Section(0).Controls
For intLineNumber = 0 To intNumLines - 1
Me.Line (ctl.Left, intTopMargin + _
(intLineNumber * intLineHeight)) - _
Step(ctl.Width, intLineHeight), , B
My report needs to print blank rows (at least...Using COUNTIF in multiple wooksheets
I am trying to use countif to count the word "complete" in a range on
mulitple wooksheets. I select my range and then hold shift to select other
worksheets to include but it comes up with #value. When I do it with one
worksheet it works fine. Help would be appreciated.
COUNTIF does not work with multiple sheets
First put a list with all sheets in a range on the summary sheet, assume you
have 10 sheets you can put ALL their sheet names in for instance H1:H10,
assume you want to count in the range A1:A10 in those sheets
=SUMPRODUCT(COUNTIF(INDIRECT("'...Custom toolbar menu in Outlook 2007
I have created a new custom menu toolbar using Jurgen Beck's procedure "Email
to Case". This works great through the web client.
I am trying to add a link directly in Outlook 2007 in order to have the
custom button available. Currently, we have to click on "View in CRM" which
opens a web client window of the email and from there I can access the
I want to make this toolbar button available directly in Outlook. Has
anyone done this and how can it be done??
Hotel Logistics specialist
...Spending Tracker on My Money Page
I have a strange problem after I have upgraded to MS Money 2006 Deluxe from
MS Money 2005 Standard.
On the "home page" or the My Money Page, I have the "Spending Tracker: This
Month" window displayed. I have included four categories by going to the
"Change the spending areas you watch closely" link in the window, but when I
go back to the My Money page five categories appear - the four I chose and
one additional one. Prior to the upgrade, I had four categories showing by
design - I deleted one and added one more. The one I deleted still shows -
in addit...outlook vcard, ad integration user properties
my boss is trying to get hix fax# in his vcard.
he is using his address from the global address list
I have modified his profile in active directory users and computers: I go
into AD users and computers, double click on his user, go to the telephones
tab, and enter his fax #. but when I did this his fax # is still not being
pulled up in his outlook vcard. Does anyone know where outlook is trying to
get this field from / how i can get this field into his vcard?
...Change 'Active' Window?
I would like to change the 'active' window (from the Access DB to another
application). I have Dynamics GP open and am currently using an Access DB.
I would like to change the active window to GP and run a macro (if possible).
Would I do this with a shell command?
Any help that you can provide is welcome. Thanks.
...Reset existing customer vendor relationship
We have a customer vendor relationship set up incorrectly. GP doesn't allow
me to edit the relationship or create a new one. How can I fix this?
Any help is much appreciated.
You can delete the existing relationship, then create a new one. To delete:
- Click on the line with the relationship you want to delete so it is
- Go to Edit > Delete Row.
- Confirm the deletion.
Dynamics GP MVP
Want to use Crystal Reports with GP?
"GG" &...ADDING A NUMBER
how do i add a number to a range of cells? I need to add 11.27 to a number
of different cells each with a different number in them
Put 11.27 in an empty cell, format it the same way as the numbers you want
to add to,
copy it, then select the numbers you want to add to and do edit>paste
special and select add.
"Helpme" <Helpme@discussions.microsoft.com> wrote in message
> how do i add a number to a range of cells? I need to add 11.27 to a
> of different cells e...Can I use a 'lookup' to a Pivot Table?
I am attempting to compare one column of data (a list Employee numbers)
to another (on a different sheet in the same workbook, also of Ee #s
but not as complete) and put the number in the corresponding cell back
to the original spreadsheet. Since the lists aren't exact, I can't
simply do an (='other sheet'!A1)and drag it down. The lists are both
formated as numbers and in numerical order but not the same length.
The oddity is that the sheet I'm referencing to is a Pivot Table. I'm
getting a #N/A message.
Thanks in advance
You could use the GETPIVOTDATA function:
...Problems picking accounts to use for Asset Allocation
I recently purchased Money Plus. I am trying to pick and choose which
accounts to use for Asset Allocation. However, when I select the accounts in
"Customize Asset Allocation" page and hit <Done>, Money Plus wipes out all my
choices and continues to use ALL accounts for calculating asset allocations.
...Update to Windows Mail
I'm using outdated OE6 on one of my PCs. How can I update to Windows Mail?
I should say this PC has XP.
"Lisa" <NoOne@NoSpam.com> wrote in message
> I'm using outdated OE6 on one of my PCs. How can I update to Windows
I downloaded Live Messenger but that requires my hotmail address. I want
to use the roadrunner address I used in Outlook???
"Lisa" <NoOne@NoSpam.com> wrote in message
>I should say this PC has...Custom titlebar during hanging
I implemented in my application a custom titlebar by overriding WM_NCPAINT
WM_NCCALCSIZE (i have a smaller titlebar).
Everything works ok, with one exception: if the application hangs, the
default window titlebar appears.
During the hang i can spy (using the Spy tool) the messages of the window,
so i see that messages are still coming.
During the hang I tried to move the window around, maximize, minimize so the
title bar is invalidated but it seems that it doesnt go anymore through my
Any idea ?
"andrewn" <andrewn@wrk> wrote in message
news...Vertical page breaks
I have a spreadsheet that is 40 columns wide, and except for the 1st column
(which will be repeated at the left), I want a page break after each column.
Is there a quick way to do this (as opposed to going into Page Break Preview
and pulling over the right page break 40 times)?
Try going into Print Preview and increasing the left and right margins by
You should be able to narrow it down to one column per page.
Gord Dibben MS Excel MVP
On Fri, 8 Jan 2010 14:29:01 -0800, Staceyglow
>I have a spread...How to hibernate Windows XP at the end of macro?
Does anyone have any suggestions on how to hibernate Windows XP at the end of
Thanks in advance for any suggestions
You might find something here:
"Eric" <Eric@discussions.microsoft.com> wrote in message
> Does anyone have any suggestions on how to hibernate Windows XP at the end
> Thanks in advance for any suggestions
Do you know any sample code on macro to perform hibernation without...Using Concatenate function to generate text in Text Box
I would like to have a text box on my chart, whose text is generated by
concatenating the values from two different cells (B4 and B6) on a specific
worksheet in my Excel file. I was able to use a reference to cell B4 to
generate the text for my text box using the following formula:
However, when I try to enter either of the following formulas for the text
='SSTyp-AllD'!$H$4 & 'SSTyp-AllD'!$H$6
I get the error message "The text you entered is not a valid refe...adding new records
I am totally new to CRM, so I hope this is really easy question:
This concerns permissions.. I have a "sales" group, and with one of those
people i need to be able to let them add new records on behalf of other
"sales" people. Is there like a standard permission setting for it?
(obviously every "sales" person can add new records if they select them selfs
as the owner)
By default the person who creates the record will be the owner. After record
creation the person could reassign the record (manually) to another user.
If all rec...When adding attachments...
....in Outlook the following errors comes up:
"Out of memory or system resources, please close some
programs and try again"
Quotas are fine. I have deinstalled/reinstalled Office,
cleaned 'temp' areas, and many other tidbits. Any other
This might help as i had this problem with Outlook 98.
Is the file you are trying to copy to attach nested in sub folders? if so try and copy the attachment to a root drive like c:\
Ignore previous email. wrong spellin
if the attachment is nested in sub folders(this means you have to open different folders to get to ...windows 7, and explorer 7
I made the mistake of upgrading from Vista to windows 7 and my machine
constantly locks up when I use explorer 8 which was working great on a xp and
my vista machines. It REFUSES to let explorer 7 work at all.
> I made the mistake of upgrading from Vista to windows 7 and my
> machine constantly locks up when I use explorer 8 which was working
> great on a xp and my vista machines. It REFUSES to let explorer 7
> work at all.
Windows 7 comes with Internet Explorer 8.
Internet Explorer 7 is *gone* in Windows 7.
Anything that would make it work would be a *ha...Customized POS buttons
I know the RMS package is not the best for food products, but I have this
small requirement of a coffe shop to use the package along with other
departments. I want to create custom touch screen buttons on the POS screen
as show below, which will select the coffee products on a two key strokes.
SMALL COFFEE SMOOTHIE
MED TEA ICE COFF
LARGE HOT CHOC GOUR ICE COFF
For ex, if a customer buys a medium smoothie, then the operator should be
able to hit MED button, and then SMOOTHIE button to select medium smoothie.