I have tried a few different snippets of code, but I keep getting the NAME? error. All I want to do is display the last modified date in an excel cell using a user defined function. Below is the most recent snippet of code I am trying. Thanks.
Please Login or Register to view this content.
Are you sure you spelled it correctly and put it in a module in the right sheet?
Works fine for me.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
where did you put the code? into your personal workbook?
if so then
=PERSONAL.XLSB!lastmodified()
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Look at this code and see if it serves your purpose
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Yes it's in my Personal Workbook. I have attached a picture of the module and the cell formula.Last Modified Cell.pngLast Modified VBA.png
And I tried using =PERSONAL.XLSB!lastmodified() but get an error message saying PERSONAL.XLSB can't be found.
Have you tried my code? Looked at it? ignored it?
Hello alanisdman. I tried pasting your code into a module but didn't see the function ListAllFiles() show up. Is your code creating a user defined function?
seems Mac names the file differently
essentially you need to put whatever the filename is for your personal macro list
try this instead
Formula:
Please Login or Register to view this content.
I didn't realize that you were using a MAC. My code does not create a function. It is a straight VBA code.
='Personal macro workbook'!lastmodified()
This code worked for me. Thank you everyone for your assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks