Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Job Application Manager Update [Gold & Silver] (Patreon)

Published:
2022-01-31 12:15:59
Edited:
2022-02-01 04:32:11
Imported:
2026-06

Videos

Downloads

Content

Hello Members!

In this week’s Feature, Fix or Focus, we take last week’s Job Application Manager training, and in this update, I added a feature called 'Job Documents' which is suggested by Miguel.

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Make sure to view the brand new and updated training and download the updated workbook in the attachments below.

As always, great to have you here, and thanks so much for your support.

Files

Job_Application_Manager_Updated

This is "Job_Application_Manager_Updated" by Randy Austin on Vimeo, the home for high quality videos and the people who love them.

Comments

Robert Burton

Awesome addition! Thank you very much! Just one note... In the JobDocs_PrevDoc sub. there is an Exit Sub command after turning off ScreenUpdating. Just a Heads UP! Probably shouldn't ever hit that since the File path should be there already.

Excel For Freelancers

Thanks so much for catching that Robert. I have modified the code and updated with a GoTo statement. Thanks again.

ian h

Hello Randy it seems i can't display PDF files?? it only show a icon and filename. Word files i can open with preview but not with pdf With word i get =EMBED("PDF";"") With pdf i get =EMBED("Packager Shell-object";"") Any solution please? Thanks

Excel For Freelancers

Hi Ian, when displaying nearly any type of an object in Excel (Excel, PDF, Word) this line of code should work, as long as the file path is correct .OLEObjects.Add(FileName:=FilePath, Link:=False, DisplayAsIcon:=False).Name = "DocPrev" Make sure DisplayAsIcon is False as this will display the entire document preview and not just as an icon. I hope this helps and thanks so much.

ian h

Hi Randy, Yeah i known, but didn't work It still shows icon with filename Even with a word file it works fine But not with a pdf Do i need a reference or something for this to work Because i have no clue why it won't work :(

Excel For Freelancers

HI Ian can you post your code, screenshots and detailed issue in our Excel For Freelancers Facebook group http://bit.ly/groupexcel This way our community can take a look at it, since I am not sure as well.

ian h

Hi Randy, Yeah it may sound weird... but i don't have an facebook account. So i guess it stops there then. I use your code under Sub Jobs_ShowDocPreview The only thing i do= adding a filename under the sheet JobDB But still not working with pdf Photo screenshot please see Url https://photos.app.goo.gl/xHwZ9Le8v5t7q3fb7

Excel For Freelancers

Hi Ian thanks i am not sure what is causing this as it could also be related to your machine.

ian h

Hi Randy, Weird because i have multi computers :) And same results

Excel For Freelancers

Yeah i see so you may consider joining the Facebook group and posting your issues. Someone else may have had similar issues. for now that is the only resource we have for support. Thanks for your understanding.