I have 2 folders. Folder 1 contains thousands of jpeg images of our parts. The images are saved under the part number for that part.
I want to search this folder for a specific image. if it exists, i want to copy the image and save it in another folder (folder #2) under a different name.
Hence in my worksheet I have 2 columns. In column 1 i have the name of the part number i want to use to search folder 1. if the jpeg image is found, i want to copy the image and save it in folder # 2 under the name found in column 2. If i find multiple images of this part, i want to copy them multiple times with a -pic1, -pic2, etc.
Please help - i am very new to VBA and the answer to my problem would greatly appreciated.
1  2176  NeoPa 32,570
Recognized Expert Moderator MVP
I think we need to get some things sorted from the start Scott : - We don't do the work for you. The best we can do is offer pointers at this stage.
- More help may be forthcoming if/when you show the work you've done on this yourself.
- Your explanation is fairly reasonable, but does leave the question as to how there can be multiple items in a single folder with the same name. Probably a misunderstandin g of course, but as you've explained it that doesn't make good sense.
- Where do Folder 1 & Folder 2 come from? That info is missing from the question.
Basically, you need to process through the rows in your spreadsheet, but it's always better to work to a clear spec. Starting prematurely on a sort of spec is never a good approach.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Eliezer Figueroa |
last post by:
Managing Multiple Excel incoming files?
I have this situation. I have a client which have several locations they
work primary with excel forms and they are thinking in doing reports with
them. What they want is to import those Excel files into SQL Server for
later using crystal reports or maybe asp.net for reporting. Those files
will come every week from diferent locations then go to SQL Server and then
they should be stored in a folder...
|
by: IdeaMan |
last post by:
Windows 2000
Access 97
I am working on an issue tracking DB, where I need to link (not attach
due to size)screen prints of various system errors.
I have created a public folder on a network drive to store these
images, under the assumption that no one will originally save them to
that location. To resolve this, I need to copy the file to this
location without possibility of user error in selecting the correct
folder (the DB is to be...
|
by: Green |
last post by:
Hi,
I had a question about how to copy files from server to server on the
same LAN. Basically, i need to copy files from
"develope server" to the "test server", then eventually to the "production
server". But i don't know how to deal with
this. Do you have any example code or hint?
I appreciate in advance!
|
by: Chris Strobel |
last post by:
I have 2 web servers where I need to write a PDF file and need to keep them
in sync. In others words, If the Server1 is getting called to create the
PDF, then it needs to copy the PDF to the other Server2 and visa-versa. The
2 server are running 2003.
It's a form-based authentication (.NET 1.1) site and I'm using IIS 6 native
mode. Both boxes are set to the same workgroup. Since everything is so
locked down now, I'm not sure what's the...
|
by: Muskito |
last post by:
Hi,
Is it possible to copy the entire List(Of type) object to another
List(Of type) object
(they are both of the same type ofcourse) - without keeping the
reference?
There's the CopyTo method, but it only copies the data to a flat array.
I Need this for Backup in my program, when i update the master list and
| | |
by: MarkusR |
last post by:
Good day,
I need to safely copy files from one directory to another. I need to
make sure that I do not lock the file making it unreadable by others.
I am not sure if this is the default behavior if I just used
File.Copy...
The files are relatively small.
|
by: dkmarni |
last post by:
Hi,
I am trying to do this perl script, but not able to complete it successfully.
Here is the description what the script has to do..
Accept two and only two command line arguments. Again, these will be the names of two directories. This time, make sure that the "sending" directory exists (and is, indeed, a directory). Make sure that the "receiving" directory exists, and if not, create it. Then, copy files from the sending directory to...
|
by: =?Utf-8?B?U2Vhbk1hYw==?= |
last post by:
How do I programmatically copy files across a network (from a local
workstation to another local workstation on the network) using visual basic
2005?
In other words, when in explorer and you enter a unc path to a network
workstation, you are prompted with a dialog box asking for the user name and
password that has access rights to that computer. After validating, you can
access the files on the remote pc just like you can on your own pc,...
|
by: dmorand |
last post by:
I have a database table that contains some file names and there come times when I have to copy these files to another location to have them be re-processed by a windows service.
Is there a query I can run to copy the files? I'm finding myself running a query to find all the files I need to copy, and then manually copying the files. I was hoping my query could do this for me.
|
by: parmarjm |
last post by:
Hi I am trying to copy files from mapped drive (J:\) to a different machine.
The perl script is going to run on my machine to copy files from one place to another.
File transfer works when i copy files from mapped drive to my machine but when I tried to copy over to different machine throws me an error:
Please help me recrify
Here is my perl script as follows:
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
