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...Data Load Performance
Running SQL 2008 SP1
I am comparing a data load into a Heap Table and a Clustered Table. The
schema from each follows:
CREATE TABLE dbo.HeapTable(
HeapTable_UID int NOT NULL,
Col1 char(25) NOT NULL,
CREATE TABLE dbo.ClusteredTable(
ClusteredTable_UID int NOT NULL,
Col1 char(25) NOT NULL,
PRIMARY KEY CLUSTERED (ClusteredTable_UID, Col1) )
CREATE NONCLUSTER...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...Re: Where is My Clipboard Data!?! Work Around to Transfer 56 Pages of Data From Clipboard=?ISO-8859-1?B?ig==?=
Thank You! Thank you: Very, VERY Much!! I found the Clipboard Data Object
but it was Unreadable. I dragged the Microsoft Office v.X Folder to
Applications from it's CD, Launched Word v.X, Right Clicked on a Clipboard
Entry, Chose �Paste All� and Recovered 56 PAGES of Data!!!!!! Saved the
Document, Closed Everything, Trashed the Office v.X Folder & Restarted. You
Saved my A��, You Bet! Sea Mac
Work Around to Transfer 56 Pages of Data From Clipboard�
I dragged the Microsoft Office v.X Folder to Applications from it's CD,
Launched Word v.X, Right Clicked on a Clipboard Entry, Ch...Create Auto Text in Excel?
I want to be able to add the following function
",A1),1))) into any excel sheet that I'm working on like you can do in Word
with Auto Text insert.
I think I should be able to do this with a macro but I can't figure out how
to do it.
Any help much appreciated.
First, you can shorten the formula a bit and reduce the number of
function calls by using
XL doesn&...Make excel 2003 default to open files
I have Excel 2003 running alongside 2007.
Double clicking an excel file causes it to open in 2007; how do I force 2003
to open the files instead?
You most likely have to reset your file association from 2007 to 2003.
Close Excel first and On the Windows Taskbar
1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
You might have to designate a full path to excel.exe for Office 2003
In that case Start>Run "C:\your path to\office11\excel.exe" ...scrambled excel file
Hi AGAIN. I'm trying to open a file that was deleted and later retrieved
through GetData Back. It has an .xls extension, but when I try to open
it, it's just symbols. Is there some way I can retrieve the proper
info. from that file? Do I have to save it as something else? I really
need this file back - l mean life & death!!
I will attach the file to see if someone can figure this out for me.
Thanks again for your help. Your advice last time was great.
Attachment filename: wolf_info liz.xls
Download attachment: http://www.excelforum.com/attachment.ph...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?
...Excel 2008 and analysis toolpack
I've just upgraded from Office X (macintosh) to Office 2008, and notice
that the Analysis Toolpack doesn't seem to be available for Excel
anymore. Can anyone confirm this? Or, if it is available, how do I
find the Add-In? I must say that 90% of the reason I use Excel is for
the data analysis tools that it provides, and will be very unhappy if MS
has decided not to support these tools for the Macintosh.
"I hold it to be the inalienable right of anybody to go to hell in his
<will be very unhappy if MS has de...How can I manipulate an excel chart by clicking and verify the ta
in excel 2003 we click on a point and after appearing an arrow we could
change its position to manipulate it. Meanwhile the table is corrected
automatically. In excel 2007 it is impossible. Do you please help me?
This feature has been removed in xl2007.
As yet I am not aware of anybody creating a addin to replace this feature.
Andy Pope, Microsoft MVP - Excel
"Danesh" <Danesh@discussions.microsoft.com> wrote in message
> in excel 2003 we click on a point and after ...data entry on form
i have a form that is linked to a table. all i do is enter data from the
form. i converted the database from 2000 to 2003 because i want to use with
runtime. for some reason the form doesnt open up in data entry mode. i can
scroll through records etc but the * is not available to use to create a new
record. it worked no problem before now its not. everything is checked for
the properties for data entry. when i use the database with runtime, the
total form is blank. thats another story. does anyone have any ideas what
On Tue, 8 May 2007 19:38:37 -0400, &...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.
...Compiled Excel macros
I think about selling my own Excel wordbook, that contains some macros. But
I don't want anyone to see these macros.
I tried to set password on VBA project, but it's insecure. There are
programs to crack this password.
I know, that Access has *.mde files, which contain macros in a compiled
Does Excel have a similar functionality?
Are there any other hints to prevent users from seeing the macros?
Thanks in advance!
You can create COM addins or DLLs that are written in VB and can be
compiled, but not in VBA. Problem here of course is that you need a full
version o...Import txt file into excel with 281,344 rows
Hi, I've got a very large txt file that I need to import into excel. It has
288,344 rows. Is there a way I can do this? The fields on my txt file are
separated by a pipe "|"
Thanks in advance.
If you're using xl2007, then that data will fit.
Open the .txt file and choose delimited by |
If you're using xl2003 and below, you could use your favorite text editor to
make several smaller .txt files (65536 rows or smaller) and import each into
> Hi, I've got a very large txt file that I need to impo...Cell Data Change to Trigger Macro
Is there a way to trigger a macro whenever data changes in a cell? The
value in the cell will be varying numbers, so it can't be TRUE/FALSE etc.
Yes. Put it in the sheet module, instead of a regular module. It should
look like this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
MsgBox "You changed cell A1, you did."
If Not Intersect(Target, Range("A1").EntireColumn) Is Nothing Then
MsgBox "You changed something in column A. You sure did."
End ...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...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...MDA to AA data migration
Has anyone successfully migrated MDA data to AA? We want to implement AA but
are waiting for AA support from a 3rd party (AIT from mc2). We are
considering implementing MDA for the short-term, then migrating to AA once
it's supported by AIT.
Currently working on a tool to do so, if you are interested in talking about
it please contact me.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"Mike Muscarella" wrote:
> Has anyone successfully migrated MDA data to AA? We want to implement AA but
> are waiting fo...How do i stop data projection on graphs
Please tell us more. Use this white space for your question
Microsoft Excel MVP
"Randy" <Randy@discussions.microsoft.com> wrote in message
...copy some data to next sheet
My sheets are named 1,2,3....100
at any time i may be located at any sheet.
I wish to copy selected values to the same position from sheet "m" to the
next "n" sheets where n is not going to run past 100. The from and to
positions are concrete and the same. If you want colour they are mens
wedding suit items and party name.
Maybe you want this (there is no error check in this example if you are in sheet 100)
Dim myarea As Range
For Each myarea In Selection.Areas
.Copy Destination:=.Parent.Next.Range(.Address)...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 <email@example.com> 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 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...EXCEL 2000 & EXCEL XP Compatability
We were just given an EXCEL file created in XP and now the end user customer
wants it in EXCEL 2000.
Are there any known issues regarding these two versions working together. We
know there are many problems with Word and PowerPoint 2000 & XP working
Please help !!!!!!!
...Graphing daily data
I am trying to graph daily data for a month in Excel 2007 that groups like
days (Saturdays, Sundays, etc) in the same series, while still showing
individual values and dates. Any ideas on how to accomplish this?
Use your worksheet to pull the relevant data together into a series. Do the
data manipulation in your worksheet, then the chart plots the series which
you have generated in the worksheet.
"Fozzie" <Fozzie@discussions.microsoft.com> wrote in message
>I am trying to graph daily data f...