A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Compile error: Can't find project or library



 
 
Thread Tools Display Modes
  #11  
Old August 18th, 2009, 06:40 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Compile error: Can't find project or library

I thought you said you got rid of the comile error by checking a missing
reference?


Gord

On Tue, 18 Aug 2009 10:27:01 -0700, Melanie
wrote:

i tried both and they still don't work with the same compile error.
i'm pretty sure it has something to do with the workbook... there are no
typos in my code.
unfortunately i can't send this workbook as it's work-confidential.
oooh well... thanks anyway.


  #12  
Old August 18th, 2009, 06:47 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Compile error: Can't find project or library

That I don't understand.

If no typos, Format(Now, "yyyy-mm-dd hh:mm:ss") should work properly.

You do get the logtest.txt file created and the appending of Username works
each time you open the workbook?

Something we're missing but I can't put my finger on it.

Maybe someone else can see the fault?


Gord



On Tue, 18 Aug 2009 10:30:01 -0700, Melanie
wrote:

I should add that if I delete the Format command, it works (but no date)


  #13  
Old August 18th, 2009, 08:03 PM posted to microsoft.public.excel.newusers
melanie
external usenet poster
 
Posts: 156
Default Compile error: Can't find project or library

maybe the Excel workbook is down rev?
even though the Visual Basic for Applications is checked off in the
'References' section, for some reason maybe it isn't there??
i don't know... it's strange because the code works in my other workbooks.
just not this one.
  #14  
Old August 18th, 2009, 09:30 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Compile error: Can't find project or library

Which version of Excel are you running?

Make a copy of the workbook.

Delete the sheets with sensitive information.

Save the new workbook in any version and send to me.

gorddibbATshawDOTca


Gord

On Tue, 18 Aug 2009 12:03:01 -0700, Melanie
wrote:

maybe the Excel workbook is down rev?
even though the Visual Basic for Applications is checked off in the
'References' section, for some reason maybe it isn't there??
i don't know... it's strange because the code works in my other workbooks.
just not this one.


  #15  
Old August 21st, 2009, 02:54 AM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Compile error: Can't find project or library

For the edification of anyone who was follwing this thread..............

Melanie sent me the workbook.....scaled down.

The problem with the Format statement was that she had a module with some
macros.

One of them was Sub Format()

Excel barfed on this until I changed the name to Format22

All is well.


Gord

On Tue, 18 Aug 2009 10:47:57 -0700, Gord Dibben gorddibbATshawDOTca wrote:

That I don't understand.

If no typos, Format(Now, "yyyy-mm-dd hh:mm:ss") should work properly.

You do get the logtest.txt file created and the appending of Username works
each time you open the workbook?

Something we're missing but I can't put my finger on it.

Maybe someone else can see the fault?


Gord



On Tue, 18 Aug 2009 10:30:01 -0700, Melanie
wrote:

I should add that if I delete the Format command, it works (but no date)


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.