save as html #5
I have been working for years on Excel 97 until a couple of days ago. I
manage a web site that I update two times a month with new point standings
for my group (www.wctpa.com) . The points are sent to me via e-mail by the
group secretary in an excel spreadsheet.
I have an html document that I rename and reuse that contains an html
instruction to insert a table at a specific location: <!--##table##--> . In
Excel 97, I had been able to re-save her spreadsheet as "save as html". This
allowed me to insert the spreadsheet contents into my html document, then
upload to our we...Exchange 2003
I have a newly setup production exchange server (sp2). It is only serving a
small subset of my organisation, about 15 users, using mydomain1.com. My
active directory contains around 100 user accounts that do not have exchange
mailboxes and they use our old pop3 based system and have a seperate email
domain name, mydomain2.com.
It would appear that whenever someone with an exchange mailbox
(mydomain1.com) sends mail to people with an email address listed elsewhere
in the active directory (mydomain2.com) it gets stuck in the local exchnage
delivery queue rather than forwarding i...create new users STRANGE problem
Hi, I'm developing a web application (using standard asp and not
asp.net) to let certain remote users administer exchange 2003.
I have installed win2003 standard edition, exchange 2003 enterprise
edition,owa and my web application on the same server.
My web app, let users to create mailboxes, delete mailboxes, change
All works fine, but for example, if I reboot the server, a web
application user can create 50 mailboxes.
But when any of these users log on to owa, something goes wrong and
the admin user cannot mailbox enable other user accounts through the
web app, even if he ...ProbleM: when I restore a mailbox using Exmerge with a pst file, nothing is transferred.
I am practising Exmerge for a big remote site migration in a couple of
weeks. One thing I dont understand is that I can backup one test
mailbox fine using Exmerge (I know this works, as I have opened the
mailbox pst file within outlook and everything is there), but when I
perform the restore using the pst file, nothing happens. There is no
error messages, and Emerge goes through the motions (though it finishes
supsiciously quick), but when I open the mailbox, no emails have been
restored. Although it is great that Exmerge is working for the backup
part of the stage, I am disappointed it i...User defined functions aware of what cell they are placed in?
I would like to make a user defined function which needs to know in
what cell and what worksheet it is placed in. I will be using this UDF
in multiple cells on multiple worksheets. I originally just passed the
cell row and column as parameters to the UDF however this ended up
updating all worksheets and not just the one the UDF was on.
Is there any way to do this?
function myfunct(something as somethingelse) as something
msgbox application.caller.address & vblf _
& application.caller.parent.name & vblf _
& application.caller.pare...Using Word 2003 in Vista: Opening dictionary shuts down Word
This is a problem in Vista; it did not occur when I used Word 2003 in XP.
Whenever I try to open the dictionary in Word 2003, either by clicking its
icon, or hitting Alt+click over a word, Word shuts down.
Vista Business, Service Pack 2
Thinkpad T400, Intel Core 2 Duo CPU, 3GB RAM
...Event ID c0072030 #2
We have an Active Directory Organizational that contain
all of our contacts. I have run the delegation of control
wizard and given a user full control over the contacts OU.
When I log on with that users account and try to update to
add an SMTP address to a contact I receive the following
There is no such object on the server
...Switching companies using SQL Passthrough
I have an application that uses SQL_Passthrough. As part of the code you
must execute a statement that uses the appropriate database. The code looks
set SQL_Statements to "use MYDB";
status = SQL_Execute(SQL_connection, field SQL_Statements);
This works fine, but my application can be used for any number of databases.
At first, I modified it to use the Dex.ini file, which works. Here is the
dbname = Defaults_Read("SQLDB");
dbopencommand = "use " + dbname;
set SQL_Statements to dbopencommand;
status = SQL_Execute(SQL_connection,...Old emails not displayed (Multiple PC's using same inbox)
I have 2 machines running XP and Outlook 2000. Both
mahcines are setup to using the same Exchange Server
When i open outlook in one machine all mail are visable
is the inbox, and new mail is received correctly. But if
i opne Outlook on the second machine my inbox is empty.
Any new mails will appear quickly then disappear. I
cannot get the second machine to display old emails.
If I leave the first machine off, all new mail will stay
in the second machines inbox, but if I open outlook on
the second machine all mail disappears and is shown in
the first machines inbox.
A...Has Hierarchy the Parameter between years?
Access 2003. I have a query with the following parameters.
Like [Forms]![Search].[txtAAID] & "*" ‘Data are in TAA
Like [Forms]![Search].[txtBBName] & "*" ‘Data are in TBB
Like [Forms]![Search].[txtCityName] & "*" ‘ Data are in TCity
Between [Forms]![Search].[txtFirstYear] And [Forms]![Search].[txtSecdnYear]
‘Data are in TYears
Like [Forms]![Searc].[txtSpWrds] & "*" ‘Data are in TWrds
All fields in tables are string and the db is relational.
I have 5 txtboxes to enter data. To enter data in Yyear parameter I have two ...Using namespaces? I've some messy nested contexts that I want to clean up...
I've got the following code structure
So for function definitions in B I have to write
and for objects of B in A
It's all just a bit messy. Isn't it. Someone please help.
...User Display name
I have a minor issue I cannot figure out.
One of my CRM users display's as FirstName, LastName the rest as
How do I get them all to display correctly?
in the organization settings of CRM you can set the full name format.
unfortunately when you change this is does not update existing
records...only newly created ones.
"MattB" <MattB@discussions.microsoft.com> wrote in message
>I have a minor issue I cannot figure out.
> One of my CRM users display's as FirstName, LastName ...Help!! Way to find users sending email to large amount of receipients.
Could some one tell me if there is a way in Exchange 2003
to find out what users are sending email to a large
amount of recipients?
I'm having some serious performance issues and I'm sure
it's some one sending email to a large amount of
My wife and I have road runner cable. We each have our
own email account. We want to use Outlook 2003 to read
our respected emails. I've tried to configure it so that
we each have our own password for outlook for privacy of
email. As it stands now, when I click on the Outlook
shortcut on the desktop it asks for my password. I give
it and it opens up my email folder. I tried to create a
folder for my wife's email. I put a password on her
folder. Now when I open outlook from the shortcut on the
desktop, it want's my password. The program opens and
then to get to her f...Formula to process 3 cells using IF statements
I have 3 columns of experimental data (C:E).
Row 30 contains the sums (C30:E30).
I need a formula that will examine the three sums and return the
column number that has the lowest sum. If more than one column is
lowest, select one randomly.
C30 D30 E30 Result
10 11 12 1 (C)
22 20 21 2 (D)
32 31 30 3 (E)
40 41 40 Randomly select 1 or 3
51 50 50 Randomly select 2 or 3
60 60 60 Randonly select 1, 2, or 3
Can this be done with IF statements or do I need to write a macro?
Well, this is a bit cumbersome, but it se...Pointing to correct macro path using excel custom toolbar
I have created an excel 2000 template (.xlt) containing a number o
macros. When I open copies of this template on various pcs, the macro
function correctly, except I cannot successfully run the macros usin
the custom toolbar I created, because (I think) within the toolbar th
paths to the macros are pointed to the original location on my pc. An
advice on how I can resolve this would be gratefully received
Message posted from http://www.ExcelForum.com
Have you thought about building the toolbar when the file opens?
Or maybe separating the worksheet portion of the template from the code pa...Entire Visio page moves whenever I use the directional arrow keys instead of the object I've clicked on
Running Visio 2003. For some reason lately, whenever I click on an object
and try to move it using the right, left, or up or down arrow keys, the
whole page moves instead of the object I've clicked on. This is really
annoying! It didn't used to be this way. I'm not sure what I changed. I
simply want the object I've highlighted to move whenever I use the arrow
keys not the whole Visio page itself!
On Fri, 24 Oct 2008 17:29:14 -0400, "Spin" <Spin@invalid.com> wrote:
>Running Visio 2003. For some reason lately, whe...how do i enter data for a # of years using a formula?
i am working on excel and the book asks that i enter data s=using formulas
for specifically the last three years of what i am referencing to. and i have
to know how to us the copy command button. can anyone help
...two sets of parameters..one query...but how?
I have a query to track when I must renew State Police Clearances AND Child Abuse Clearances. I want to use the "Between [date] and [date]" function on BOTH of the fields in order to bring up BOTH sets of dates for BOTH clearances.The problem I am running into is that when the query results come up, if one date doesn't meet the criteria NONE of the information comes up (even if the other date DOES).Any suggestions!??!?! Thanks in Advance.....NET 3.5
Does anyone of you know how I can force vb.net to remove the handle of a
local DLL which I used beforehand with Reflection.
Here is a fragment of the code.
I have a base class and a derived class. This app only knows the base class
and creates an Instance of the derived class by using Reflection which works
fine. The only problem I have is that the local DLL file is blocked (I can't
delete it) as long as I don't close the Application
Dim GetCustomModule as BaseClass
Dim dll As Assembly =
Assembly.LoadFrom("c:\tools\DerivedCass.dl...different budget ID for single account
when calculating the budget for an expense account lets say 111-222-333, is
there any way to tell which budget id to use or if both buget id are using
for calculating the budget amount.
the expense account exists in both budget id.
...Ex 2003 IS backup, using NTBackup 5.0
On Win2K SP4, I've upgraded from Ex 2000 ==> Ex 2003. I use NTBackup
to back up the IS. The NTBackup is version 5.0. Backup proceeds
normally; on differentials I can see NTBackup counting log files, etc.
However, I tested a restore, and when I catalogued the *.bkf file,
NTBackup says "No files were found". So I have an error-free backup,
from which (apparently) I cannot restore.
Is the Ex 2000 ==> Ex 2003 upgrade supposed to upgrade NTBackup as
well, to a version that can handle restoring Ex 2003 IS? Does anyone
have an insight into why NTBackup doesn't want to ...Option trades not using "cash" account
I am using the trial version of Money 2006 Premium and am seeing a problem
which also occured in Money 2003. When opening or closing an option position
in an investment account, the "Transfer to:" field is left blank by default
even though a "cash portion" is defined for that account. This is a minor
annoyance in that, for each of these transactions, I need to select the
appropriate cash account. In some cases, if the "Transfer to:" field is left
blank, Money will ask for the cash account name but this does not always
happen and the security is bought or...Off-Topic: Newsgroup Readers/Viewers
I know this is off-topic, but I couldn't find a newsgroup that was
appropriate for this post (like a lounge for MVP's or something)...so I
apologize in advance.
I currently use Outlook Express (or Outlook Newsreader : "C:\Program
Files\Outlook Express\msimn.exe" /outnews) for viewing newsgroups. While
its a nice program, it does have a few shortcomings, not the least of which
is its difficulty in truly tracking and reporting responses to posts made by
the user. I figured since a lot of MVP's and others on these newsgroups
tend to respond to a lot of newsgroup posts, an...can a program send email on users behalf with out getting the nag boxes?
I am trying to allow a program to send an e-mail through
outlook 2003 on my behalf without getting the nag
We have a customized program that sends out emails for us
but since we moved to outlook this nag box pops up for
each one. We have to sit there for hours clicking yes to
each one and allowing access for 10 min maximum.
I have installed the outlook security features
administrative package on my machine and followed the
read me to configure it to allow this but have not been
This is what I have tried:
1. The admpack.exe installed easily then I installed