Save a single worksheet in Excel as a single file.
I have multipe worksheets in a single workbook. I would like to be able to
save each worksheet individually. I want to send each worksheet to an
individual, I do not want to send the entire workbook. All information must
be retained in the one workbook, but as the individual worksheets are
updated, the individual worksheet needs to be saved and sent to that
individual. Help anyone? Thanks.
you can probably find the answer here.
"Dakota" <Dakota@discussions.microsoft.com&...Any USB-3 motherboards or devices out yet?
Just wondering if people have noticed anything on the horizon. I did
There's also Light Peak (10 gb/sec) from Intel that will blow that out of
the water but it could be years away.
> Just wondering if people have noticed anything on the horizon. I did
> notice this:
> http://www.theinquirer.net/inquirer/feature/1563...way to open a form in mutliple instances?
Is there a way to open up a form in more than one instance. i.e. the same
form but different data? If so, what is the methos?
Thanks for any help.
Yes, there is. See the sample code at http://www.daiglenet.com/msaccess.htm
The Multi_Instance Forms download is the last one on this page.
"ThorBo" <ThorBo@discussions.microsoft.com> wrote in message
> Is there a way to open up a form in more than one instance. i.e. the same
> form but different data? If so, what is the methos?
> Thanks for ...Returning Multiple Values in a Single Cell
I posted this same question a couple of weeks ago but forgot to
mention a key point. My question was as follows:
I have read a few posts regarding this subject but am still somewhat
lost. I have a two sheet workbook (Excel 2000). On the first sheet
is a list of projects that my department will complete during the
year. A description of each project is given, a start date, an end
date, as well as which crew will be completing the work (Crew 1 or
What I am trying to do on the second sheet is to be able to type in
any date, and have the description of the project on that da...rpc-https on Single server
I am enabling rpc over https on single exchange server, which is also a DC
and GC. After installing rpc proxy component on Windows Server 2003, I used
ESM to enable rpc-http for Back-End server. Upon doing so, I got a dialog box
complaining there is no Front-End server in my environment. However, the
rpc-http for Back-End option is still selected. When I open outlook 2003
which is configured to use rpc-http, the connection status still use TCP/IP.
I checked the rpcProxy ports in registry, all entries are defined correctly.
Do I miss out any important steps or any websites I can refe...Single Site Single Org Multiple Domains Exchange 5.5
I have an Exchange 5.5 Server on a AD Domain and an Exchange 5.5
Server on a NT 4 domain. All same site and same org. I have been
able to install the Exchange on the AD domain and join it to the
existing site and org on the NT domain. My issue is that it will not
replicate with any of the Exchange servers on the NT domain. I have a
2 way trust and I have no issues going back and forth between the 2
domains to access shares or any other resources between the two
domains. The errors that I am getting in the Event Log are of course
9318 and 9322. I have tried host and lmhos...Single record
Is it possible to print a single record per page? I have a spreadshee
with 240 records and I want to be able to print a single record pe
page, preferably with the column headings vertically down the side.
have only a short time (about 20 hrs) to acheive this. :
zigeuner's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2752
View this thread: http://www.excelforum.com/showthread.php?threadid=47047
How about a small macro to get you started:
Dim w...Two accounts same machine share a single pst file
I have two accounts that I use on my machine each with their own pst file. I
would like to have both accounts point to a single pst so that I don't have
to use my pda to synch between the two. Any suggestions?
What you mean by "accounts" is not clear.
Assuming you mean Internet Mail accounts, just setup both accounts in the
"dsfds" <dsaf> wrote in message
>I have two accounts that I use on my machine each with their own pst file.
> would like...is it possible to use F9 to manually calculate in a single sheet or single workbook?
is it possible to use F9 to manually calculate in a single sheet or single
as i have got over 500 cells with vlookup in a single sheet, with more than
50 sheets in a workbook.
Shift+F9 will calculate only the active sheet. From the
XL Help for XL2003:
Press F9 Calculates formulas that have changed since the
last calculation, and formulas dependent on them, in all
open workbooks. If a workbook is set for automatic
calculation, you do not need to press F9 for calculation.
Press SHIFT+F9 Calculates formulas that have changed
since the last calculation, and fo...Route all emails to a single SMTP address ?
Due to severe issue on my BE server, I'm looking for a quick way to redirect
all the mails supposed to go to this server to a specific SMTP recipient,
whoever was the original recipient.
On Mon, 8 Nov 2004 14:32:52 +0100, "Chris" <firstname.lastname@example.org>
>Due to severe issue on my BE server, I'm looking for a quick way to redirect
>all the mails supposed to go to this server to a specific SMTP recipient,
>whoever was the original recipient.
if your BE is up the creek then you hav...single instance YET ...
I wish to have my MDI based MFC application to be single instance.
Let's assume I use the unique class name method.
When my application starts, I check to see if there's already an instance
running. If so, I set focus to active instance and terminate.
But now I wish this:
When a second instance is started with command line parameters, I wish to
terminate that instance, but pass the command line parameters to the first
instance (a file name, so that it can be openend as another document inside
my MDI application).
How do I pass this info?
Is it possible to pass this via a window...Rule Process Instance
I have rules I have created and only the admin user can process the instance.
Right now I have a manual rule that waits "if a pick list is changed from yes
to no then e-mail manager."
If I login to CRM as the admin user and select yes the rule fires fine and
e-mail is sent. If I login in as a user the rule stays in a waiting status
in the CRM Monitor. I then have to right click on the instance, select
properties and then pause and retry and the instance completes.
I did login as a user with administrator rights and created a rule and tried
to run it but the process will stil...Yet another picture database question
I currently have a database that loads pictures from a network location;
image1.picture = "\\server\share\picture.png"
as this enables me (or any user) to open the database from any computer on
Is it possible to load pictures from a local intranet http address instead?
The pictures I want are accessed in a browser by typing the following:
This would make updating the database easier as I would not have to open and
resave every picture to the network share.
Forgot to say, I am...RPC HTTP Single Exchange Server / Seperate DC GC Server
Just a post that may help others trying to achieve the same objective.
Single Exchange 2003 SP1 server (no front end server), seperate Domain
Controllers (2003, no SP1)
Clients, XP SP1 / SP2, O2 XDA via HTTPS
There are many thorough Microsoft documents, but as many have found they
expect either a single server that hosts all Exchange / AD roles, or a FE/BE
setup. What is not easily catered for (at least in SP1) is having a
dedicated Exchange server and having AD on dedicated servers (a recommended
I found all the pieces of the puzzle from either the Microsoft Exchange
Libra...OLXP AutoComplete: How to Delete Single Entry
Q289975 mentions "changing" a single entry, but not deleting it. Posts
to this list on the same subject mention how to delete entries from
the AutoComplete list, but those suggestions will not work to remove a
single entry from the cache. Can anyone suggest a procedure to remove
a single entry from the AutoComplete list that actually works?
OLXP AutoComplete caches resolved addresses into the <profilename>.NK2
file. Deleting the NK2 file removes single instances but that is a
rather extreme solution to the problem. Is there an editor that one
can use to edit the NK2 file to re...How to get the COLORREF from a CBrush instance?
Is there a way to get from a CBrush instance the COLORREF that was used
by CBrush::CreateSolidBrush() to create the CBrush? Thanks for your help.
May Young <email@example.com> schrieb:
>Is there a way to get from a CBrush instance the COLORREF that was used
>by CBrush::CreateSolidBrush() to create the CBrush? Thanks for your help.
Take a look at CBrush::GetLogBrush( LOGBRUSH* pLogBrush );
...Single Mailbox Restore, SINGLE server! Exchange 5.5
I have a 3 server 5.5 organisation. (all 3 servers in different sites
connected via a WAN)
I do not have a spare server. I realise this is the way to go... but I cant
do it this way so if anybody can offer any help?
I have a good backup (entire mailbox store NOT individual mailboxes) from
Friday night. Today is Monday night. (Veritas Backup Exec 9)
I deleted a mailbox accidentialy today. Its gone! - If I restore the server
using Firdays backup, It will re-appear I imagine. BUT when all the
transaction logs get procesed from them until the time I begin the restore,
will the ma...Recording multiple checks in a single deposit
This seems like it's probably brutally simple, but I
can't figure it out: how do I record multiple check
numbers in a single deposit?
The deposit consists of a couple checks from my primary
checking account which I'm depositing, along with some
cash, as a single deposit transcation in a different
Using MS Money Deluxe 2003.
In microsoft.public.money, hodgdon wrote:
>This seems like it's probably brutally simple, but I
>can't figure it out: how do I record multiple check
>numbers in a single deposit?
>The deposit consist...Cannot Open Multiple Instances of Excel
I cannot open more than one instance of Excel from my MS
Office Shortcut Bar, yet I can open more than one instance
if I open Excel from my Programs menu or the Excel
shortcut icon on my desktop. Any ideas? Thanks.
The one on the Office Shortcut Bar probably has "/recycle" in the command
"Randy" <firstname.lastname@example.org> wrote in message
> I cannot open more than one instance of Excel from my MS
> Office Shortcut Bar, yet I can open more than one instance
> if I open Excel from ...Can I divide amount from a single transaction?
I would like to ask if I can divide amount from one transaction.
Let's say that I deposited total of $200 into checking account at bank.
The $100 is cash, the other $100 is my paper paycheck.
On MS Money screen, it shows "$200" as a single transaction.
Can I make this into two transaction, so I can categorize them separately?
Set up a new account within Money and set its type to "Cash" (i.e. not
a bank account).
This cash account is where you will create the $100 paycheck
transaction. This account would also include a transaction
correspondi...Exchange 2000:allowing single user larger message send size not working
Ok, I've been through all the knowledgebases, and I'm nearly 100%
positive I've got this setup right, but it still doesn't work.
I've got a Global Settings/Message Delivery/Sending Message Size Limit
There is NO limit set in the SMTP VS.
I've got a very small number of users I want to be able to send
messages larger than the 10MB limit. So for those individual users,
I've increased their individual sending message size limit to 25MB.
It still didn't work - the Exchange server rejects the message as too
large to send.
Everything I find insists that...Single session only?
Hi group, is there a way to force or throttle outlook 2003 to only make
1 server connection at a time? Currently, it sends and receives
together. This is causing problems with my Linux IMAP server.
email@example.com <firstname.lastname@example.org> wrote:
> Hi group, is there a way to force or throttle outlook 2003 to only
> make 1 server connection at a time? Currently, it sends and receives
> together. This is causing problems with my Linux IMAP server.
Create a separate send/receive group for each account. Create separate
send/receive intervals for each gr...single quote xml value
EvtEnrollAttr.Value = "3748"
i need the attr value to be <stuff ID = '3748'> in single quote
how can i do that with visual basic.net?
Use EvtEnrollAttr.Value = "'3748'" (single quote's inside double quote)
"dotnetnoob" <email@example.com> wrote in message
> EvtEnrollAttr.Value = "3748"
> i need the attr value to be <stuff...Locationwise Sales and Stock in a Single Report at HQ
Hi to all the groupmates
Is it possible to have a report from HQ wherein for the sales , the date
range validation is given (From date and to date) and only the total sales of
an item per location is displayed seperately. Along with this the current
stock of the item of the location also to be displayed.
hi RK, it is already availble, you can go to HQ> Reports> then click on the
Sales and click the Sales Detail Report put the the date range. then from the
column selector select the On Hand column which will show you the onhand
current qty of particular item. I hope this satisfy y...Pasting Word table cell with paragraph markers into single Excel c
I have a Microsoft Word document that contains a table, each cell of which
may contain paragraph markers. I need to copy and paste this table into
Excel. However, whenever a cell from the Word table contains paragraph
markers, rather than pasting the contents of the entire cell into a single
cell in Excel, the paragraph markers are treated as delimiters, and the data
is pasted into multiple Excel cells. If the cell from the table in Word
contains one paragraph marker, then when I paste that cell to Excel, it
pastes it into two cells. If it contains two paragraph markers, then it