Problem with time sheet
I have taken over an excel sheet from my predecessor and he created it in windows03 but we are now running in 2010. When I press the save button it comes up with "could not load an object because it is not available on this machine" then I press "ok" then it comes up with "compile error, can't find project or library".
Next the screen coems up (picture attached). I feel I am very close for this to work but I can't figure it out.
Please help, thank you
| Attachment | Size |
|---|---|
| E-Time Sheet.xls | 319 KB |
»
- pleger's blog
- Login or register to post comments
- 2870 reads
in VBA, have a look under
in VBA, have a look under Tools=> References
see if there are any missing references.
- then look for the missing ones or uncheck the reference, and remove the code that uses it.
GetSaveAsFileName will perform the same thing as this code