MFC ActiveX control on IE: how to get internet connection setting
I am working on MFC ActiveX control(.ocx file) on Internet exporer, the
control needs to call Winnet library (use HINTERNET) for making HTTP query.
With option INTERNET_OPEN_TYPE_DIRECT, there is no issue at all; but when
there is proxy server used for IE connection setting, how to get proxy
server and username/password settting to create HINTERNET? Is there any way
to get HINTERNET using the IE IWebBrowser2 or other object automatically for
the activeX control?
Thank you very much for your help.
"CharlieHoo" <charlieho...Need to solve for the total value of a commercial lease
I hope my grid below looks OK once it is posted. I need a formula to
solve for cell G3. I need a single cell formula to solve for the
total value of a commercial lease given the initial annual rent, the
rent increase percentage and how often (in years) that the rent is
increased. Any ideas?
A B C D
E F G
2 Tenant SF $/SF Term (yrs) Increase
amount % Every
X years of Lease
3 Ross 30,000 7.00 10 5%
2 ...Spreadsheet issue
I have a spreadsheet, 10,503 KB that has 3699 rows and 3600 of them have
hyperlinks in them. It takes a lot of time to save this document. I do have
it saved as an .xlsm due to two macros used in the spreadsheet. Will things
improve if I save it as a .xlsx and will I lose the anything related to the
macro or just the ability to run the macro?
There shouldn't be a big difference in file size with .xlsm vs. .xlsx.
Unless, your macros are huge with lots of userforms. If you save as a .xlsx
you will lose access to your macros. Do you have lots of objects in the
workbook. ...I need scroll bars
How can I add vertical scroll bars to my CRM page?
There are two situations where I need this capability: 1) When I cusomize an
existing CRM form there is no way to scroll below the initial screen to add
additional controls and 2) when I create a link to an external web site
within CRM, the page displays without scroll bars.
Is there a configuration option I can set to change this behavior?
I can get the vertical scroll bars to show on an external page by adding the
following attribute to the <body> tag of the external page:
No change is requir...need clarification on KB815372
The first Bulletin item in this Exchange 2003 article states:
The server is running any edition of Microsoft Windows 2000 Server and the
SystemPages value in the registry is set outside the range of 24000 to 31000.
Note The SystemPages subkey is located in the registry in the following
We have a server that is Windows 2000 AS with Exchange 2003 EE. The regkey
for SystemPages is currently set to 0. Based on the aforementioned condition,
are we safe in assuming 0 is considered outside ...Sql server locking/blocking issue
I have a procedure to delete old records by id (clustered index) from
the a big table (delete about 150k records at a time comparing to 30 M
total in the table) and at the same time, some procedures will insert
or update data in this table by id as well. When I did the tests, I
found the first procedure is blocking all other insert/update
procedures. The locks of the first procedure has is the PAGE exclusive
lock. Those update/insert procedures will only work on the newer
ids. I don't know why this block can happen. Could anyone here help
me explain a little bit?
R...need to create a bar chart with a centre axis
Need to create a chart with a centre axis, with one comparison going to the
left, from zero to 22 and another set of data goin to the right with a
comparison set of figures - if this makes any sense
Sounds like a Tornado chart.
> Need to create a chart with a centre axis, with one comparison going to the
> left, from zero to 22 and another set of data goin to the right with a
> comparison set of figures - if this makes any sense
...Setting Calculation always goes back to Manual. How to permanently have Task Panel dismissed?
Since shortly, the setting in Options -> Calculation -> Calculation is
always set to Manual, even after I have set it to Automatic and saved
the document. After restart Excel is it set back to Manual. Irky.
some documents, the task panel is always active after I open the
document. Hoew to have it permanently closed? It happen in some
...Need Money ? Get it now...
Need Money ? Get it now...
...In Excel I need to insert a clean form each use
I have created a protected worksheet with unlocked cells to be filled in by
the user and saved. Then next week I need to to have another copy of the
same blank form for the user to fill in with new data. I thought I could
just insert a copy of the form (as its own file) on Sheet 1, but can't figure
out how to do that.
Hold down the CTRL key, left click the sheet tab and drag to create a copy.
It will have a name of something like Sheet1 (2) so rename as required.
> I have created a protected worksheet with unlocked cells to ...How to permanently remove a toolbar from compose window
I recently installed Adobe Acrobat and it added a tool bar to the new
message window in outlook (xp). No matter how many times I move this tool
bar to be next to the main tool bar, or simply right click and uncheck it
from displaying it comes back.
I wouldn't mind leaving the toolbar there if it would stay where I move it.
but if not I'd rather just get rid of it.
Can someone help me put this toolbar in its place and have it remember that
spot or help me get rid of it?
The toolbar is called Attach as Adobe PDF
Diane Poremsky ...I need tutorials to use outlook
Please address me where I may be able to find instrucction on how to use the
outlook as a begginer?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Yol wrote:
| Please address me where I may be able to find instrucction on how to
| use the outlook as a begginer?
"Yol" wrote in message
> Please...Authentication prompt while opening Excel/word files from IE8
While opening Excel or Word documents from intranet websites in IE8, we are
seeing authentication prompt and after providing credentials the file is
opening fine. Surprisingly if I cancel the authentication prompt, the file is
still opening fine!! Is this problem related to IE or Office? How to fix the
I tried following but nothing worked:
-Moved website from intranet zone and added to trusted sites
-Reset IE8 settings
-From Firefox the files are opening fine. FF is downloading file to local
disk and opening it.
-Changed default browser to Firefox and tried to open Exce...Is it possible to use CRecordSet without connecting to a database?
Under .NET you can use the ADO.net object without never connecting to a
database. Creating columns and inserting data manually.
Is it possible to do so with a CRecordSet?
If it is important to know, I need to do so because I have a working
C++ function that accepts a CRecordSet derived class as a parameter
(ugly, I know), I'd like to use the function and send it a RecordSet,
just like it used to get before, however, all that without connecting
to a database. - I'll fill it myself using another source. Is it
"Vitaly Belman" <firstname.lastname@example.org>...Need to reload Outlook 2003 PST File
I have a new computer with a 60 day evaluation copy of Outlook 2003 and I
have corrupted my PST file. I can't even open Outlook because I get an error
message saying Outlook can't open a set of folders. I have gone in and
created a new PST file but I still get the same error message. I think I
have to fix or delete the default PST file, but I'm not sure. I did try to
delete the original PST file but couldn't.
Create a new profile.
"tlernst" <email@example.com> wrote in message
news:F519B8E7-56A7...Project Web Access 2003 (SP3) and IE8
My organization will upgrade all the client desktop computer from XP (SP2) to
Windows7 (64-bit) with Office 2010 (32-bit) and IE8 by the end of this year.
Our group is currently using Project Server 2003 (SP3) with SQL Server 2005
(SP3). I would like to know if the current configuration of client - Project
Professional 2003 and PWA 2003 (SP3) - will be compatible with the new
Windows 7 environment. In the official Microsoft Windows 7 Compatibility
site, Project Professional 2003 is certified as "compatible", but no
information on PWA. I also concerned about PWA and IE8 ...Need Product ID to install office 2000 publisher.
Recently purchased new computer. The microsoft software did not contain
publisher. I want to install my publisher 2000 software and then update to
2003 however I lost the case with the 25 digit product ID code. The paper
certificate of Authenticity product code is only 20 digits and will not
install. Any help would be appreciated.
If I am not mistaken, the 20 digit # was for OEMs. If that copy of Publisher
came with the old computer, you cannot transfer it to the new. You must buy
a retail version to do that.
MVP Microsoft [Publisher]
"PALady&q...I need a data transfer cable for Windows 7 64-bit
I currently have an XP Home PC and I'm about to take ownership of a brand
new Windows 7 64-bit PC. Could anyone recommend a data transfer cable
suitable for connecting the two and transfering disk contents? Most of the
ones I've seen on sale seem to be for Vista or XP...will they work with
Windows 7 64-bit?
"Tim" <firstname.lastname@example.org> wrote in message
>I currently have an XP Home PC and I'm about to take ownership of a brand
> new Windows 7 64-bit PC. Could anyone recommend a data tran...More printing issues...deeper issue?
Operating System: Mac OS X 10.6 (Snow Leopard)
First off, thank you to Bob for continuing to help me with this issue. <br><br>Here's the latest issue: <br><br>I went through the process described earlier - opening the "corrupt" document in TextEdit and copying the text into a new document. It prints just fine. I've also created new "stationary" (i.e., a header with my contact info) which prints just fine. However, when I paste the old text in the new stationary...it won't print! I&...Exchange 2003, Google DNS, and IMF Connection Filtering RBL Failures
Just a quick heads up for those of you trying out Google's new DNS servers
(22.214.171.124 and 126.96.36.199).
I found that when I used Google's DNS Servers that my Exchange 2003 IMF
Connection Filtering RBL's (specifically zen.spamhaus.org) were not always
working properly and were allowing spam to pass through. Apparently there
is something in Google's DNS service that prevents a propery query to
zen.spamhaus.org. Switching to another DNS (Open DNS) corrected the problem
I only mention spamhaus because they have a quick and simple test
http://w...Vista 64-bit: problems with IE8
Just wondering if anyone can help with a problem I am having with
Internet Explorer and my system performance. I have IE 8, Windows Vista
Home Premium 64-bit, SLI-F Motherboard, AMD Athlon 64 X2 5400+ Processor
2.80GHz, and 4 Gigs of RAM...
When I am using IE, the system sometimes stops responding. Checking the
task manager reveals that there are 7 instances of internet explorer
running at the same time. Usually 2 of them are using significant
memory, over 200k, while the rest are running between 50k and 500.
This happens with 1 IE window open, using only 1 tab. Why are all these...SMTP could not connect to the DNS server
hello to all,
from yesterday my server exchange 2003 have the queue towards external
dominions of mail that are blocked We can receive mail but not send it.
The internal mail turns as usual.
The registry of the events says that:
SMTP could not connect to the DNS server '188.8.131.52'. The protocol used
was 'UDP'. It may be down or inaccessible.
151. 99. 0. 100 are currently set up serveur DNS in protocol smtp
what has happened?
thanks in advance payment to all
On Fri, 23 Sep 2005 10:03:49 +0200, "damiano" <email@example.com> wrote:
>hello to all,
>fr...Need to make sure workbook is open before proceeding
Can you help - Users of my form need to make sure Doc2 is open before running
the macro. If Doc2 is not open I need the macro to stop and a message box to
pop up stating Doc2 is not open.
Application.WindowState = xlMinimized
Dim Doc2Wkbk as workbook
set doc2wkbk = nothing
on error resume next
set doc2wkbk = workbooks("doc2.xls") 'no drive and no pat...Help me Please!! Need hyperlinks to show actual email address!
I copy a list of names from one page and put them in a excel spreadsheet.
What happens is just the name show like DUSTIN MCALISTER but when you hold
the mouse over the name the email address shows up in a little yellow box
showing what the hyperlink is. Is there a way to make it show the email
address instead of the hyperlink?? That way I can click on a row of names and
all the emaill addresses will be there so I can copy and paste them into my
Email and mass email my clients? Thanks!
You could add this little UDF
Function eMail(rng As Range)
Dim tmp As String
On...SMTP Issue #2
Hello. I am running Exchange 2003 (SBS). Does anyone
know why outgoing mail would be read as junk mail by
external email clients? When I send email to an msn
address (and others) the message gets filtered as junk.
I am not sure what filtering hotmail or anyone else is doing to detect your
mail messages as junk, it could possibly be due to your server being on a
blacklist... Or the content of the message itself. Unfortunatly these rules
are on MSN's side. You could try sending an email to their support staff to
try to get assistance with this.