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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|