98Views5Replies

Author Options:

PLEASE HELP! Visual Basic in excel programming help!? Answered

I need help to program in VB in excel i want to make a program that when i put a memory stick (like one in a camera) it automatically recognizes it sorts between photo and video puts the videos and pictures into separate folders onto a WDMybooklive (personal cloud 2 terabyte) and then deletes the files on the memory card all automatically and with visual basic in excel. Thank You!

Discussions

None
mpilchfamily

Best Answer 6 years ago

Can't be done. The VB in excel doesn't have that kind of power. You would need a full version of VB to create an app like that. Look around for an existing app that can do what you need. I'm sue you can find a free one.

None
Xixfasmpilchfamily

Answer 6 years ago

I've searched and searched and searched but i can 't find one.

None
mpilchfamilyXixfas

Answer 6 years ago

Most software tools for cameras do what your looking for. Often times the tool treats the camera like a card reader. I suspect these images and videos are coming from a camera correct? Then find the software tool for your camera. At the very least it will allow you to pull all the files off the card while it's in the camera then delete them from the cards. The files may end up in the same file on your drive but that's easy enough to sort out. You could probably come up with a simple .bat script that could sort the files from there.

None
pianoman99ampilchfamily

Answer 6 years ago

If this is true, then why not try to find an automator of some sort, or use c#, c++, or vb?