Reading .wks file
Greetings...according to the Excel "help" file, as well as the file extension listing, I *should* be able to read an *.wks file, but Excel insists that it cannot. I am pretty sure the file was created in Microsoft Works. Is there a converter somewhere that I can download/install? Cheers - S2
Excel can read Works 2.0, not later. You have to save them in Works as excel
files or Works 2.0 or get a commercial
"Skip Stocks" <firstname.lastname@example.org> wrote in message
news:AFC110E0-641D-4D87-9464-B930CC41CF02@microsoft....Import data from Access to Excel containing VB code
I am trying to import data from an Access database to an Excel
spreadsheet. I have imported several queries from Access into Excel
already. However the last piece of data that I am wanting to import
into Excel has VB code in the query doing a calculation automatically.
So when I go to Excel to import that piece of data, those queries that
contain the VB code don't even show up as import-able. Is there a way
to import these queries from access into my excel worksheet? I am
using Access 2003 and running on an XP OS. Is it possible to do it in
Excel 2007 if not available in Excel 2003?
I...Dialup user access to exchange server
We have a Exchange 2003 server which is accessed by corporate user in
exchange mode (RPC) in the LAN. Some of these users need to access the server
remotely by dialup to the corporate RAS server using the smart client (MS
Outlook 2003 - Exchnage mode). There is a Firewall sit in between the RAS and
the exchange server. RAS is in a DMZ network and the Exchange is in the
trusted network. What are the ports required to be open between the RAS and
the Exchange server in order to access the exchange server in a secure manner.
In news:11F7B6FB-E518-4211-8085-920FED4C712D@micros...Why do Excel and Access freeze on the splash page?
I have just installed Office Pro 2003, removing all previous versions, and I
can load Word, but not Excel, Access or Powerpoint. I have tried running
virus software (up to date McAfee), re-installing and re-booting but nothing
is working. I had the same problem in Office 2000 as well with Excel. Help
please. Thanks, Chris.
...Suppressing DTD look-up via web access when loading XmlDocument
In one of our test suites we load an xml document (it's actually .svg).
I'm trying to find some way of stopping the eventual call to
HttpWebRequest.GetResponse which I presume it's doing when going to get
the DTD at "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd".
The result is a time-out because this machine is isolated from the
database, the web, everything really :-)
I tried to pass XmlDocument a non-validating reader e.g. XmlTextReader
but the web request was still attempted. I also set its XmlResolver to
null but to no avail.
Would anyone be able to ...File won't open as read only
I have a file that is in use, but another person opens it
and it doeasn't display the "file is in use" message. Is
there a setting or fix?
have you shared this file?
> I have a file that is in use, but another person opens it
> and it doeasn't display the "file is in use" message. Is
> there a setting or fix?
The file is on a network share. The share has all the
>have you shared this file?
>Frank Ka..."File access denied" to PST file
I have gone from Windows 2000 running Outlook 2000 to Windows XP Pro running
Outlook 2003. When I try opening my saved .pst file in the new Outlook I get a message
saying "File access denied. You do not have permission required to access to file
mailbox.pst" I am logged on as Administrator, as I was on the old install. How do I open
my saved mailbox.pst or archive.pst? TIA
How did you try opening it? is this a local .pst file? If it is not on
your C: drive, is it marked Read-Only?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion int...How to give other users read-only access to Calendar
I want to allow the group Everyone to have read-only access to a calendar in
a certain mailbox. I can do this by granting the permission 'Full mailbox
access' (under 'Mailbox rights', under 'Exchange Advanced', for the
particular user). However this also allows people to to do everything (ie:
they become read-write users).
I notice that every mailbox in the system has 'Read permissions' granted to
group Everyone. This does not allow other people to open items in the
mailbox, but as I understand it, permits Exchange Server and Outlook to do
shared meetin...Move system attendant mailbox <email@example.com>
The solution is here http://www.mcse.ms/archive/index.php/t-828566.html
EggHeadCafe.com - .NET Developer Portal of Choice
...Can't Convert Access 97 MDE File
I have an application that we have been unable to get to
work on Access 2000. I have created an MDE file and used
office developer tools to create a run time file for a
machine with Access 2000 on it.
I get the "You can't convert or enable an MDE file" when I
go to run it.
I know there is something you can change in the Office
Developers Setup Wizard to get this to work, but I forgot
what it was. Does anyone know.
Thank You in Advance
No, you can't convert an MDE.
You have to use Access 97 with the 97 MDE,
and A2K MDE with Access 2000.
"Ton...Read mail arn't marked as read anymore
After an SP upgrade of my Office 2000 the priviewed mail
doesnt get marked as read anymore. I have tried to change
the time (Tools->Options->Priview pane) from 2 -> 3 -> 4
seconds but nothing works. The only way to mark a mail as
read is either to open it or right click it and chose
Mark as read. Since I only use the priview pane this is
very anoying for me.
Is this a bug or has some setting changed with the SP?
...CRM Web Synchronization / Remote Access
A couple of quick questions. We have just implemented CRM into our
organization. I have setup access via a http://crm.company.com so the
crm is accessible from the web. Is this the right thing to do? Is
there anyway to restrict the users who are allowed to use the external
version of crm? Should the crm client point to http://crm.company.com
Thanks everyone in advance.
1. If you are putting Microsoft CRM on the web as part of
your user requirements, you should *REALLY* look into
securing it since anyone (outside your LAN) can intercept
your...excel file can not be accessed
When opening an excel file I get an error that
reads " 'Excel File Name.xls' cannot be accessed. The
file may be read-only, or you may be trying to access a
read-only location. Or, the server the document is stored
on may not be responding."
The file is not read-only. The other files in the same
location are readable. The document is stored on a local
Any suggestions on how to read the file?
Thanks for your time.
Could this be it?
(from Debra Dalgleish's site)
> When op...Assiging Tasks via the POP mailboxes under Outlook 2002 & 2003
We've been trying to assign Tasks to each other (2 people)
via POP Mailboxes.
The assigning seems fine, but when a TRask is assigned
back and forward several times we both end up with
multiple Tasks... the most recently Accepted one, plus
ealier versions which remain as "Waiting Response from
What are we missing?
ps. I did read in these discussions that we both need to
have RTF format selected which we both do have.
...Accessing data from Excel spreadsheet
Does anyone know if there is a relatively easy way to read fields in an
Excel spreadsheet from VC++?
You can always save the data in .csv form and read it in after parsing.
Another more elegant approach would be to use automation and use
excel's object model to access the data. Here is good starting point
Stephanie Doherty wrote:
> Hello World,
> Does anyone know if there is a relatively easy way to read fields in an
> Excel spreadsheet from VC++?
> S...reading confirmation
I have a problem with outlook. When they send a message to me that demands
the shipment of a reading confirmation, even if I accept, the reading
confirmation does not come received from the sender. Someone knows from what
depends and in which way I can resolve the problem?
Thanks for the eventual answers.
Niki <firstname.lastname@example.org> typed:
> Good day,
> I have a problem with outlook. When they send a message to me that
> demands the shipment of a reading confirmation, even if I accept, the
> read...Accessing an email account programmatically
We have Exchange 2K (moving soon to 2003) that serves all our users - about
1500. I need to access a particular email account programmatically for one
of my applications so that I can get emails and respond based on certain biz
logic. Understandably the Excahnge admin is hesistant in letting me do
What options do I have to be able to access one or more email accounts
programmatically and what if any are risks associated with each of those
methods. Any pointers to whitepapers discussing these would also be helpful.
I can't provide you wi...Access 2003 and Access 2007 on same workstation
Sorry, this has probably been asked a thousand times.
Can I install Access 2007 on a machine with Access 2003 and keep both
versions. I used to do this with Access 2000 and 2003. Since I am a
developer, I need to test and develope with the customers version.
Yes you can. However, be aware that there's currently a problem so that
whenever you switch from one version to the other, it'll take several
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Marcus Smaby" <email@example.com> wrote in message
news:%23..."Unblock" feature should be optional when reading e-mail in CRM
When viewing e-mail messages in CRM, a line appears saying "Unblock" to allow
the full message content to be read. Can this be made a configurable server
or security setting? We are trying to reduce "clicks" as much as possible.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agre...The memory could not be "read".
I'm at work yesterday afternoon responding to e-mail on my desktop, and
Adobe pops up from the toolbar with a notice that there is an update
available for Acrobat. I accept the download, keep plugging away at my
e-mail, and install it when it's done. It runs through the install,
tells me that I should restart, but I ignore it and keep working. It's
near the end of the day and I'm going to be going home soon anyways. I
forgot to turn it off when I left. Came in this morning, restarted it
through the Start menu, and rebooted. Upon reaching the "Ctrl+Alt+Del"
...Restricting access to Export to Excel functionality.
I am aware that the answer is likely to be 'no', but is anybody aware
of a way in which I can disable the Export to Excel functionality on
the various screens (accounts, contacts, etc.) - either on a user by
user basis or globally.
A customer of mine believes this functionality makes it too easy for a
user to do a complete dump of the central CRM data to Excel.
(Obviously we have given them access to the data and we want them to
be able to view it, but we do not want them to easily be able to do a
Any help appreciated.
Senior Consu...Outlook Web Access automatically closeing its connection to your mailbox after a period of inactivity.
Does anyone know or Is there any way to increase the time of Outlook Web
Access automatically closeing its connection to your mailbox after a period
...Outlook Web Access #34
currently running Exchange Server 2003 with SP2, just wonder whether using a
Nokia E61 can access the
Outlook web access?
Music Lover wrote:
> currently running Exchange Server 2003 with SP2, just wonder whether using a
> Nokia E61 can access the
> Outlook web access?
Use activesync/direct push for this, it will sync the mailbox to the
cell phone software is built in.
...how can i copy a document to a CD without making it read only?
HOW CAN I COPY A DOCUMENT TO A CD WITHOUT MAKING IN READ ONLY?
You can't. It is not the file, but the media, that is read only. Even CD-RW
media does not allow editing a file on the CD. Copy te file from CD to HD,
mak edits and if a CD-RW you should be able to burn the edited file back to
> HOW CAN I COPY A DOCUMENT TO A CD WITHOUT MAKING IN READ ONLY?
...Accessing the call stack in an Excel VBA macro?
There is a control which lists the call stack members when you are in the
VBA programming environment. I need to access this from within a VBA macro
at run time. Does anybody have a clue how to do this?
According to Ken Getz in the VBA Developer's Handbook...
"VBA doesn't provide any method for retrieving this information"
You would have to write your own code to keep track of calls/releases.
Portland, Oregon USA
(compare stuff, find stuff, remove stuff: http://tinyurl.com/XLCompanion)
"Mike Suman" <mcsuman@eptsystems...