Message "class not registered" opening sheet with macros Excel 97
I have created a document with Macros and is password protected. I have sent
it to several people who are able to use it - the one who can't is using
Excel 97 SP2. They are getting error message "class not registered" - could
it be the version they are using and how do I make sure they are able to use
This could simply be a version issue if you developed on a later version and
used controls from that versions object libraries. You should always use the
lowest version to develop on.
If this is not the case look in the VBE on the faulty machine and check
tools>ref...How do I prevent "Help" from opening when I open Excel?
Whenever I open Excel 2003 the Help feature opens on the right.
How do I pevent this? I only want Excel to open with a new sheet.
Help or TaskPane.
For Help, you should be able to close it using the "x" and next time open
Excel should not display.
If TaskPane, go to Tools>Options>View and uncheck "Startup Task Pane"
Gord Dibben Excel MVP
On Mon, 12 Dec 2005 13:05:29 -0800, "Lee P" <LeeP@discussions.microsoft.com>
>Whenever I open Excel 2003 the Help feature opens on the right.
>How do I pevent this? I only want Exce...Converting XLS file to QIF or to OFX
How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
> How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
In Excel, save the file to CSV and ustilise iCreateOFX Basic from:
to convert the saved CSV file to OFX.
...Doing Analysis from large amounts of DATA
I have an attachment that's apart of this message & within it I have 3
tabs 1) Revenue 2) Expenses & 3) Net Position. I would like to do some
Analysis on the above three thou a way where I can manipulate the Data.
How would I go about doing this? I've tried a Pivot Table thou it didn�t
work out in the sense that it was messy & just failed in calculating
stuff, not sure if I did it right thou.. Would really appreciate all
the help as I actually have about 20 of these sheets which from that
fall into 4 groups being 5 sheets per group. I hope this all makes
sense, wo...lost data when opening excel workbooks ; text import wizard popup
When opening many of my excel files ,which all have the same modification
date, I come across the text import wizard which states that my text in these
files is 'delimited'. All of the files ,including a few word doc.s have had
their data changed to show all " y " with two dots above the letter for as
far as the eye can see. No import or export has been done with the files and
no modifications were done on that date, as far as I know.
Is this a corruption problem or is their some 'fix' that I am overlooking.
Thanks for any ideas.
...conversion lotus 123 files to excel -- problem
I am converting lotus123 files to excel2002. One problem is that in lotus, literals are ignored when found in a cell within a formula. Excel on the other hand is not doing this and therefore causing #value errors on all the formulas where this occurs. Is there a way to handle this in excel other than manually having to change all the formulas?
...transfer inbox in table format to word
In my older version I could cut and paste the table
format in Outlook to a word file. Now I don't seem to be
able to do it although I can print the file in that
format within Outlook. When I export the inbox to word I
get the whole text not just the headings. Is it possible
to transfer the table format to a word file?
...cannot open outlook 2000
"this opration has been cancelled due to restrictions in
effect on this computer" I have already tried the steps
listed in MS Knowledge Base article 310049, with no luck.
Any other suggestions ?
...How do I add a hyperlink to an individual word in an Excel cell?
I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.
Any ideas? I can manage some VBA too if necessary.
You can't do that in Excel.
You would have to use HTML or Word or some other means.
You could fake it, the entire cell would be a link, but you could
after assigning the hyperlink select another...How do I get excel files to open automatically from directories?
When I try to open excel files from the directory or from desktop I only get
a blank worksheet not the file. I have to then go through File Open to get
the file I want.
There must be a way to have them open automatically.
On Mon, 2 Jan 2006 21:22:01 -0800, Damian
>When I try to open excel files from the directory or from desktop I only get
>a blank worksheet not the file. I have to then go through File Open to get
>the file I want.
>There must be a way to have them open automatically.
Go to Tools -> Options -> Gen...Not able to open imported accounts 4.0
We have a situation where we've updated a client from 3.0 to CRM 4.0 and have
an import that brings in new Accounts. Unfortunately, we can open accounts
that don't have a parent account but can't open the parent account itself. In
essence, we have two accounts with another one the parent - we can open ones
that show the parent, but again, we get an error - see yor administrator. Is
there a rights issue or relational setup we're missing.
...Unable to open Access 95 mdb in Access 97
I am trying to open an old Access 95 mdb in Access 97...I
didn't create it but someone who knew the database way
back when said that a system.mda file was created for
that particular database because it had a lot of personal
info in it.
(I am not familiar with mda files...the database folder
also had a system.ldb file there as well...I deleted that
file...but am unsure why it wasn't closed out to begin
I was able to open Access 97 and repair it...but when I
go to open it in Access 97...I get an Automation
Error...Cannot find VEENLR3.hlp file.
Do you think it may ha...Odd problem with worksheets when opening file
Okay, here's the odd problem that's come up.
When you double click on a excel file, excel opens up, but you can onl
see the toolbars. The grid area looks like a snapshot of whatever you
current background is before the file opened up. If you were showin
your desktop, after the excel file opened, you'd still see your deskto
in the datagrid area.
If you start up a new excel file, then do the File>Open>file name, th
file will open correctly.
This problem happens across users here. Everyone is currently runnin
Any ideas on what causes the problem and any...Outlook 2002 multiple file opening
In Outlook 2000, CTRL A would select all attached picture
files, then Open would, in my case, open the files in
With the 2002 version I cannot find a way to do this.
..."File: send to mail recipient" not working
When users (on WinXP) select file, "send to mail
recipient", no response from Outlook 2002. This occurs
either when Outlook is open or closed. Problem happens
when rt. clicking on .doc, .xls, .pdf's....all files.
...Locks up when clicking on links in open web pages
I don't know if I'm posting this in the correct discussion group, and if not,
sorry for the trouble. Could you direct me if I'm wrong?
The issue is that the internet connection locks up if I click on a link or
attempt to print from within an open website. It does not happen each time,
but often enough to make me want to pull my hair! I have to shut down the
connection - the message says it is 'not responding,' and reconnect,
sometimes 2 or 3 times, to be able to use the link from the website.
I have a second laptop, and it doesn't have this problem. ...audio notes in Word Notebook
I have recorded an audio file using Word Notebook. I would like to
send the audio file to co-workers but they cannot seem to open it. Any
Are your co-workers using Word 2004? Only Word 2004 can open documents in
Notebook Layout view and use the special features like audio, I think.
However, you could use Tools | Audio Notes | Export audio to get just the
audio file out, I think it comes out as an .mp4
Then send that around, it should be a standard format that most any audio
program can play, far as I know.
On 9/14/06 11:09 AM, "email@example.com" wrote:
> I h...When I open a workbook, another one called Book1 is also opened. W
This Book1 becomes the current book. If I go to Window on the toolbar I can
switch to my correct workbook. Why is this Book1 being opened? I can cure it
by closing Book1, then saving my correct workbook, then closing that one. The
next time I open my workbook, Book1 has disappeared.
Do you mean two different sheets within the same workbook?
> This Book1 becomes the current book. If I go to Window on the toolbar I can
> switch to my correct workbook. Why is this Book1 being opened? I can cure it
> by closing Book1, then saving my correct workbo...odd files created
Every time I open and edit an excel spreadsheet on a
network share, small odd files get created. They are
usually no larger than 25-40k and don't have any
extensions to them. Looking at the properties page for
any file, the file description says File. Anyone know
what this is from or how to get rid of them? Permissions
are setup correctly for me, Word files don't have this
Excel 2000 SP3
A file the same size as the workbook would be created
in the same directory as the workbook. The filename
would be nonsensical (or appear to be random) character...Excel Template Wizard, Very Large File Size
Background: Excel 2000. I created a spreadsheet and used
the template wizard that links to an Access 2000 database.
The template was later used to create one record and saved
as a spreadsheet. The database also contains this one
record. Spreadsheet and database work fine. Later I
reduced the Access field size properties (none are larger
than 150, most are less than 50). There are 35 fields.
Unexpected result: The Excel spreadsheet (template) and
the linked Access database are huge. The spreadsheet is
35MB and the associated Access 2000 database is 24MB. Each
contains one record (a si...Putting Excel Charts into a Word document that's getting too big
I am creating a Word document (our Annual Report) in which I will have many
charts and graphs that were created in Excel. Currently, there will be at
least 26 graphs/charts in the document.
In the past, there have apparently been problems with not having enough
space to save the Word document because it gets too big. The document itself
is only about 36 pages, but, as I mentioned, within the 36 pages are at least
26 graphs and charts. I'm looking for a way to copy the graphs/charts into
Excel without it taking so much memory.
One solution we thought of was to only paste the gra...Merge data from Acces to word
I have an Access db with records on a form which I want to
export to a Word Template with predifened fields.
How can I do that?
Take a look at Albert D. Kallal's Super Easy Word Merge at
Hope this helps,
> I have an Access db with records on a form which I want to
> export to a Word Template with predifened fields.
> How can I do that?
...Fast Campaign through eMail-Mass and Word / Wich Security-Role rights?
i hope i could explain it correct what my problem is.
One of our Sales/Marketing guys needs the Security-Role-Right to make
Fast-Campaigns through the Assistent and Word.
(We use the German version of CRM so i have no clue how these Menu's
named in English, so i do straight translate them as i think it
He right now goes through the Outlook CRM Client into the Marketing
Menu, then opens the Marketingslistings and selects a campaign and has
on the Top Menu Bar the Fast-Campaign-Button wich opens up the
Assistent. He then fills some forms, and comes to the point where he
co...Date & Time file was last saved
Is there away to display in a cell the date & time the file was last saved?
I know you can do this in word but is it possible in Excel 2002?
Here is an UDF
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
DocProps = CVErr(xlErrValue)
Now you can use the following formula in one of your cells:
=DocProps("Last save time")
Obviously, the file has to have been saved.
... looking out across Poole Harbour to ...Word v.X compatibility
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
What compatibility issues (if any) will we start to find as more and more people begin using Office/Word 2008 with .docx files? Is there any patch or update that will allow our Word v.X to read that format?
Been out of town for a while? :-) The OXML Converters have been available
for nearly 2 years. The most current revision is a free download from the
Mactopia web site at the bottom of this page: