Sharing a Workbook #2
I'm hoping someone can help me with this. I designed a finance matri
for the company I work for so that the phone reps are able to decid
whether or not an applicant qualifies for a credit card.
The spreadsheet has a bunch of macros, drop down lists, and such. I
is important that I track every 'set' of information that is keyed in.
Right now, I have a button called "Submit" and it takes the info tha
was keyed in, and stores it in another 'hidden' sheet in the workbook.
I have 20 copies of the workbook, one for each employee. The proble
arises when I need to make...Using HTML template in 2007/Vista
Not sure if this is the right sub-forum or not....
I'm able to install an HTML page as a template using Office 2007 on an XP
machine, but the same process does not work on Vista machines. The template
is saved to the proper location but the problem is that when Outlook opens
the form, it opens as Plain Text rather than HTML.
I haven't been successful finding any solutions googling the problem -
anyone here know of a fix?
...Trendline values #2
I used the function "LOGEST" to get an exponential fit of a series of
numbers, which gives me a value of 1.0610. I also used "RSQ" function to get
the R-square, which is 0.9442. Then I made a chart based on the same series
of numbers and add trendline to the curve. I selected "Exponential" under
"Type" and checked "Display equation on chart" and "Display R-Squared value
on chart". The value shown on the chart is "y=3928.8e^0.0592x" and
"R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^...Outlook 2003 email #2
i am new to the outlook software; currently beginning to use outlook 2003.
i am receiving duplicate emails in my in-box; including all the emails i
imported from my web based email, yahoo.
how do i fix this problem?
many thanks for any and every ones helpful guidance.
happy new year,
"the world will not solve it''s current problems with like-minded thinking."
Not a techie here but I have had the same problem. I think that your
Outlook profile is corrupt. You can create a new one and import the
messages again from your backup.
To create a ...Copy protecting app
Is there a way to protect an access app from copying or restricting its use?
If it is a software solution then its better as the app can then be emailed
to a prospective client instead of having to physically send hardware keys
"John" <John@nospam.infovis.co.uk> wrote in message
> Is there a way to protect an access app from copying or restricting its
> If it is a software solution then its better as the app can then be
> to a prospective client instead of havin...How to use wincrypt.h?
I use it in a console app.
I do this:
The first I don't include .h file.
Then add #define _WIN32_WINNT 0x0400 and #include <wincrypt.h> in the
error C2146: syntax error : missing ';' before identifier 'HRESULT'
fatal error C1004: unexpected end of file found
How to do?
>error C2146: syntax error : missing ';' before identifier 'HRESULT'
>fatal error C1004: unexpected end of file found
>How to do?
Try adding #include <windows.h> before.
"David Lowndes" ...MS Money 2003 #2
I am trying to load MS Money on my PC running Win 2000.
All I get is a menu bar that is minimized in the bottom of
my screen. Nothing else. I have close virus check and
zonealarm, but I can't get the software to install.
...2 year Lifespan?---
I understand that MSMoney has some sort of built in lifespan of 2 years.
What stops working after this date?
Do I just buy the next version or is there a way round this?
It is mainly the stuff related to online working which stops working, ie
quote downloads and bank imports.
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny or
http://money.mvps.org/faq for UK tips and fixes for MS Money. To send
Microsoft your product wishes see http://money.mvps.org/wishes.aspx
I do not respond to any unsolicited email r...Exchange/Outlook 2003
In an effort to make sure we never reach the 16GB threshold for the SBS
2003 Exchange Info Store, I'm looking to setup a GPO to give everyone
consistent AutoArchive settings as well as a common location for the
I have already downloaded the Office Administrative Templates for
Outlook 2003, so I already have found the settings I want to modify and
have made the changes, I just haven't made them live on the domain yet.
My thoughts to date:
* create two GPOs, one for the PST location, one for the autoarchive
* set PST location to local drive, or common netw...insert password using vb
I have multi worksheets in a template with formulas. I can hide th
formulas but if I add a password, my macros stop and ask for th
password when the macro is in a protected worksheet. Is there a way o
adding the password to a macro so that the macro will run smoothl
without stopping and asking for a manual insertion of the password?
abbeville's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=976
View this thread: http://www.excelforum.com/showthread.php?threadid=26122
...XML TreeNode.Parent property when using 2.0 TreeView?
How do I get a TreeNode.Parent property when using the 2.0 TreeView control?
When the data source is an XML file there may be redundant names in the
tree. For example, when a child node with the value of 'name' is selected I
don't have a clue how to get the name of its parent which may be 'person' or
<%= Clinton Gallagher
"clintonG" <csgallagher@REMOVETHISTEXTmetromilwaukee.com> wrote in message
> How do I get a TreeNode.Parent property when using the 2.0 TreeView
&...CRM 1.2 unable to add users in OU but domain root OK.
I am having trouble adding users to CRM 1.2.
If I try to add a CRM user from an OU in the domain with deployment manager
or the web GUI it fails. If I add a user to CRM from the root of the domain
the user is added fine to CRM. In our test environment I was able to add
users to CRM that are in OU's in a test domain without any trouble.
...Computer Password Displays as Company Name on Startup Screen of Office Programs
Operating System: Mac OS X 10.5 (Leopard)
When I start up an office program (doesn't matter which one), the password that is set up for the computer account displays as the company name under the "This Product Licensed to:" line. I went into the Preferences of Word to delete the company name (which was the password) but it still displays. I also reinstalled Office to see if it would give me a chance to input the data, but it didn't...and the password still displays on start up. Does anyone know how I can change this so the log-on password is no...Dialog member function protection
When you subclass CDialog into CMyDialog and know that you won't subclass
Where do you put subsequent utility or misc member functions? In private,
protected or public?
Is it a matter of style or there is a reason for taking a specific choice?
(Knowing that your dialog is not intended to be overwritten).
They should only be public if you want to allow other parts of your
application to access them. A good OOP design should leave as little public
members as possible.
In general, it's a good idea to leave most hidden members protected. There
is ...COUNTIF query #2
Hopefully a nice easy one....
We have a logging system, and the spreadsheet basically has the person
name doing a call, what the call is and how long it took. This is use
all day so loads of calls get logged by various people.
Say column A is Persons name and Column B is time spent. I need
calulation that checks how much time 'person 1', 'person 2', 'person 3
etc has spent on calls during the day and add's it all up.
Please can someone show me how to do this, i have tried a COUNTIF bu
cant quite get it to work.
Many thanks in advance.
Darren (digital_life...What Excel macro puts data in the NEXT row of a sheet?
I have a list of data in col B of sheet 2 which I need to copy and transpose
into sheet 1, then delete the data in sheet 2 to use the form again to copy
and transpose onto the next line in sheet 1. I have tried with a macro
shortcut I've called ctrl + e. (I am really using the data form process but
cannot because I have too many inputs).
Is there a simple macro I can copy and paste?
...Not retaining password
Here's an interesting problem for you computer nurds.
I'm working on a computer that has two windows profiles, one is the
orginal and the other is a new one just recently setup for work.
Outlook 2003 isn't beening used on the orginal login profile and on the
new profile it isn't retaining the password. Both have computer admin
rights and OS is WinXP SP3. I've tick "remember my password" in the
email accounts settings and it remains ticked but everytime it does a
"send and receive" it askes you for the password. I've spent today
trying to fix this is...same subform used in two different forms
Is it possible to use the same subform in two different main forms
simultaneously? If it's possible, is it good practice? I can foresee
that there may be problems with code, but the subform I'm thinking of is
FamID (primary key)
IndID (primary key)
....other personal data
Two main forms for different types of data entry
frmFamily with family information on the main form and address
information...Not even Office Live Using Document Connection
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
While others are saying they can use the SP2 version of Document Connection
to Office Live but not Sharepoint I can�t even get connected to my Office
Live Workspace which I have been using via the browser for a long time. I
can't add my Office LIve Workspace location to Document Connection. The gear
just spins and what�s almost as bad it...Link Error #2
I was able to use CL.exe to compile and link .cpp
or .c file in a command line.
But all in a sudden, I can not do this any more,
as I always got such an error message:
LINK : fatal error LNK1104: cannot open file 'C:\Documents'
I didn't do complicated compiling. e.g. I even tested
with the "hello word" thing.
where hello.c is just this:
But again, this
LINK : fatal error LNK1104: cannot open file 'C:\Documents'
It seems something wrong with the path that CL....Restoring and backup of Business Portal 2.5 feature pack
how can i backup and restore my business portal site(2.5 feature pack). The
objective is to move it to a different location. I have tried using
stsadm.exe tool but it is not successfull. Any help would be greatly
...2003 Macro not working in 2007
Can someone please help. I have macro for IE automation in 2003 but I do not
know VBA. Here is the code that works in 2003 but will not run in 2007. Does
anyone know what the new code would be for Excel 2007.
This is the VBA code
Dim objIE As Object
Set objIE = CreateObject("InternetExplorer.Application")
Do While .Busy: DoEvents: Loop
Do While .ReadyState <> 4: DoEvents: Loop
.Visible = True
This is where Excel 2007 gets stuck.
Do While .ReadyState <> 4: DoEvents: Loop
Then it ge...determining macro status in a cell
Is there a way to determine the status of macros (enabled or disabled
within a cell formula?
Message posted from http://www.ExcelForum.com
I don't believe this is possible.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"newengland >" <<firstname.lastname@example.org> wrote
in message news:email@example.com...
> Is there a way to determine the status of macros (enabled or
> within a cell formula?
> --...Export data to a closed workbook
Can someone help me with code that record data in a closed workbook?
...How to see if different workbooks are linked?
How can someone determine if two workbooks are linked? I can see it is I find
the cell, but is there a way to see it at a glance?
You can use Edit>Links in the menubar(not in all excel versions)
If it is gray there are no links
Regards Ron de Bruin
"Tracy@Saunatec" <Tracy@Saunatec@discussions.microsoft.com> wrote in message
> How can someone determine if two workbooks are linked? I can see it is I find
> the cell, but is there a way to see it at a glan...