Using xlDown as a function?
I'd like to append data to the bottom of an existing spreadsheet, I
have a macro that will import the data, I just need to know where to
paste it. Can I use something like (((Selection.End(xlDown))+1).Select
to select the row below the bottom?
I like to pick a column that always has data and do this:
dim DestCell as range
set destcell = .cells(.rows.count,"A").end(xlup).offset(1,0)
John Sutton wrote:
> I'd like to append data to the bottom of an existing ...Using Money 2006 file with Money Plus
Hello, I wonder if anyone can help me please? I am on a business trip
and my laptop (and cash, tickets, credit cards, and so on) was
stolen. I have a backup of my .mny file, and a loan of a laptop,
however I am still away from home so I can't reinstall from the Money
2006 CDs. So, I thought I would download a trial copy of Money from
the MS web site. The only one I could find was Money Plus, so I
installed that. However when I try to open my .mny file using Money
Plus, it is looking for a Live ID and password. I never used a Live
ID with my old .mny file - just a password. I tried e...[SPAM]
All of the sudden the word [SPAM] is inserting itself into
the subject line of my e-mails outside of our
organization. This just started today and I'm not sure
why but I would like to stop it. Please advice.
>All of the sudden the word [SPAM] is inserting itself into
>the subject line of my e-mails outside of our
>organization. This just started today and I'm not sure
>why but I would like to stop it. Please advice.
That's not something Outlook does. Check with your IT people to see what
they might have done.
3290 Patterson Ave...Filtering records by date
Yea I'm trying to filter a table that has specific due dates, but I want to
run a query that will show the results 7 days before the due date and not
show all the records just the records that have the due date 7 days prior to
the due date. Also wondering if anyone knows how to make it where the query
could send an email notifier to people when a record hits the 7 day prior to
the due date mark? Thank you for all your guys time.
A criteria under the DueDate like:
>= Date( ) AND < Date( ) + 8
should display only the records where DueDate value is today or l...how to create chart using data on different worksheets in xls
I get weekly data of different diseases from different places that I enter
indifferent worksheets in an excel file. I want to see the continuous trend
(disease and place wise). For that, without entering data again, I need to
create a chart using data on different worksheets. How do I do that? Can you
please help? Thanks.
You may have to construct a helper range one another worksheet. With some
clever formulas, it shouldn't require too much work to maintain.
Jon Peltier, Microsoft Excel MVP
Peltier Te...Outlook Profiles When Using a Terminal Server
We have created a Terminal Server, Windows 2003 Enterprise 32bit, and have
installed Office 2003 on it. Office was installed in Application mode and
then SP3 for Office 2003 was installed.
When a user logs onto the terminal server, the Outlook profile is not
automatically connecting to the user's mailbox.
Can anyone tell me whether or not this is normal behavior, or where I might
be able to find more information so that I can get this resolved?
your description of the problem is way to vague, please tell us EXACTLY what
happens when you ...Using Table to Select Records from Larger Table with Join
I am attempting to select records from a very large database by using a table
with member ids joined to the larger tables with the same field. The Select
table residess in the database, the larger table is linked to ODBC. I am
creating a table from the matching records.
When I run this, it never completes. The select table has approximately
Is there a better way to accomplish this?
"NEVER" completes, or you just get sick of waiting? Cut your select
table to 1 record, and see if it runs.
How large is this very large database? Is your memberID...how to stop the Spam Mail
I set the exchange to anonymous access,
So my local javamail can send mail freely.
But other might send Spam Mail with the server.
How can I stop the Spam Mail?
jun <email@example.com> typed:
> I set the exchange to anonymous access,
> So my local javamail can send mail freely.
> But other might send Spam Mail with the server.
> How can I stop the Spam Mail?
Are you talking about relay? Don't allow open relay; you can set up your
virtual SMTP server to allow authenticated relay or you can allow certain
local ...Help with Formula using Analysis ToolPack Function ISODD #2
Thank you, but this workaround gives me the* total * number of Od
numbers for the complete Dynamic Named Range ROOMS.
Is it possible to get the *count of Odd numbers per/ for eac
individual Row of 9 Columns* using the Dynamic Named Range ROOMS.
Peo Sjoblom Wrote:
> One workaround
> Peo Sjoblom
> "Tin�" <Tin.firstname.lastname@example.org> wrote in message
> > Hi,
> ...SPAM #17
I keep getting system undelivarable messages. It seems as if something
on my network is sending out spam. I'm not really sure but here's what
it looks like:
Your message did not reach some or all of the intended recipients.
Subject: Delivery Status Notification (Failure)
Sent: 1/2/2007 11:45 AM
The following recipient(s) could not be reached:
+._-ddddccfedcdff@CASTLENEROCHE.COM on 1/2/2007 11:46 AM
The e-mail account does not exist at the organization this
message was sent to. Check the e-mail address, or contact the
recipient directly to find out th...can not open excel files using associations
I am having problems to open an excel spread sheet by double clicking on the
file itself. Please, any ideas?
Try Tools>Options>General and un-check 'Ignore other applications'
Microsoft MVP - Excel
"Marcela Pruk" <email@example.com> wrote in message
> I am having problems to open an excel spread sheet by double clicking on
> the file itself. Please, any ideas?
> Thank you
And ...Problems with Advanced Filter in Excel 2k
We had exactly the same problem. I found a workaround for us which is, as yet,
a bit clumsy but may be of help to you.
Our set up is NT4 w/s with Netware 5.1 NOS. The w/s are tightly tied down using
NTFS permissions and this is coupled with Netware policy packages. We use
Netware's DLU and user profiles are stored on our servers.
Having found that the local w/s administrator could use Advanced Filter with no
problems I tried all the usual tricks such as taking all restrictions off a w/s
and giving users full rights to HKLM. No joy. Concluded that it must be a key
in the administra...Persuade the Luddites to use Source code control
I am a contractor for an NHS trust. We are currently upgrading our 2005
server to 2008 and planning to move development away from Access and write
more code directly into the database and serve information using SSRS.
I am really struggling to convince anyone that source code control should be
a vital part of this project.
1) No one else really understands what Source code control is and what it's
2) There is no one else in the team who has ever worked in a production
development environment before. They are all used to Access and writing
horrible ...Protocols used by socket (Datagram)
I know that protocol used by CAsyncSocket (or CSocket) in Datagram
configuration is UDP. I'd like to known the other protocols used during the
communication and principally the initialization or "connection" phase.
Any information making the relation between CAsyncSocket connection steps
and the protocol used would be great! Something like :
1- ARP[Data ...]
2- ARP[Data ...]
3- UDP[Data ...]
4- UDP[Data ...]
::Master:: ...How do I stop Outlook from marking messages as spam?
I have two email addresses going into outlook.
My main business address (prettypatios.com)marks all messages as spam. While
the other email address (with sbcglobal.net) doesn't. How can I change these
settings? The mail goes to my inbox, with the spam notation on the subject
line. So every time I reply to a message, I have to remember to delete the
spam notation from the subject line. I don't want clients thinking I've
marked their addresses as spam!
I'm using Outlook 2003
That's not Outlook that's doing it. It's something likely happening from
your ISP. C...Sent messages viewed as spam on other domains
I've just set up a Server 2003 environment with Exchange 2003. I'm
working on sending and receiving messages using the Outlook Web Access
feature. I am able to send and receive messages to other domains, say
firstname.lastname@example.org or email@example.com.
My problem is that my email messages are going into Google and Yahoo's
spam folders. How do I prevent my outgoing messages as being viewed as
On 19 Sep 2006 11:55:42 -0700, "hans" <firstname.lastname@example.org> wrote:
>I've just set up a Server 2003 environment with Exchange 2003. I'm
>wo...Using Time as axis, and displaying info on plots
Hi every one...i've been racking my brain out on this one.
I'd like to come up with a way to display things better.
Background: I am making a running worksheet that has events fo
multiple days. each day has a varying number of events. In order t
effectively display the data for my boss, the best way is to do it on
24 hour clock instead of the standard 12 hour clock. This allows us t
see patterns occuring at certain times.
The way I have it currently set up is converting times to angles an
using the days as magnitudes. Basically doing a polar chart t
cartesian conversion. This...Problem with creating a Mailbox on an existing user using a .vbs script
I am getting an error when I try to run the script below.
Error: Object doesn't support this property or method:
Can anyone find what the problem is? I have tried different methods,
but none of them are working for me.
Thanking you inadvance.
Const ADS_PROPERTY_UPDATE = 2
Const ADS_PROPERTY_APPEND = 3
Const ADS_PROPER...How to determine which PST file current be used?
Due to 2G size limitation, we want to write a small program to check the
size of PST file whether is nearing the 2G. The question is how to
determine how many PST files are used by OUTLOOK and where they are
> Due to 2G size limitation, we want to write a small program to chec
> size of PST file whether is nearing the 2G. The question is how to
> determine how many PST files are used by OUTLOOK and where they are
So many questions... How many people are using PSTs (I'm trying to fin
out if...using log4net to log to databse
I am trying to use log4net to log every thing to a mssql 2008 database.
Here is what i have
$configFileInfo = gi "C:\Log4net\log4net.xml"
[log4net.GlobalContext]::Properties["timestamp"] = Get-Date -Format "yyyy-MMM-dd_hh-mm-ss"
$...using between ... and
I want to be able to do the following :
I want to know if a customer has bought something within a predefined
period, starting from a varying date. My data are recorded in table tblA.
Customer A bought item a on date dteA 01/01/2008 (European date format :
Did he buy another item a in the period ranging from 01/01/2008 till
Say : customer A bought on 01/01/2008, 03/01/2008, 07/01/2008 and
15/01/2008. It is clear that I do not need the purchase on 15/01/2008.
I used two instances of tblA, namely tblA and tblA_1.
I used [blA_1]![dteA] between [bl...Spam, Spam, Spam
I just recently became all to aware of the term spam.
Over the last 30 days I have recieved over 300 e-mails
from just junk to the why is this in my mail! I have
started to use the junk e-mail folders but have noticed
no decrease in the spam. What can I do?
Get mailwasher? www.mailwasher.net
There are other options available - see
http://www.slipstick.com/rules/junkmail.htm for suggestions and other
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.o...Please help us test Exhange Spam Filter
We are a small Danish company fighting spam. We have a lot of users on
our client solution for Outlook and Outlook Express, but our new anti
spam Exchange Module give us trouble. Out of 10 people downloading it,
only 1 finish the installation and we simply can't find the error.
Please help us out, we really need some fresh eyes on the project.
b2R1Y3QgY...how to retrieve current values assigned for names used in EXCEL?
I got a spread sheet from some one else. There were formulas used using names.
I like to retrieve the values used for different names used in the formulas.
Please let me know for any questions.
and you will be able to find the names and either cells, values or formulas
assigned to the names.
> I got a spread sheet from some one else. There were formulas used using names.
> I like to retrieve the values used for different names used in the formulas.
> Please let me know for any questions.
> R...IMF Spam Filter
I have IMF Filiter Installed and running. But I have a problem that valid
email from two senders is always getting Blocked. The email content is safe
and innocent. Gateway SCL is at 4. We are happy with this level of UCE
Is there a table anywhere that addresses of non-authenticated users can be
placed so that they bypass the SCL scan?
The only option available to you is to add their SMTP servers IP address to
the Global Accept settings under Connection Filtering.
"Dash" <Dash@discussions.microsoft.com> wrote in message