| Works 8 - text replacement formula ? Posted: 20 Jul 2005 07:45 PM PDT Hi Charlie,
When you type an account number into a cell in a preadsheet, that
number remains, although you may reformat the displayed appearance.
However, you could link the contents of another cell to that cell and
based on the contents (account number) of the second cell could then
LOOKUP the corresponding company name from a Lookup Table.
For instance say in cell A2 you put the account number 21
If, in cells F2:F10, you had company account numbers (ascending order)
and in cells G2:G10 you had the corresponding company name, then
the range F2:G10 is the Lookup Table.
In B2 you could have the formula = VLOOKUP(A2,F2:G10,1) to
have the corresponding company name for cell A2 appear in cell B2
HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
"Charlie" <microsoft.com> wrote in message
news:com...
|I am having a terrible time finding out how to have my spreadsheet replace
| (account) numbers with their corresponding company names. What I am trying
to
| achieve is when I enter an account number in a box I would like it to
| auto-replace that number with the correct account name when I enter out to
| the next box. Is this even possible ???
|
| MSWord Macros Posted: 20 Jul 2005 05:35 AM PDT Thanks Mike
Eddie Thrashcort
|
| I have 50 MB of Works docs I need to read without having Works Posted: 19 Jul 2005 02:12 PM PDT On Wed, 20 Jul 2005 10:13:31 +0100, "Kevin James - MSMVP Works"
<org> wrote:
Much thanks, I'll give it a shot.
|
| quarterly popup - ad in works suite 2005 Posted: 19 Jul 2005 11:05 AM PDT The Key I posted Does control the AD. I changed the date in one of the
values in the key to today's date and the AD popped up when I launched
Works. If you purchased for example PictureIt and Works separately then
that may explain why you would have two keys.
If you do not want to mess with the registry then you would need to call
tech support for assistance
http://support.microsoft.com/selectindex/default.aspx?target=assistance#W
Select your version of works to get the help contact info
--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com/p1152b/
Life would be easier if we could view the source code
"Robert" <microsoft.com> wrote in message
news:com...
|
| Versions of Works Posted: 19 Jul 2005 02:08 AM PDT Thanks Kevin, this helped me.
regards,
Prashanth
"Kevin James - MSMVP Works" wrote:
|
| Works Suite 2002 with XP SP2 Posted: 17 Jul 2005 10:33 AM PDT Only if you want a newer version
--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com/p1152b/
Life would be easier if we could view the source code
"Robert Sharon" <net> wrote in message
news:ibBCe.7319$ops.worldnet.att.net...
|
| Formatting problem in Works 8.0 spreadsheet Posted: 16 Jul 2005 08:05 PM PDT Thanks, Kevin.
The " symbol does NOT appear before the "number" in the formula/entry
bar when I click on the cell so I'm not sure what's going on. In any
case, I uninstalled and reinstalled again but his time I reinstalled
from the MS WorksSuite DVD and not from the Application and Driver
Recovery program furnished by Gateway. This worked and now everything is
fine ... numbers align right as they should.
Nick
Kevin James - MSMVP Works wrote:
|
| works 4.5a and works 8 Posted: 16 Jul 2005 07:51 AM PDT Thank you David
"DavidF" wrote:
|
| Problem with decimals uqual zero Posted: 15 Jul 2005 06:06 AM PDT
Thanks for suggestion, I tried and successed :-)
Inondagrigio
"Kevin James - MSMVP Works" <org> ha scritto nel messaggio
news:phx.gbl...
|
| why read only Posted: 14 Jul 2005 09:35 AM PDT thank to you both i think i am sorted now
"Michael Santovec" wrote:
|
| form letters Posted: 12 Jul 2005 08:13 PM PDT Hi John,
I believe that the feature you require i.e. Insert>Field, is not
available within Works.
However, you may wish to experiment with Works Autocorrect
that acts like WORD's Autotext feature.
HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
"john" <microsoft.com> wrote in message
news:com...
| the form letter is not so big a problem as the form fields without using the
| mail merge or database; how?
|
| "Jim Macklin" wrote:
|
| > Write you letters, each is saved as a template with a
| > different name.
| >
| >
| > --
| > The people think the Constitution protects their rights;
| > But government sees it as an obstacle to be overcome.
| > some support
| > http://www.usdoj.gov/olc/secondamendment2.htm
| >
| >
| >
| > "john" <microsoft.com> wrote in message
| > news:com...
| > | need to know how to create form letters in works word
| > processor without a
| > | mail merge or database
| >
| >
| >
|
| Works Suite 2000 Compatibility with XP Posted: 07 Jul 2005 05:18 PM PDT i have the works 2000 and it works just fine on my XP
"Win 98 User" wrote:
|
| How to open a MS Word 6.0 document in MS Works 8? Posted: 07 Jul 2005 04:21 PM PDT I'm surprised the Word 6 converter wasn't included with your Works 8. This article says
it should be:
File formats that are supported in Works 7/8 & Suite 2003/04/05
http://support.microsoft.com/?kbid=884182
It specifically lists Works 7.0 in the body of the article, but the heading says it should
also apply to Works 8.0.
You might try Control Panel, Add/Remove Programs and select Microsoft Works, then the
CHANGE option. Perhaps when it was originally installed, all the text converters weren't
installed.
--
Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
"Billy" <net> wrote in message
news:com...
|
| Word Processor & Internet Explorer Posted: 07 Jul 2005 01:39 AM PDT Yes, you can leave Internet Explorer intact but just use another browser (like Mozilla Firefox). "Jim Macklin" <p51mustang[threeX12]@xxxhotmail.calm> wrote in message news:phx.gbl... |
| Works calendar does not work Posted: 06 Jul 2005 12:55 PM PDT Hi Sam S,
Appears your problem is not associated with mswkscal.wcd.
My next suggestion is to reinstall Works. I also suggest you use the
clean-up utility before reinstalling. Typical instructions can be found
at...
http://support.gateway.com/s/SOFTWARE/MICROSOF/sHARED/7513181faq24.shtml
Ken
"Sam S." <microsoft.com> wrote in message
news:com...
I tried the procedure. Of course it wiped out all my data as expected, but
also did not sold my problem, which is that I can't add any new
appointments.
"Ken" wrote:
a
If
Calendar
this
|
| Spreadsheet; Decimals Posted: 06 Jul 2005 08:59 AM PDT Highlight your spreadsheet column and go to "Format" --> "Numbers". Select
"Number" in the format type window, then set the number of decimal places
you want.
"Nathanoj" <microsoft.com> wrote in message
news:com...
|
| files missing Posted: 03 Jul 2005 06:23 AM PDT Hi Mike,
Did you previously removed Microsoft Office 2003 or Microsoft Office Trial
2003 from the computer?
If not, perhaps try using Works CleanUp utility, then reinstall.
Typical Works CleanUp Utility info...
http://support.gateway.com/s/SOFTWARE/MICROSOF/sHARED/7513181faq24.shtml
Ken
"Mike and Mary Normile" <net> wrote in message
news:com...
the file missing is a dll file - LTDIS13n.dll
"Ken" <ne> wrote in message
news:%23%phx.gbl...
|
| Need help - How to delete installed Office 2003and install Office 97 Posted: 02 Jul 2005 05:39 PM PDT Hi arouth,
This may help explain why the product key is required.
http://www.microsoft.com/office/editions/prodinfo/activation.mspx
If you re-run Setup for Office 2003 , it *should* present you with
an option to uninstall it.
File associations can be changed, so that files are opened by the
program/application of your own choosing?
http://support.microsoft.com/default.aspx?scid=kb;en-us;307859&product=winxp
HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
<umsmed.edu> wrote in message
news:googlegroups.com...
| Greetings! I have Works 8.0 in stalled in my laptop. When I want to
| open documents created by Office 97, I get message - "The command can
| not be performed because a dailog box is open. Click OK and then close
| open dialog boxes to continue."
| When I press OK, then Office Standard Edition 2003 opens and the
| program wants me to fill up user name, initials and organisation name
| and fill up the 25 character product key.
|
| I do not want to use Windows 2003. I want to use Office 97. How do I
| delete Office 2003? With thanks.
|
|
| Sending attachments? Posted: 02 Jul 2005 03:53 PM PDT Most word processors can read the RTF format. That includes Microsoft Word as well the as
the free WordPad accessory included with all versions of Windows.
By the way, I tried the link that Kevin sent you and it works for me.
--
Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
<com> wrote in message
news:googlegroups.com...
|
| Works 8 & 4.5a Posted: 02 Jul 2005 01:26 PM PDT Thank you Kevin for the quick response. Have a great 4th.
"Kevin James - MSMVP Works" wrote:
|
| Microsoft Works 7 calendar Backup. Posted: 01 Jul 2005 11:33 AM PDT Hi Paul,
Perhaps this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;892614
HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
"pauly007usa" <microsoft.com> wrote in message
news:com...
| Does anybody know what file I back up to save my entries in Works Calendar ?
| Any help appreciated.
|
| Microsoft Works V7 & V8 Posted: 30 Jun 2005 01:17 PM PDT Confirmed, Michael, he was using a shortcut from WksWP.exe which launches
the word processor, by-passing Task Launcher.
Many thanks to all who replied.
Regards
Joe
"J&P" <com> wrote in message
news:phx.gbl...
|
| Works 8 word processor won't print in landscape Posted: 29 Jun 2005 08:51 AM PDT Check out this Canon support page
http://consumer.usa.canon.com/ir/controller?act=SupportDetailAct&fcategoryid=232&mo delid=9209
--
The people think the Constitution protects their rights;
But government sees it as an obstacle to be overcome.
some support
http://www.usdoj.gov/olc/secondamendment2.htm
"Sandy" <microsoft.com> wrote in message
news:com...
| Hi Jim!
| The printer is a Canon i350 and the latest printer drivers
were passed on to
| me from Microsoft Support... as I say that didn't work!
But thanks for
| coming back to me anyway.
|
| Sandy
|
| "Jim Macklin" wrote:
|
| > What make / model of printer? Is there an up-dated
software
| > package available from the printer maker?
| >
| >
| > --
| > The people think the Constitution protects their rights;
| > But government sees it as an obstacle to be overcome.
| > some support
| > http://www.usdoj.gov/olc/secondamendment2.htm
| >
| >
| >
| > "Sandy" <microsoft.com> wrote in
message
| >
news:com...
| > | Recently upgraded to Works 8 from v6 and now it won't
| > print in landscape.
| > | Spreadsheet etc. no problem. Under warranty I've had
| > Microsoft look into it
| > | and gave me updated printer drivers and various
| > adjustments & settings to
| > | Works but to no avail... they even send me a
replacement
| > disc but still the
| > | same! They seem to have given up on me now since I
said I
| > was working around
| > | the problem by saving docs as a *.doc and using
WordPad to
| > then print out in
| > | landscape, but it's a bit of a performance especially
when
| > it comes to
| > | envelopes!
| > |
| > | I can't see why it should be so different to Works 6
but
| > it is irritating!
| > | Anybody out there with any thoughts??
| > |
| > | Thanks for any replies... cheers!
| > |
| > | Sandy
| >
| >
| >
|
| Wks 6 Database report: won't save Posted: 28 Jun 2005 05:18 PM PDT The fix:
http://support.microsoft.com/support/kb/articles/Q136/3/20.asp
The Cause:
In List View, changing All font sizes in one go will affect the report
widths.
(done by picking on top left square, or wiping ALL fields)
If you want to change all the fonts en mass in List view without
affecting the the Report Column widths
you can do it by selecting all but one field, then change font size.
Then select the remaining field and change that. If you have hidden
fields (i.e. width is zero) then you can select (wipe) ALL the visible
fields and change just those.
Incidentally if you select ALL cells in Report Edit view (top left square)
and change font size,
that will also affect the column widths.
To summarize; if you don't do any selection en mass
when changing font sizes the report columns remain rock solid.
Eric.
Ron Kitchenn wrote:
|
| printing with hp 1320 Posted: 27 Jun 2005 09:55 PM PDT Yes, printer was installed with disk and set as default.
"Jim Macklin" wrote:
|
