creating excel docs on web server
i need to create complex excel docs for download by users.
on MS site however it is recommended against excel/office
on server environments.
fine, but then what is the way out?
...Remove Drive w/ selection based on associated DOS drive letter
I am trying to find a way to call CM_Query_And_Remove_SubTree() or
SetupDiRemoveDevice() on the basis of the associated DOS drive letter. There
seem to be multiple name-spaces for both physical and logical drives. I have
found a number of well-hidden bridges for tying some of them together, but
have been unable to find one that lets me start with the drive letter and
chain down to the ID I need to drive one of the remove functions.
> I am trying to find a way to call CM_Query_And_Remove_SubTree() or
> SetupDiRemoveDevice() on the basis ...Creating A Custom Occurance for Tasks
Operating System: Mac OS X 10.5 (Leopard)
Email Client: pop
I'm trying to create a task and have it occur every other week (which is easily done in the calendar). However, when I go to the "Occurs" drop down that is not an option so I choose "Custom". Once I do this my entire Entourage freezes and I can't do anything within Entourage. My Force Quit doesn't show Entourage as "Not Responding" but the Entourage toolbars grey out and I can't do anything in which case I have to Force Quite Ent...How to create a report that prints at certain frequencies
I have a database that generates work orders of tasks that are performed at
certain frequencies. For example, check oil in truck - frequency every 4
weeks. How do I create a report (in form of a work order) that will print
automatically when that date comes up?
First create a WorkOrderPrintLog table with a text column Task and a
date/time column DatePrinted to log when the reports are printed. Then write
a VBA function in a standard module as follows:
Public Function PrintWorkOrder(strTask, intWeeks, strReport)
Dim cmd As ADODB.Command
Dim strSQL As String
Dim strCriteria ...XML 2005 Late-Breaking and Product Presentation Deadline
XML 2005 Late-Breaking and Product Presentation Deadline - Tutorials
XML 2005, November 14-18, Atlanta Hilton Hotel, Atlanta, GA
The deadline for late-breaking, product presentations, and town hall
submissions is Friday, September 16.
The late-breaking presentations are intended to be filled with late-
breaking news; however good presentations on other topics that don't
duplicate material already on the program will also be considered for
these slots. Submissions on fresh topics such as Ajax, alternatives ...How do I lock a formatted ecell sheet that I created?
How do I lock a formatted sheet with formulas and sums that will be imputed
in the future, etc. so the formulas are not erased and so the sheet could be
used again and again?
Do that involves also saving into a template that could be reused If so,
how do I do that?
Thanks in advance.
Select the cells that should be locked and then use:
format|cells|protection tab|check lock
Select the cells that should be unlocked and uncheck that setting.
Depending on the number of cells of each type, it may be easier to lock (or
unlock) all the cells and just unlock (or lock) the others.
Then you...How to create e-mail addresses based on group membership in E2K3 running on W2K3
I need to create different email address for different users in my
Exchange 2003 server running on Windows Server 2003. I would like to be able
to do this by using AD group membership and Exchange recipient policies
I have browsed MS support.microsoft.com web site and found KB 317298 (
http://support.microsoft.com/kb/317298 )and also looked at
www.msexchange.org . Both articles seem very straight forward. When I get to
modifying the rule in "Recipient Policies" this is where I get lost. I have
used adsiedit.msc to lookup my group which is called "Dogfood E...why do my documents print in faded colors?
Excel 11.56 - Windows XP - When I receive Excel documents via e-mail they
print out in faded/muted colors. My printer is not in need of new
cartiridges. My documents print just fine - but when I receive documents
from other people the colors are very light! Thanks for any assistance.
Perhaps you are printing in draft mode.
File, Page Setup, Page (tab), Options
the choices depend on your printer, and I don't really think they are stored
with the sheet. I have a Canon printer, and I see "Standard" for print quality.
David McRitch...How to initialize a multidoc application without a document?
The program is developed under Visual C++ 6.0. The program is the
multiple-document application. I would like the program to start
without opening a document. How to realize?
Use CCommandLineInfo::FileNothing in your app's initinstance. Something
// This all goes in CMyApp::InitInstance
if (cmdInfo.m_nShellCommand == CCommandLineInfo::FileNew)
cmdInfo.m_nShellCommand = CCommandLineInfo::FileNothing;
...Documentation for Literal Constants
I'm looking for C/C++ syntax documentation on literal constants.
In particular, I was trying to find out what the rules are for applying
signs (+/-) to values with non-decimal notation such as octal and
But I don't seem to find any documentation that covers this. Can anyone
offer any tips?
Available for consulting: http://www.softcircuits.com/jwood/resume.htm
Are you looking for this ?
http://msdn.microsof...create MULTIPLE IM accounts for corporation?
My corporation wishes to use Windows Live Messenger in-house. The
software comes pre-installed on all the CPUs we buy. However, as IT
Manager I need to create about 40 IM *accounts*.
I sucessfully created 5 using our company's email addresses but then I
got the error that I had exceed the number of allowed accounts created.
I think it's somehow noting our firewall's IP address. Any computer I
use within the building refuses to make new accounts.
The support site said the problem would resolve itself after 72 hours
but it has not.
I have posted to many Microsoft f...Broken formatting while pasting document
I have a tricky question.
How to restore formatting while coping data from one file to another?
I have some rows with grey background in Excel file A.
When I copy this rows with Paste Special function (selecting
Formatting) I see this rows collored in black in the new file B.
How can I get rid of this feature?
And this issue happens not on each computer. On my it works correctly,
on my co-worker PC it works with mistake.
What can be the root cause?
Manatee's Profile: http://www.excelforum.co...Long time user,can't create a chart-help!
Using office since 1995 and creating superb charts. Just installed office 07
in a new computer and I am stuck. In the past for all additions I would
enter ,for example =A1:A500,B1:B500, Choose my chart style and a chart would
be generated after filling in the various dialogue boxes. I do the same now
and I just get error messages. Can I set-up Excel to behave in the manner
that I am accustomed to.
Thanks for your help
My 2007 machine is in the other room, so I can't test right now. Try
referencing the address with the parent worksheet's name:
...What is a file permission error when saving a document in Word 07
I am trying to save a word document I am working on and after I hit save I
get the message "file permission error". What is this? and how do I fix it?
Is the file on removable media (eg CD/DVD or a USB stick)? If so, that may be the cause of the problem. Alternatively, if you've
accessed the file from a read-only location on a network, you could get such an error if you try to save your changes back to the
[Microsoft MVP - Word]
"jcs0730" <firstname.lastname@example.org> wrote in mes...Create 2nd toolbar
I was wondering how do I create a 2nd toolbar right underneath the first
one? If I use the resource editor and created a single toolbar
IDR_MAINFRAME and I load it with:
if (!m_wndToolBar.CreateEx(this, TBSTYLE_FLAT,
WS_CHILD | WS_VISIBLE | CBRS_TOP
| CBRS_SIZE_FIXED | CBRS_TOOLTIPS) ||
TRACE0("Failed to create toolbar\n");
return -1; // fail to create
If I need a 2nd toolbar (IDR_SECONDTOOL), how do I load that if I use the
resource editor to create the toolbar?
Did you try?
...Activities Not Created For Incoming Mail
I have CRM 3.0 SBE installed along with the Exchange Router. The CRM mail
box is set up and the forwarding rules have been configured for the users. I
have the options set to track all email. However, no incoming emails are
being converted to activities, regardless of whether they contain a tracking
token. They are being forwarded to the CRM mailbox, but they are not making
it into CRM. Any ideas?
Did you check the event log for any errors occurring? Is the "Microsoft
CRM-Exchange E-Mail Router Service" up and running?
Merijn van Mourik
"bpro...document printing question
I have set up an invitation on a 5.5 x 8.5 format, but cannot have the
document print without the "centering graphics" (not sure what to call them)
that appear when I do a print preview
Are you planning to print two invitations per sheet or is your stock already 5.5
In page setup, landscape, type 5.5 width, 8.5 height. Publisher will say it will
print two copies per sheet.
If your stock is already 5.5 x 8.5 you must setup your printer for a custom
Mary Sauer MSFT MVP
...Autogenerating documentation from the c# source code comments
Hi, I am wanting to automatically generate my documentation from my C# code
comments. Specifically I am wanting to generate examples that look like this
where code examples are shown for VB.NET, C#. C++, F# and JScript
How do you do this and can you do this with VS2010 Pro. I have searched and
cannot find a website telling me how to do this. I would prefer to include a
C# example in my source code comments and have the code generation tool
generate from this the examples in VB.Net, C++, F# and JScript examples
automatical...Conditional formatiing based on another cell
How can I change the colour of a cell and a seperate query an entir
row based on the value in a call. For example cell A1 has a number 20
in it. Cell B1 is blank. If "yes" is entered in to cell B1, I want cel
A1 to change to be in bold and a grey box. Ihave tried conditiona
formatting but doesnt seem to work.
Number_8's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=659
View this thread: http://www.excelforum.com/showthread.php?threadid=37566
select A1, then...how to Merge to xml document ?
I've to merge a peace of xml in another xml document.
Here is an example:
The other xml peace :
The merge result should be:
<backcolor rgb=&qu...How to associate XML with XSD
I've decided it's time to get a little bit smarter about how I deal with XML in
my apps, so I have a couple of really basic questions (that probably demonstrate
my complete lack of understanding of the underlying concepts):
1. Assuming that I have an XML file and its associated XSD file, what do I put
into the XML file to tell Visual Studio to use the XSD file to wire up
intellisense? The examples I've seen using "xmlns" all seem to use an internet
URL to specify the schema file, but I don't have a web server...
2. Is there something else that I need ...How to have Invoice Format be based on Customer Class ID?
Our company has two separate divisions which each invoice separately. We
would like for each division to print its own invoice format. We will
segregate customers by Class ID.
Is there a way to have a given Customer Class ID default to a given Invoice
(Others have suggested VBA... can someone get us started on that code?)
Yes you could do this either using Dexterity or VBA. You would, of course,
only be able to do this if printing single document because if you print a
batch of invoices (by choosing a range of some sort) then it prints as one
big report and so it woul...create a single date column from seperate month, day and year colu
The data I received came with the month day and year seperated out into
seperate columns. I manage to concantenate the date to show i.e. 112002 or
10102002 representing 1/1/2002 and 10/10/2002. What can I do to create a
date field from this or should I use the seperate columns to create a date
Try Format([SomeFieldName],"Short Date")
State of Arkansas
> The data I received came with the month day and year seperated out into
> seperate columns. I manage to concantenate the date to sh...batch create mailboxes E2K7?
How do i batch create mailboxes for an entire organization in e2k7?,
do i need to set a recipient policy and process it?
Exchange Server 2007: Bulk creation of mailboxes using Exchange Management
Exchange Server 2007: Bulk mailbox-enabling users using Exchange Shell
MVP - Exchange
NEW blog location:
"Guillermo Lov...Weird files created in root folder when downloading mail
Recently I've been getting weird files in the root of drive c whenever
I open Outlook 2003 and start downloading mail. Today the files are
named s3us.x where x is 1 to 9 and a to v then starting over with 11.
The files cannot be accessed while outlook is open. After closing
outlook I still couldn't access my mail and took a guess and killed
ccApp.exe. After killing that program I was able to access the files.
I've opened a few files with text editors and the contents resembles my