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...FRx Consolidations #2
I am trying to consolidate two companies with a different
account structure. The column format has an account
filter and the condolidation is not working.
Company One: #####
Company Two: #####-##
Column Accout Filter: ?????
Note: The first five places of the account in both
companies is the same, Company Two has additional
When I try to run the consolidation, I can only get one
company to tree up, the one whose account structure
matches the column account filter.
What do I need to do to make the consolidation work?
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
...Zero-value Budget Column in FRx SP11
We have just resolved an interesting problem that one of our customers
was encountering after upgrading from FRx SP9 to SP11, that I'd like
to share with you all, along with our resolution. Bear in mind, I am
not recommending this resolution to you, so much as providing it to
assist you with your own enquiries.
The symptoms of the problem are as follows:
A report contains a two columns, a budget column and an actuals
column. Running the report on FRx SP9 produces the correct figures.
Running the report on FRx SP11 produces correct actuals, but the
budget figu...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....GP 9.0 user logins passwords
We are using GP 9.0. Is it possible to disable the option of allowing
users to change their passwords, when they login to GP. I understand
that Great Plains user passwords are encrypted and you cant use the
same passwords to login to SQL server directly. To overcome this we can
override the passwords directly in SQL server. I have to change the
passwords directly in SQl to enable users to login to Frx with same
user ID and password as in GP. Unfortunately when I change the user
password within SQL server, and the user tries to login to Great
Plains, he/she is prompted or rather forced to c...can add multiple analysis code in a single FRx Row format
Currently we can add several analysis code in FRx Row format by using several
rows (each row will contain only 1 analysis code - limitation of FRx with
MDA). The client has many analysis codes in each analysis group. What they
need is to add some of the analysis code in a single row; separating it into
several rows will add more work in designing the FRx report.
There should be a way for next releases of FRx to handle adding mulitple
analysis codes in a single row or column of the report.
...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.