Help with learning to automate task at internship

Career Advice

I'm currently working on a project where I have an excel sheet of assembly numbers and I need to check if we have CAD files that correspond to that assembly number in our company server and then add yes, no, or maybe next to the assembly number in the excel document. This seems like something that could be automated rather than doing all manually, but I have no idea how I'd even get started trying to do that or even where to start to research if it's possible. Any advice on this would be greatly appreciated.

Posted Jun 6, 2023, 6:30 PM UTC

96
xHawk13•

Move your CAD file #s on your company server to an excel document and then you can use vlookup or write a pretty easy script to automatically look for matches.

Also, chat GPT is pretty good at stuff like this if you can ask it the right questions.

7
PinkishplaysOP•

Thanks for pointing me in the right direction.

1
Thotexperimenter•

DO NOT INPUT COMPANY DOCUMENTS OR ANY PRIVILIGED INFORMATION INTO
CHAT-GPT.

5
xHawk13•

Yeah definitely don’t do that. I just meant asking GPT how to do things in excel.

2
NDHoosierIvy Tech -> FIU - EE•

If you're willing to learn VBA (Visual Basic for Applications), you can automate this entirely in Excel. VBA has a library to search and manipulate the filesystem, and can parse file names (there is a library available to perform regular expression searches if you want).

2
JohnD_s•

The capabilities of VBA are insane. Completely underrated skill to have.

2