Wang control under what name?
Can someone please tell me under what name one can find wang control
in Visual C++ IDE. I looked under "Project->.....->Registered ActiveX
elements", but could not find anything called *wang* or *kodak*.
I have been using Wang control in my MFC program and can use copy and
paste to put more controls on the same dialog. But i need to know the
ID of Wang control to insert it in a new program from the Project
thanks in advance.
...Worksheet for Wife's Work--Help needed
The wife works for a tax-exempt organization that is looking to recoup the
sales tax they pay on fuel.
In it's ultimate wisdom, the state has made this as difficult as possible,
requiring TEO's to first find
the price per gallon in a chart and them subtracting their calculated sales
tax per gallon based on
the rate for that particular county. The state's chart looks something like
Sales Tax Rate | Sales tax per gallon
I'm assuming they mean a price of $2.027-2.039 qualifies for a recovery of
$0.153 per ...name badge labels
Now we have Office 2007 and I cannot figure out how to create a sheet of name
Are you using mail merge? If you are, select the your label from the page setup.
If you are manually typing your badge labels, measure your labels and setup your
page with grid guides.
Mary Sauer MSFT MVP
"Carol in Texas" <CarolinTexas@discussions.microsoft.com> wrote in message
> Now we have Office 2007 and I cannot figure out how to...What happened to website templates from Pub 2007 to 2010?
I just installed MS Office with Publishers 2010 on my computer and
discovered that there is virtually no mention of website templates?
Did I miss something or is MS dropping this?
On Thu, 3 Mar 2011 19:56:08 -0800 (PST), geedc <email@example.com> wrote:
>I just installed MS Office with Publishers 2010 on my computer and
>discovered that there is virtually no mention of website templates?
>Did I miss something or is MS dropping this?
Using Publisher for websites has been long deprecated, and with the
release of Office 2010, support for using Publisher for web pages has
essentia...sheet names and representing a date
I have a workbook that each sheet tab needs to be named the after a
particular date in its worksheet. This is so that the contents can be
imported into a database as they are updated. The dates have to be
presented "yyyymmdd" with no dividers. Obviously it is a
representation of a date and not the real thing. I am always getting
errors because currently the sheets are being named manually with many
mistakes. The sheet name comes from an actual date in cell E5
I have some vba to do it, but it is clumsy, using year month and day
functions combined with conditional statements to al...Where can I get a template that will calculate profloss after buy.
I need a template that will calculate all the possible variables in a share
trade. The rate on buying, every day entry (7 days),Profit/loss on holding,
prof/loss on sale etc.
...Variable-named database in a proc
We have a SQL 2000 database currently named WAREHOUSE.
At some point in the future this will be given a
We are creating a stored procedure that sits on another
database called RECEIPT on the same server. Each proc
has a long and complex SELECT statement that queries
many tables on RECEIPT, but then joins to one table on
this Warehouse database.
I could hard-code the dot notation:
and then change this when the database gets its new
name, but that's bad programming. Management likes the
idea of p...can me and my wife view the same mail box content?
my wife and I share a computer and when we check email the messages stay in
that users in box. Is there a way to have it so all the mail can be viewed
without changing users?
Use the same Profile, and or, point OL to the same pst, and ensure it is set
as the default
"boyz_65" <firstname.lastname@example.org> wrote in message
> my wife and I share a computer and when we check email the messages stay
> that users in box. Is there a way to have it so all the mail can be viewed
> without changing users?
> -- ...Any way to get worksheet name from function?
Is there any way for me to access the name of the current Worksheet tab, to
put it into a cell? I need a cell whose name changes based on the name
entered on the Worksheet tab.
Copied from Bob Phillips' site........note: leave the "filename" as is. Do
not substitute your file name.
File path, file and worksheet name:
File path only:
File name only:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+...Renaming menuitem names in crm 3.0
I need to rename the menuitem names(for example:New,Save,Close) in
menubar(for example File,Actions,Help) of an entity form.How to achieve this
I am waiting for reply.
...Insert file name into header
I need a macro or something that automatically insert the file name of the
excel file into the header or footer, does not matter which, i dont need the
Either this or automatically insert into the header or footer the contents
of a specific cell in the worksheet. the cell address will never change., if
i create a new worksheet, same cell address needs to go into the header
Try here: http://www.mrexcel.com/tip055.shtml
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Patrick" <Patrick@di...Invalid Range Name
I have an application that reads data from spreadsheets based upon named
ranges. I have a customer that has ported the application over to French
Windows and French Excel XP. The application now gets an error reading one
of the named ranges, specifically L1SAVE. I now have an installation with
French Windows and French Excel XP and have been working in that environment
to try to figure out why the name will not work. When I go directly into
Excel and select the L1SAVE name range I get an error message indicating that
the name is invalid. I can try to create a new named range with t...Template getting locked by xls
I'm using a template on a network and occasionally, one remote use
seems to be locking the template. (template in use by xxx)
Users all click on a template shortcut to open workbook based o
template. Only one user has this happen. Any ideas?
jamaz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1663
View this thread: http://www.excelforum.com/showthread.php?threadid=31994
is this user doing something differently?. e.g. trying to open the
Fra...Change Exchange 2003 Server Name
I am researching if it is possible to change the name of our Exchange 2003
server. I've heard this is possible (perhaps incorrectly) with Service Pack
2, but I can find no documentation of this in the release notes.
Not changing out servers -- it will be the same server, and no other changes
will be be made, just that we want to change the name of it, say, for
example, from EXCHANGESERV to EXCH.
Is this possible (with service pack 2 or without)?
No, it is not possible to change the name of the server. At least not if
you want Exchange to still function afterwards. Sorry....Formatting
For sometime I've tried to use custom cell formatting based on using on
of the cell formats and then hacking the result via the custom format
However I have not been able to find a consise list of the format use
and the formating codes. For instance I often only want to repor
nunmbers in round '000's and have been able to get this mostly to wor
but really it's just trial and error.
If anyone has a list of the formatting templates etc it would b
Message posted from http://www.ExcelForum.com
This link should help
http://...Outlook Name lookup
When creating a new email and typing in a name for the To:
Outlook does not find the name all the time even if it is
in the address/contacts. Does anyone have a fix for this?
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline; modification-date="Sat, 8 Jan 2010 05:28:17
c2UgS...Question regarding user name not being able to resolved
Hi...I need help on this:
I am setting up a microsoft exchange server in my dept. I have a server for
the Active Directory and a separate server for the Microsoft Exchange. After
setting up, I created 2 users in the Active Directory and also I created the
mailbox in the Exchange server for the 2 users. Let call them user A and user
B. After that at the client side, I logon as userA. I use outlook to open my
mail account but I get the error "Network problems are preventing connection
to the Microsoft Exchange Server computer. Contact your system administrator
of this condition pers..."SBS & EBS Users" group name change on LinkedIn
For those of you that are members of the "SBS and EBS Users" group on
LinkedIn, we have changed our name to reflect the change in EBS status
as well as to appeal to a wider audience. We are now officially "Small
Business IT Pros."
And if you're not already a member, feel free to join us at
We currently have over 600 members and are growing daily.
Bradley J. Dinerman, MVP - Enterprise Security
I have a template in which I have created a new menu on
the standard menubar.
I have assigned the relevant macros and whilst in design
mode in the template macros work fine. However, when I
use File New and click the menu buttons, excel is looking
at the macros in the original template and therefore opens
that to run the macros. How do I define when creating a
custom menu that the macros in ThisWorkbook should be run.
Did you save the macro in Personal.xls or just another workbook?
If the macro is held in your personal workbook it should run withou
any ...Define Chart Name??? #2
thank you very much for your help... i managed to figure out th
problem... it was due to the fields not updated properly... there'
still old fields hence misleading me to think that your code to sho
all the items were not working... i have yet to try the code provide
by you to remove all the old fields but i'm pretty sure it woul
work... once again thank you very much for your help...
hce's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=351
View this thread: ht...Dynamic named ranges
I'm trying to import an Excel spreadsheet into an existing Access
table using Office 2003. Ultimately, the plan is to do it
programmatically using TransferSpreadsheet, but to check that the file
has no problems, I've done it manually with the Import Spreadsheet
The worksheet has 43 rows, and I import a named range defined as
"=Sheet1!$C:$E". The import works, but I get a table with 64K rows,
all but 43 being blank!
Is there a way to define the range so that only filled rows will be
imported? I don't want to use the last row's address explicitly,
because I wi...Change User Name Spellings
Is it possible to change username spellings in GP 9.0? If yes then how?
You can change a user name at any time. You must log into GP as 'sa' and
then go to Tools > Setup > System > User.
Dynamics GP MVP
Flexible Solutions, Inc.
"create_share" <email@example.com> wrote in message
> Is it possible to change username spellings in GP 9.0? If yes then how?
Are you talking about the publicly displayed user name or the ID the user
...Scope of name
I have been unable to change the scope of some names from global (workbook)
to local (worksheet) in the Loan Amortization template in Excel 2007. There
are 29 names in the workbook. I was able to change 25 of them but I could not
delete and then recreate the Int_Rate, Loan_Amount, Loan_Start, and
Loan_Years as worksheet scope names. Does anyone know why?
...Line 163 Excel Address Template
I am in the process of creating an Address list to be used for a mail merge
in the future. The template begins as I expect, with odd numbered rows being
shaded blue and even numbered rows with no color. At line 163, the
alternating row color stops. All rows are white (no fill). I've tried a
number of formatting fixes, but nothing works. I even tried to start the
sheet over. Again, alternating color stops at Line 163. How do I continue
the alternating color of rows for the rest of my sheet? My thanks.
P. S. Hope I've explained this properly.