Importing a Lotus file with a *.123 extension
My company uses Excel 97 and 2000 and we've received a
Lotus file with a *.123 extension. Excel will not allow me
to open it as it does not have the *.wk? format. I
searched the web and while I found numerous people with
the same problem I found no one who had the conversion
answer. Any help would be greatly appreciated. Thanks
Find someone with Lotus ver 9 or higher. Have them open the file, and save it
If you dont have Lotus available and want you can send it to me and I will do it
"jim" <email@example.com> wrote in message
I put Navigation bars on my publisher website document. When I try to publish
to a file or to the web, the Navigation Bars do not appear on the page(s).
How do I resolve this??
Answer found in the web group.
"Tom Snyder" <Tom Snyder@discussions.microsoft.com> wrote in message
>I put Navigation bars on my publisher website document. When I try to
> to a file or to the web, the Navigation Bars do not appear on the page(s).
> How do I resolve this??
Tony, did you get an answer to this...Auto fill and drop down lists
The fields are Rank and Rank Sort (I cant do this alpabetically as a the
ranks (Military) don't run in alphabetical order.
The idea is this:
The form (Pers Details Form) contains personal details Name, Number etc from
the Pers Details Table. There will be box where I can select the rank from a
dropdown list. The Rank details are contained in a seperate table (Rank
Table) containing a Rank and Rank Sort column. In the Pers Details Form I
can create a record, enter details but I want to have a drop down box to
choose the rank from. Once chosen I would like the rank to show (but ...Problem to open excel file
Hi to all,
I have a problem with all excel file. The user can't
open all excel file when she did a double click on it.
She has this error message :
"cannot find the file 'c:\documents and
settings\desktop\......test.xls' (or one of its
components). Make sure the path and filename are correct.
And that all required libraries are available"
Do you know what can I do to solve the issue??
Your Excel file association may be lost.
Start>Run "excel.exe /regserver"(no quotes and note the space before the /
You may have to en...Excel is creating temp files Help!!!
Hi i have to files in excel, i cant figure it out, whenever i open th
files, they create temp files into the same location, when i shut dow
the program the temp files are left there.
Is their a way to make it so temp files are not saved.
Or is their a way to make it so that the creation of temp files i
greenfalcon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1362
View this thread: http://www.excelforum.com/showthread.php?threadid=26182
What do th...How do I Restore old save dbx files back into OE store folder
I have some old dbx files that I saved into a folder in 'My documents' some
time ago during earlier OE back ups. I now wish to re-import some of these
saved dbx folders back into OE in order to assess some of these emails
again. I've been looking at the wed sites 'Inside OE' and 'OE help'. But
can't seem find or see the part that will give me directions on how to do
Some of these saved dbx folders have the same names of existing folders that
I'm currently using in OE. So presumably, I'm going to have to do some
folder renaming or s...How Do I Copy My Outlook Files To My New Computer?
I exported my Outlook files from my old computer and burned them to a
CD. During the export process, it asked me three times for a password.
When I tried to import these files to my new computer I got "File
access is denied. You do not have the permission required to access
the file." Can anyone help?
Apart from the fact that Import/Export options often lead to corruption -
you should use a simple pst copy -
The pst needs to be on the hd and the read only flag off, before In OL
attempting to open it. NB not import
<firstname.lastname@example.org> wrote in message
news:1145746658.84...viewing LN emails (.nsf files) saved to CD in outlook?
I have lotus notes messages saved on CD, these are saved
as .nsf files. Is there any way I can view these in
have tried various LN websites - to no avail.
...How to view the code for excel built-in functions?
Is it possible? -For example the function PMT().
No, the code is compiled, so it would likely be less than useful anyway.
About the best you can do is check out the equations used in Help (see
In article <OSU3OXOBGHA.1676@TK2MSFTNGP09.phx.gbl>, "serdar" <email@example.com>
> Is it possible? -For example the function PMT().
...Using XP Briefcase with money file
I put a copy of my money file into the laptop briefcase
and I am able to keep them in sych for a while. For some
reason I get locked out, the computer knows the file has
been updated but it will not let the desk top file update
the laptop file, I get the following message;
"The source file can not be opened"
"Check to see if the other program has the file opened,
and close the file before updating the briefcase."
Other files update just fine. When I get this message, I
can't even drag a new copy of the Money file to my
briefcase, I have to rename the file an...Help with automating file name
I have the following code that exports the below query to excell. I would
like the files name to include the month and date. How would I format this?
DoCmd.OutputTo acOutputQuery, "qryShopOrderSqFtShippedSummaryExport",_
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
> I would
> like the files name to include the month and date.
Uh, . . . the date _always_ includes the month, unless you're r...Windows XP: Open file in read-only: Word, Excel, Visio
I'm often sharing files on a network drive with someone. Often, one
of us knows that we don't need to open a file for modification, and we
only need read-access. Is there a way to open a file in read-only
mode so that when someone does need to open it for modification, the
read-only user is not blocking that?
If there is not a way to do this native to Windows XP, is there a way
to do it from the three applications that we use most, namely Word,
Excel, Visio? All are 2003 versions.
I used to save files like this in "read only recommended" mode.
File|SaveAs|Tools|Ge...Newbie Cell Reference Question...
I apologize if this question has been answered before, but I'm no
quite sure what to search for as I'm not very good with excel.
I'm making a spreadsheet where one sheet references another. I'll tr
to explain this as best as possible....
I'm creating a spreadsheet for a fantasy basketball league. I have
"Data" sheet that contains data for all players. I have another sheet
"Teams" that has all the players on each team. Column B contains th
players name, and column C contains a number that corresponds to th
row this player is on in the dat...outlook adreddbook file
I want to export the addressbook flie into database to be
uses in a quiry. is it possible and how do i do it?
Outlook has no separate "address book file."
Contact data is stored in your Contacts Folder Use the Export Wizard to
export it to the format that best suits your needs.
"Helpneeded" <firstname.lastname@example.org> wrote in message
> I want to export the addressbook flie into database to be
> uses in a quiry. is it possible and how do i do it?
...Contact file not visible when importing or exporting contacts
I'm tidying up all my contacts files for email and also for my mobile ph
using outlook. Have done this many times without any problems and am familiar
with import export process.
I exported all the contacts to an excel file to work on as it's much easier
than through outlook. Had a hiccup at first as when I got to the select a
contact file to export there was just a blank space. I exited outlook and
went back in and it was all OK.
Now I've finished the excel spreadhsheet and want to reimport it but it's
the same problem in reverse. I can't "see" a co...How to remove the /dde from Windows Explorer File Open on Install
I have an MDI app that I would like to open a file on a double click in
Windows Explorer. Unfortunately the Explorer File Type (Tools>Folder
Options... File Types tab) is set so that the command invokes dde. Ie. The
"open" option under the "Advanced" button is C:\Path...\App.exe /dde and the
DDE message is [open("%1")].
This never seems to work as my app never sees the dde message and the
initialization of m_pCmdInfo via:
m_pCmdInfo = (CCommandLineInfo*)(UINT_PTR)m_nCmdShow;
sets the pointer to one and the app fails on exit. This is referred as a
kn...Force command to run for each computer in txt file list of compute
I have a few hundred computers that haven't been defragged in years. I was
wondering if rather than doing it manually, if someone had a script where if
i just put all the computer names in a txt file, it would iterate through the
list and perform a "defrag c: -f" on them all from my workstation. The
workstations all have the same local administrator password, so the process
would be the same for each. I just dont know how to write scripts.
I know if i were going to do this manually from my computer I would run the
command below for each ComputerName
psexec ...Fill bar
I need to paste the following range: into consecutive cells:
=a1,=a4,=a7, =a10 down to about =a1230. When I use the fill handle
after about 3 cells, Excel doesn't seem to understand that I want the
cell reference sequence to increment by 3 each time. Is there a way to
make that happen?
Drag copy down as needed.
<email@example.com> wrote in message
>I need to paste the following range: into consecutive cells:
> =a1,=a4,=a7, =a10 down to about =a1230. When I...Publisher 2003 files try to open in Publisher 97 #2
Back again, but with a different Pub 2003/Pub97 issue
Have Office 2003 with Publisher 2003 and Publisher 97 both on my XP Pro system
Recently I find that files created in Pub 2003 are being saved as files with
the Pub 97 Logo, and when you try to open them from the file listing, they
open Pub 97, which correctly posts a box telling me that it cant open the
If I use Publisher 2003 to open the same files from within the application
the work fine.
When I select a 2003 Pub file which contains the Pub 97 icon, the file list
does not contain Publisher 2003, but when I browse and locat...Open excel file
I want to open excel file using a commnad button placed in a form. I have
read the other questions to this to use runapplication. But, what I am
looking for is as follows:
i have tax database which contain the taxpayer name, taxyear and the Taxid
number. I have placed this table in a form. The tax caluclations are made in
excel and stored in a particular folder say named, Tax_comp and with
filenames Taxpayer_year.xlsx. I want to place a command button on the form,
and when the user clicks the command button, i want the particular tax payer
excel tax computation file sto...File folder info. in Excel workbook?
Good day all. Excel 2007. XP Pro.
Is there a way to have all available excel files in a particular folder
listed (updated in real time) in an excel spreadsheet where the user can
click on one or more of them to open those files or at least retrieve
specific data from them?
I have a situation where files representing cost centres and each month of
the year need to present data into a worksheet used for reporting purposes.
So potentially 5 x 12 = 60 files. But these are only created as the months
pass. so at the end of month1 there would only be the 5 files, month 2 there
would be...Publisher cannot save file???
I am working on a brochure in Publisher. I have tried to save and received
the message "Publisher cannot save file". Any direction or help would be
No other wording?
MVP Microsoft [Publisher]
"Carrie" <Carrie@discussions.microsoft.com> wrote in message
>I am working on a brochure in Publisher. I have tried to save and received
> the message "Publisher cannot save file". Any direction or help would be
> greatly appreciated.
>...Using Rept function
I want to repeat one cells entry somewhere else in my (same) worksheet and have used the Rept function successfully. However, ifthe 1st cell (e.g. A3 is in date format like 12/12/2003, when I use the Rept A3,1 function in another cell (e.g.cell R3), it returns the date as a number (37967). What I want is for the date to be repeated exactly as is (12/12/2003 or whatever date is typed).
Can anyone help please
Don't use the REPT function. Just enter =A3 and apply the date format you
want using Format, Cells if you do not automatically get it.
You can't unless ...Forecast Function #2
How can I use the forecast function on columns that are not adjacent to each
other, or alternately, is there another function I can use for this.
Otherwise, I have to type in the whole regression line equation thusly,
I'm forecasting 2003 data from 1998,2001, and 2002 data.
...Exchange Attachment file blocking
My company is in the middle of converting from Groupwise to
Outlook/Exchange. In an article I found it says that you can maintain the
list of attachment file types that will be blocked by Outlook in Microsoft
Exchange Server. Does anyone know how/where to do this maintenance and what
version of Exchange you need to be using? I have not been able to find the
file type maintenance screen/form.
Works in Exchange 2000 and 2003. You create a security template for users and
specify setups. Implement via registry key or AD policy. Here's a beginning
web link (be sure to read all the ou...