after crash forms display #NAME?
I was working on my Db when all of a sudden it crashed. I saved a backup
and closed it down. I opened the back up and now on my main " Job
Information" form, almost all of my text boxes with equations display
"#Name?". Some of the text boxes reference other tables, some other forms,
and some the same form they are located on. I checked the data source an a
select few boxes and all the data, according to my table, is correct. Its
worth noting that the entire DB was working perfectly before this crash.
Now if i go into design mode for the form, delete any t...macro: save w/ new name and print
I assigned a macro to a button in my worksheet on the basis of som
advice that I got in this forum (see macro below).
The macro saves the current workbook on c:\ and gives it a new filenam
with a date/time stamp.
However, I want the macro to do the following additional things now:
-Save the file in the current directory, without me specifying tha
path in the macro
-Also include first and lastname of user (contained in cell A1 and B1
in the filename.
Also, I want a second version of that macro which
-prints a specified sheet (called "output") while/after closing.
Any help ...Showing list of range names available for formulas??
Operating System: Mac OS X 10.6 (Snow Leopard)
I know this MUST be possible in Excel...but I can't seem to find it. I have named ranges. I am entering a formula and want to refer to a range name. I don't remember exactly what I called it, or it has a long name that I don't want to have to type. Can't I use some sort of function key to just show a list of the available named ranges, so that I can point to the one I want? In excel for windows, we used a function key (can't recall which one). <br>
Rev...Forgot my password and want to change user name
I want my user name to be gpellicce instead of grodriguez4
...Formaula for less than date and name begins with...!!! HELP!!!
IM trying to create a formula that gives me a total count for cells that are
less than 02/05/10 and the name begins with FHLM, heres what i came up
I keep gettin a bunch of ###### or 0, depending on how I move the data
"Senor Martinez" wrote:
> IM trying to create a formula that gives me...Worksheet Names
Is there a way to get the Worksheet name/s into a cell without vba code??
try the following formula for the sheet name
> Is there a way to get the Worksheet name/s into a cell without vba
That's the seventeenth time you've posted this reply this week, but you've
suddenly dropped all the details about path, file, etc. You must be getting
"Frank Kabel" <frank.ka...Duplicate Fund Names
I have "Fidelity Contrafund (Symbol: FCNTX)" in my 401-k account for a
number of years and have a lot of transactions entered in my Money Plus
Recently Fidelity changed the fund name from "Contrafund" to "Contrafund K".
This time around, when I downloaded the transaction, there are two
transactions one which sold all the old "Contrafund (FCNTX)" and a second
which purchased a new "Contrafund K".
So, when I try to update the statement, money is treating Contrafund K" as a
new investment and giving me two opti...Named pipe problem
I followed Microsoft's Overlapped sample to create a namedpipe server, but
in WaitForMultipleObjects, the first event always occured. It makes me
couldn't to send message to other named pipe clients.
DWORD dwWait, cbBytes, dwErr;
LPTSTR lpszPipename = _T("\\\\.\\pipe\\eventpipe");
for (int j = 0; j < MAX_PIPECLIENTS; j++)
// Create an event instances
m_hPipeEvents[j] = CreateEvent(
NULL, // no security attribute
TRUE, // manual-reset event
FALSE, // initial state = signa...Field Name Error Msg
I've got a workbook with many sheets. One sheet has pivot tables on it and
one other has charts, charting data pulled from the pivot tables.
When I open the workbook I get three errors, one after the other, which say:
The PivotTable field name is not valid. To create a PivotTable report, you
must use data that is organized as a list with labeled columns. If you are
changing the name of a PivotTable field, you must type a new name for the
That's all well and good but I'm not the only one who uses this workbook and
I don't know where these errors are coming f...Referencing a worksheet name
I am creating a generic workbook. Each worksheet of which relates to a
member of staff. An example of the sheets is Summary, Name 1, Name 2, Name
3. I would like to define cells in the summary worksheet so that the value
returned is the name of the sheets. So if sheet "Name 1" is renamed "Bill
Smith" Bill Smith appears in the relevant cell in the summary sheet.
I hope this is clear and if you could help i would be grateful.
Take a look here:
Also, see David McRitchie'...outlook remember wrong server name
I have installed exchange 2003sp2 on windows 2003sp1
inside a windows 2000sp4 AD domain. I have exported
mailboxes data with exmerge from an exchange 5.5sp4
installed on the windows 2000 DC. There isn't any AD
connector. Here is my network diagram:
windows 2000 ad domain
|windows 2000sp4 DC| --------- |windows 2003sp1 DC|
exchange 5.5sp4 exchange 2003sp2
Now outlook doesn't connect to the new ex2003sp2 till
I shutdown exchangeIS on the windows2000sp4. It always
connect to the windows 2000 server w...Name Matching
when an email is sent to a miss-spelled address, how do I
route these emails to a postmaster or admin account?
What version of Exchange?
For Exchange news, links and tips, check:
"Matt" <email@example.com> wrote in message
> when an email is sent to a miss-spelled address, how do I
> route these emails to a postmaster or admin account?
Exchange Server 2003
Running on Windows Server 2003
How do I change the name that is in the microsoft.public.excel.misc column
Since you use outlook express you have to do it there
tools>account and select the news account in question and click properties
then change the name
"Roger Bedford" <firstname.lastname@example.org> wrote in message
> How do I change the name that is in the microsoft.public.excel.misc column
...Insert Image with name and filepath
I have three columns formatted as below. I want to read the value in column
B and insert the image in column C. All images are located in a specific
folder and I need all the images to be inserted into a standard cell size.
Is there a way to cascade down thru the list and insert them programatically?
if I provide this file with a part number, description and a hyperlink to
somehow then pull an image of the part when clicked from an opposing
worksheet - is this possible? I guess I am not only looking the execution
but also idea's from people who have more expertise....File names in a directory
Is it possible to make excel report a list of files names in
If so how
Message posted from http://www.ExcelForum.com
Try the following. It is not fully tested and contains no error-handling:
It's written to list the files from a floppy but you can change that to your
folder. From Vasant. HTH Otto
Do Until MsgBox("Any more floppies?", vbYesNo) = vbNo
MsgBox "Insert floppy disk and click OK."
Dim i As Long
.LookIn = "A:\"
...How can multiple users access same mailbox and send as that mailbox name?
I'm hoping this turns out to be a dumb question with an easy solution:
My customer wants both user-1 and user-2 to receive all mail addressed to email@example.com.
Additionally, the customer wants user-1 and user-2 to send all their mail mail with
firstname.lastname@example.org as the default sender address. User-1 and user-2 should be able to see all mail
sent with the email@example.com sender address, whether sent by user-1 or by user-2.
Any changes, deletions, etc, made by user-1 should be seen by user-2 and vice versa.
Thanks for your help!
I have list of Employee names in one column, it include first and second names.
I want to take only first name of all employees.
Is there any formula to take only first name.
(remove nothere from the email address if mailing direct)
"vishu" <firstname.lastname@example.org> wrote in message
> I have list of Employee names in one column, it include first and second
> I want to take only first name of all employees.
> Is there any formula t...Invisible Column names and Row numbers
I received a work sheet from my friend which has data from a1 to m60.
But surprisingly after the column M, whole letters are invisible and same in
numbers after 60 it is invisible, like sealed with a color pack.
How do I see number 61 onwards and column M onwards N O P etc etc ..
Sounds like your friend hid the columns/rows. Column M, and drag to the
right. Then right-click, unhide. Repeat similarly for rows.
"Suresh Lohar" <email@example.com> wrote in message
news:57D...Function names from addins stored in XL files
I am fighting with names of functions stored in addins.
In xls and xlsx files in most cases the name of the addin file (xla or
xlax) is not displayed if the addin is installed.
Saving as .xml files allows one to see the full names of the addins.
I have seen cases where the usual name is used similar to
'C:\Program files\the addin dir\theaddin'!theaddin.xla
but in some other cases the 8+3 version of the directory is used
'C:\PROGRA~1\the addin dir\theaddin'!theaddin.xla
It is really that strange, the initial part of the directory is the
short version, but for the subdirectories ...Dynamic named ranges
I'm trying to import an Excel spreadsheet into an existing Access
table using Office 2003. Ultimately, the plan is to do it
programmatically using TransferSpreadsheet, but to check that the file
has no problems, I've done it manually with the Import Spreadsheet
The worksheet has 43 rows, and I import a named range defined as
"=Sheet1!$C:$E". The import works, but I get a table with 64K rows,
all but 43 being blank!
Is there a way to define the range so that only filled rows will be
imported? I don't want to use the last row's address explicitly,
because I wi...Hosting several internet domain names on one Exchange 2003 Server
I have a simple setup with SmallBusinessServer and 1 domain. We use Exchange
and ISA 2003.
Our domain is registered for use on the internet and employees use
email-addresses with that domain, f.ex firstname.lastname@example.org
We have also registered 3 other domains on the internet (domain2, domain3
and domain4.com) and we want to use these domains in our emailadresses as
well. I can successfully setup this on each Active Directory user and send
mail on our internal network. When trying to send mail from outside our
company, I get an response saying "cannot relay..." immediately.
Th...? Make entire sheet of same-name labels using mailmerge
My art organization would like to make each member their own 'custom' sheet
of artwork identification labels as a thank you gift.
I am setting the project up in Publisher 2003, using Avery 5163 labels (10
labels per sheet). I have everything working great (mail-merging from an
Excel file), but no matter what I have tried, I can't seem to make 'one' name
print "10" times on one page of labels.
I am sure this can be done somehow, because several times a year I receive
personalized address labels from various organizations asking for donations.
Any help is ...Naming columns
I have a worksheet for our small business to keep track of all the
financial data. I would find it alot easier if the columns could be
changed from "a", "b", "c", etc. to have the name of the data which
goes in that column, for instance "courier" "power bill" "vendor" etc.
THe problem is when I am entering data in a column on say line 100, and
cannot remember what that column is. Currently, I have a paper cheat
sheet indicating what each column is for, but I would rather change is
on the program. I hope I am describ...Exchange 2000 Database Name
I'm trying to run a repair on my Exchange 2000 database (eseutil.exe). It is
asking for the database name.
How do I know what is the database name?
Pull up properties on it in ESM - click the database tab.
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup.
Use of included script samples are subject to the terms specified at
"Sam" <email@example.com> wrote in message
news:uNh9Joq...Descriptive headings in report header derived from report's name
I have numerous reports for which I want to create headings in the report
headers, derived from the (object) name for each report.
For efficient editing of report headings, I have created a query derived from
MSysObjects and added fields that, when concatenated, produce the desired
descriptive headings. I thought to have each of the report names link to
their corresponding names in the table so that the concatenated fields unique
to each report would be displayed in the report headers.
How do I get these headings from the table back into the report headers? My
efforts have so far been unsuc...