Count File Names
I having an issue with version control on Buisness cases. I currently
have a spreadsheet that looks into a folder and picks up details from
a number of files. However, they require version control numbers so
there will eventually be multiple files say 2010-01 v1.0, 2010-01
v1.1. Is there a way I can:
1) Get a macro to count the number of 2010-01 files there are in the
2) Get my version control sheet to look at the latest version of the
file (in this example: 2010-01 v1.1)
See if this code works. I assume that 2010-01 is year and month.
...M2004: Change name on home page?
I'm using Money 2004. On the home page it says "So-and-so's Money Home
Page". How can I change the name that appears there?
> I'm using Money 2004. On the home page it says "So-and-so's Money Home
> Page". How can I change the name that appears there?
Figures... I always seem to find a solution right after posting a
question! Click Accounts & Bills, Account Setup, Update Personal
...Replying in Newsgroups
Using Outlook 2007, Vista Home Premium SP2, HP DV6500 Notebook
When replying to newsgroup messages (uses Outlook Express for this) the =
repeated original message lines are not prefixed with the > symbol, =
despite options being set to do this. Seems to be a problem that has =
started recently despite my not having knowingly changed any settings.
Any help appreciated.
Dave S. wrote:
> Using Outlook 2007, Vista Home Premium SP2, HP DV6500 Notebook
> When replying to newsgroup messages (uses Outlook Express for this) the repeated original message lines ar...Reply rule doesn't work consistantly
I've got an Outlook 2003 client and we are trying to setup a rule to
emulate the Out of Office Assistant. I've setup a rule that is
supposed to send reply with a template if the sender is from a list of
contacts that I've chosen. It isn't working as expected. The first
time I tried it, I entered only one (internet) email address which
worked perfectly. If I add any addresses to that list, it doesn't work
anymore - the reply is not sent.
I know that it can reply to internet email addresses, since it worked
that one time, but I can't figure out why it won't work when...Name prefixing in reply message
I'm not even sure what terms to google for related to this problem. If you
get an email from someone in the Office XP version of Outlook, and you click
reply to that email, then start typing inside the portion of the message
that contains the original message you replied to, it will automatically
prefix everything you write with your name. How does one turn this off?
Thanks in advance!
> I'm not even sure what terms to google for related to this problem. If you
> get an email from someone in the Office XP version of Outlook,
> and you click...Server-Wide Auto-Reply / Address Change Notice
We are in the process of changing domains as far as email/web addresses are
concerned and I wonder if it would be possible to have Exchange reply for
each user with a message stating something like, "This is an automated reply
letting you know that the email address for User Smith is now
I realize that each user could create a rule in Outlook... but we would need
the rules to apply for a long period of time and that could be very annoying
for senders... getting hit with constant auto-replies.
Even if it would be possible for a user to create a rule th...Outlook 2002 coming through with reply but nothing is there
Confusing situation. ISP support has never heard of this
problem, hopefully someone here has.
3 people share a mailbox. One of them sends an e-mail.
The recipient replies. The reply comes through just
showing the original e-mail but not their reply. It also
says it came from (for example) "email@example.com on
behalf of firstname.lastname@example.org"
Now, the weirdest thing is, not all 3 get the same thing.
One of them may get it with the reply, and the other 2
not. One of them may get it without the reply but upon
closing Outlook and re-opening it, the reply is there. I...Comparing first and last names in two lists #2
I have two data sources that each contain about 8000 names in seperate
fields for first and last name. I can put them on seperate worksheets
or append one to the other. I need to make them match and find out
where they don't. Messed with consolidate but not sure if that will
work for more than one column at a time. FYI data set one is from a
school transportation database and data set two is from the main
student database from the same school district.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages dir...Drop-Down box
I have been asked to create a drop-down box in Excel with
pre-populated names. I really do not know how to get
started with this. If anyone could help that would be
You can use Data>Validation. There are instructions in Excel's help
files, and here:
> I have been asked to create a drop-down box in Excel with
> pre-populated names. I really do not know how to get
> started with this. If anyone could help that would be
Excel FAQ, Tips & Book List
...Different display names
Is there any way to have an account display differently in the FROM field
compared to the GAL (Exchange 2003).
We would like the user to appear in the GAL as "Bob User" but when an
external recipient reads an email it should be displayed as "Bob of Company
...File name from a cell
I am trying to have date in a cell become the file name and appear i
the save as dialog box as the file is saved the first time
Message posted from http://www.ExcelForum.com
Dim mySuggestedFileName As String
Dim myFileName As Variant
mySuggestedFileName = "c:\my documents\excel\test\" _
& Format(.Range("a1").Value, "yyyy_mm_dd") & ".xls"
myFileName = Application.GetSaveAsFilename _
...How do I create drop down form fields in Excel?
Is it possible to create dropdown lists in Excel? If so, how do I do it?
You can use Data Validation to create the dropdown lists. There are
instructions in Excel's Help, and here:
> Is it possible to create dropdown lists in Excel? If so, how do I do it?
Excel FAQ, Tips & Book List
...Unlocking named ranges
I am working with a spreadsheet created by a former employee. He used named
ranges a lot. I am trying to understand the worksheet. When I see an
equation in a cell like =Sum(Shipments) I feel I know what it means.
But how do I learn what the actual cell reference is ie = Sum(D2:G2).?
Insert a new, empty worksheet into the workbook. Then you can use The
Insert-> Name-> Paste menu option and click on the Paste List button to get a
listing of all the names and the definitions
> I am working with a spreadsheet created by a former employee. He used...Adding company name to the "From" field
Hopefully this is an easy problem. We are running Exchange 2003 on Windows
Server 2003 in a mixed domain. (Win2k and Win2003 servers)
Lets say I am working for a company named "XYZ". The owner of the company
wants the "from" line in the email client to say "Bill Smith, XYZ Company".
Unfortunately I can not find a way to do this. Any help is appreciated.
Just use ADModify to rewrite the Display name for every user in your
company, or for users of that company (if companys are sharing and AD)
ADModify can be found here:
http://www.gotdotnet.co...reading file name from folder function
I am using Access 97. Just wonder if there is a fuction which can read all
the file name from a folder and put it to a column in a table. Please let me
>I am using Access 97. Just wonder if there is a fuction which can read all
>the file name from a folder and put it to a column in a table.
Please see the getFileInfo( ) function in the tip, "How to compare the
contents of two directories," on the following Web page for an example:
See http://www.QBuilt.com for all your database needs.
See http...Domain name not always needed to log into OWA?
This is something I've wondered about for a while.
Why is it that only some of our new Exchange Server installs insist on
the OWA login <up to 13 chars. of domain name>\<user name> while
others have no trouble with only <user name>?
"Julie" <email@example.com> wrote:
>This is something I've wondered about for a while.
>Why is it that only some of our new Exchange Server installs insist on
>the OWA login <up to 13 chars. of domain name>\<user name> while
>others have no trouble with only <user name>?
Probably b...edit suggest names when completing To, cc and bcc fields
Apparently I don't have an Address Book linked to Outlook
2000. No matter, because I seem to be ok with the suggest
names feature, which I guess is not Address Book-linked,
but linked to a memory bank of names and corresponding
addresses typed in during the past.
However, here is my question:
How do you edit this Suggest Names list? In particular,
A. Suppose you want to stop Outlook from suggesting a
particular name because it is not current anymore. Worse,
you might inadvertantly click on it and send msg to
somebody you don't want to receive it. Is there a way to
I created several worksheets that contained huge lists, so I created a
dynamic named range. Now that the name has been inserted in my array
formulas, my Macro runs very slowly. The Macro unprotects one of my sheets,
sorts the data in a table, hides the blank rows and the protects the sheet
again. There are no related named range formulas in that worksheet, so I'm
not sure why it would be affected. The Macro ran quickly when I had a
defined range of data.
Would giving a named range like 'Date' and having text in my workbook with
'Date' create conflicts? Could this...Report names in listbox
I recently upgraded to Access 2007 and am having some trouble with the
changes. I have a form with a listbox in which I would like to display the
names of all the reports in the database. I've tried using the following as
the rowsource for the listbox, but in form view nothing is displayed. Does
anyone know how to do this?
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;"
I think you made a slight typo. Try (((Left([Name],1))<>&quo...Send Emails With A Different Name Than How Its Listed in the GAL
Hi all, I have a quick question:
My client is unhappy with how his emails get sent out from MS Outlook.
The GAL on our server lists names as [Last Name], [First Name]. This is
how the majority of our clients want it. However, he wants his to be
[First Name] [Last Name]. So, all recipients getting emails from him
will see his name as First Name, Last Name. We can't do this for him on
our GAL, since it would obviously cause an inconsistency if we did it
only for one name. But, I figured I'd post here to see if anything else
can be done to accomodate him.
Thanks in advance for your help...Switching Names Around
I am getting a list of names imported into Excel. All the names are in the
order of LAST NAME FIRST MI/[SPOUSE] FIRST [SPOUSE] MI. All of them have
their last name at the beginning, and they're all merged into the same cell.
I am trying to print out mailers, so I need the 1st name moved to the back
of the line so it prints out normally. How would I write a macro to do this?
The only way I can think of is to signal is off the very 1st SPACE-
everything before that space gets added to the end of the line. Is this
possible to do? How do I do this? I'm not very good at VB, so...Access server name?
I have been using SQL Server 2005 and I'm now trying to move to Access
(Microsoft Office Access 2007).
One question, with SQL Server 2005, there is a Windows Service called "SQL
Server" which is running all the time and ready to be connected from a
database application. In the case of Access, what is the equivalent program?
I do not see any Access program in the Windows Service List.
Thanks in advance!
Polaris <firstname.lastname@example.org> wrote:
> Hi Experts:
> I have been using SQ...drop down lists in Business Portal
When requiring a query selection for filtering (such as in Purchase Request),
the go button (right arrow on green background) should be automatically
pressed when a selection is clicked.
I think it would be as simple as adding an 'on changed' event to the drop
down list to call the button, and would make the user interface more
intuitive and comfortable (less frustration than if you're waiting for your
results and not realize you didn't hit the button).
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most vote...Drop Down Menus #2
I recently saw a worksheet that used a "drop down menu" in one cell.
This drop down menu is a list of months of the year to choose from. I
noticed that the only way to see that the cell had a drop down was when
I highlighted the cell. How does one create such a drop down menu by
using this one cell?
I am using MS Excel 200 and Windows 98SE.
lsmft's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30678
View this thread: http://www.excelforum.com/showthread.p...Fill in text from drop down list box in Excel
I have created a drop down list box but the list is getting too big and
the user has to scroll down the list to select the data. Is there a
feature I can use to display the data that start with the same string.
For example: If I type "Be" in my box, the box could display the list
that start with "BE or Be".
I created the drop down list by using "Data", chose "Validation", and
chose "List" from the "Allow" tab.
Thanks for your help.
If your drop-down list if from Data Validation, you cannot have Autocomplete.