Compile Error: Can't Find Project or Library
I have a spreadsheet containing 7 userforms and 9 modules. The
spreadsheet has been developed on the same computer for a number of
years and remained stable. However, I now want to make some amendments
to one of the userforms. Whenever I make any changes to the
UserForm_Initialize statement (even entering a blank space), I get the
compile error 'can't find project or library'.
Does anyone know why this happens and, more importantly, how to stop it.
...Order form Template
Does anyone know where I can get a standard order form
...Can a set up a production chart in excel, there may be over run s.
I would like to set up a production chart in Excel, what formulas do I enter?
The jobs could over run so this will alter the daily production sheets. I
want to be able to alter one job run and then it will rearrange the following
jobs. Can this be done and if so how do I do it? I am running mms office
excel 2003. I hope some one out there can solve my problem, I do hope its
possible too. I work for a printing company with no production sysytem at
all!! What I would like to do is to set up a daily, weekly and monthly
production sheet for jobs to be worked on. We have three departm...find numbers that total to a target, need examples
Does anyone have a list of numbers for which they need to find a set
that adds to a certain value? I am working on some code and would like
some real world examples to feed it.
For example, say I have the following list of numbers:
I want to find the combination of numbers that add to $76,395.94.
Does anyone have any lists they could post for me to test the code
with? Long or short lists will work, and real world examples are
preferable. Thanks...Goran Thisell here ... May we connect?
Goran Thisell here, how are you?
I am putting together a contact list of individuals
interested in sharing resources and business
information. If you are interested in connecting
please send your Name and information to:
I will follow up as soon as I get your email. It's
not an autoresponder so it might not be right away.
I appreciate your patience.
I look forward to meeting you.
MAF Anti-Spam ID: 20040306105317O0d3ZyV4
...Cannot Insert nor copy & Paste Word 2007 document into Pub. 2007
I have never been able to insert a Word document into Publisher. Always get
the "Not enough memory to convert to text formatting. Windows is low on
memory." Have been using COPY & PASTE. Today, even that doesn't work. COPY
& PASTE only pastes a blank text box. HELP! I have a newsletter to get out.
Create a text box in Publisher, right-click the box, click change text, Click
text file, browse to the Word document. Publisher will automatically create over
flow text boxes and pages.
"zoey621" <zoey621@discuss...Find Missing Records
I searched enough on this topic but couldn't find anything that i could
put to use. Hence this query to you all.
I have two excel sheets.
Both Sheets have two columns (Name, Email Address)
Now i need to find out if there is any record(row) missing in the first
sheet by checking the second sheet, such that i can create a third
sheet with all the missing records(rows).
Any help or macros that you guys have used earlier, would be of great
help to me.
Try using a Vlookup on the second sheet using the first sheet as the table.
Then filter all the #N/A and copy to the...Finding Friday
I'm using the formula below to find Saturday's date within the same week of
any date entered in A1.
The formula works fine, but I now want to find Friday's date within the same
week of any date in A1.
I understand how the date in A1 (as a serial number) has 5 added to it and
the result is then rounded down to the nearest multiple of 7.
Does this type of formula only work for Saturday, or is there a similar
formula that will find Friday's date instead.
Otherwise, I guess I'll enter: =(FLOOR(A1+5,7)-1)
-Please remove 'safetycat...Finding icons
I'm trying to find the icons I've customized. I had
believed those icons were saved in a file
called "Excel.XLB". However, and I can't find it when I
do a search. Any help how I do this or what to backup?
When you are conducting search for your "Excel.XLB" file make sure you have
checked the Advanced Option "Search hidden files & folders"...
> I'm trying to find the icons I've customized. I had
> believed those icons were saved in a file
> called "Excel.XLB". However, an...How many templates can there be in 1 Publication?
Am trying to use two different templates on two different pages in one
publication file. When I select a different template, from page one, to
apply to page two page one also changes to the new selection. Is this even
possible with Publisher 2003?
Open two instances of Publisher, copy the objects on template two, insert a page in
template one and paste.
Mary Sauer MSFT MVP
"Ann" <Ann@discussions.microsoft.com> wrote in message
...how do I make the template bigger
I am sending my dad an E-mail with an attachment
...KB890830 (May 2010) Fails to install
Todays patches (8 Jun 2010) included an update for KB890830 which will not
install on any of my servers. I have Windows Server 2000, 2003, 2003 x64,
2008, 2008 x64 and 2008 R2 and in each case the system downloads the file and
runs it but never installs it and WSUS reports the servers as requiring this
update. I can leave the systems reporting this required patch but at this
time I can not install it and as it is required by my workstations (and
appears to be installing correctly on them) I can not hide it / decline it.
Perhaps tяy the WSUS Newsgroup
<http://social.techne...find a date in a raw
hi from italy,
i have i raw like this
a1 a2 a3
74 Bill 18/06/2005
100 12/06/2005 example
13/07/2005 Tom doc
how have in cells a4 the date of the raw ??
so i want
the function Max do it !
...Finding, Comparing, Opening a folder with Explorer
i have need of a little help. i have looked at a few resources on the
internet regarding making lists of files and folders and either returning
them to a table or listbox, as well as doing other things with the returned
data. i even had a coworker jog my brain as to how i would open explorer to
where i want it. thats all great.
my problem is that i am unsure where to beging or what functions to use to
do what i would like to create.
here is the scenario. i have a table with products, each product has a
serial number which correspond to part of the name a folder on a drive where ...Word Crashing after updates
My office application was running great when I thought I would do a
bit of housekeeping and update the software from the Mactopia website.
Unfortunately i should have had my head examined instead as I should
have guessed that linking to Microsoft would screw up my system.
I down loaded all updates and did as the easy install suggested as I
am not a computer expert and now all applications work except word.
This is a bit disappointing as the software in the UK costs close on
Anybody know how to fix this and please bear in mind I am not a techy.
G...Italicize one word in a report label
In a report label eg "The first dog" I want to italicize the word 'first'.
Can this be done? Thanks.
What's a "report label"? (I'm just not sure you and I are referring to the
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability...formulas when there may/may not be a value
What formula do you use when there may not be a value there? Like:
ITEM QTY SOLD
T0887 50 1
T0887 200 2
T0992 50 3
# of sold items for each item?
(remove nothere from the email address if mailing direct)
"NTaylor" <NTaylor@discussions.microsoft.com> wrote in message
> What formula do you use when there may not be a value there? Like:
> ITEM QTY SOLD
> T0887 50...Outlook Find does not find any items for current date
If I do a standard/advanced basic find with anything in
the subject field, it cannot find anything for the current
date. If I specify the current date, it will return an
empty find. What am I missing?
...The wizard cannot find clipart needed for this design
Im MANY designs, Publisher 2003 cannot find the clip art.
I installed as an upgrade from Office XP. I have also
uninstalled Office XP and run a clean install of Office
2003 Pro. I have cleared the cache in IE6. I have checked
the Knowledge Base. Nothing solves the problem. Any ideas?
Are you online at the time? You must be with 2003.
MVP Microsoft [Publisher]
"tomsan" <firstname.lastname@example.org> wrote in message
> Im MANY designs, Publisher 2003 cannot find the clip art.
> I installed as a...No more new fonts may be applied in this workbook??
I Created a spreadsheet with over 200 Worksheets inside and I wrote a macro
that basically formats each worksheet after I'm done put all the info that I
need (text, number, and graphs) I'm like half way through and I an error
telling me "No More New Fonts May Be Applied in this Workbook" is there a way
to ignore this message cause it's cause my macro to stop and debug...
Message posted via OfficeKB.com
Bernard V Liengme
remove caps f...The application Microsoft Word quit unexpectedly
Operating System: Mac OS X 10.5 (Leopard)
I installed Microsoft works earlier today and have just completed two updates. However, after moving word and excel around the tool bar, and now trying to open them I receive the following message;
The application Microsoft word quit unexpectedly. Mac OS X and other applications are not affected. Click relaunch to launch application again.
Click report to see more details or send a report to apple.
I have sent a report to apple and here are the details of the report:
Process: Microsoft Word 
Path: /Users/poppy...Finding an SMTP Address in Exchnage Server 2003
I have recently migrated from Exchange 5.5 to Exchange 2003 and from Windows
NT 4.0 Server to Windows 2003 and Active Directory.
Prior to the migration I had a mailbox in Exchange 5.5 that was not attached
to a "Primary Windows Account" This was a shared mailbox and permissions were
assigned to various users.
This mailbox seems to have disappeared in Exchange 2003. I suspect as it was
not logged into while we had an SRS Server during migration.
However it's SMTP email address still exists and I now need to use it again.
IS there anyway I can search Exchange so that i...Finding age from year
I have a SS that has a column for YOB (year of birth) and would like
to generate a column with which to chart age distributions. What's the
best functions to find AGE from YOB and current date?
Since all you have is the year of birth, I think I'd use:
But it might not be accurate depending on the date and month of their birth.
If you ever get the actual date of birth, you could use =datedif().
Chip Pearson has lots of instructions at:
> I have a SS that has a column for Y...This may help you (Developpers)
I dunno if this is too old, or has beed mentioned before,
but i just found out that:
If you are developping in Dynamics.DIC, and introduce new
SQL tables along with Dexterity tables, DO NOT use 3rd
party for those tables' series name.
If you do, "release table <Table_Name>" , "get table
<Table_Name>" , "remove table <Table_Name>" , "change
table <Table_Name>" , and "save table <Table_Name>" will
go search for the table Table_Name in master/or Dynamics
DB, and will return with an error.
...Change the Normal Template
How do I change the normal template? I want to make
global changes to my Excel Workbooks. I would like to
change the default margins, and I assume that change needs
to be made to the global template. Please explain how to
Open a new workbook, format as desired, and save as a template file named
Book.xlt in the XLStart directory.
"Cindi" <DBM@awol.com> wrote in message
> How do I change the normal template? I want to make
> global changes to my Excel Workbooks. ...