Find Jobs
Hire Freelancers

Need an Excel script to copy files

$10-30 AUD

Terminado
Publicado hace alrededor de 5 años

$10-30 AUD

Pagado a la entrega
I need a script written for Windows 10 to copy a bunch of files to different folders. I have a USB music sampler (hardware device) which has a folder structure to which I can copy samples for playback. It's a pain to manually copy a large number of the files to the device, so a macro run out of Excel on windows 10 would do the job and save me a fair bit of time. See the .rar download for an example output file which will help make sense of what i need. The sampler folder structure is 99 phrases and each phrase has 3 sample slots, totaling 297 folders as follows: 001_1 001_2 001_3 002_1 002_2 002_3 003_1 003_2 003_3 and so on, up to 099_1 099_2 099_3 The script is to create a master folder called "WAVE" and inside this folder will be the 297 subfolders with the correct files copied in to each respective folder. The script needs to be able to allow for blank slots and folders, so if there is no filename in the source filename column for some rows, a copy will not be performed for that row, leaving that folder empty. The sampler must have the entire structure, including empty folders. The script would prompt me for a for a source folder where my source samples are. Samples are stereo 16bit 44.1k .wav files. It would then list the filenames in Column 2 in an Xl spreadsheet along side Column 3 (destination folder names). Column 3 has the folder names which will never change. If i'm happy with the default order of the filenames (alphabetical), i then press a COPY on the page which will start the process off copying the files from the source to the chosen destination folders respectively. If not happy, i can first copy and paste the filenames around to suit what i need, then press the COPY button. When complete, i will then copy the "WAVE" folder manually over onto my device. See the attached Demo file which has how i need the xl file to look. I need to have the color scheme created of the header row AND the alternate phrase block. This will help me see the individual songs more easily with alternate colors. I'd like the 2 buttons at the top. I'd also like to not have the path of the file listed as it will look messy. Many thanks! Rexx Fernandez, Sunrise Beach, Australia
ID del proyecto: 18636440

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
$30 AUD en 1 día
4,8 (103 comentarios)
5,7
5,7
12 freelancers están ofertando un promedio de $28 AUD por este trabajo
Avatar del usuario
Hello Sir im excel VBA macro and formula Expert :) i can create macro for copy your all file from a folder to another folder like u need please pin me now and im able to start working today Thank you Galih :)
$50 AUD en 0 día
4,9 (368 comentarios)
7,2
7,2
Avatar del usuario
I have excellent command on MS Excel and can write the code to copy over all the files as per your requirements. Please also share the demo file mentioned in the description for further understanding. I have completed complex projects in Excel before . For instance - Built a POS and inventory management system - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$80 AUD en 1 día
4,9 (103 comentarios)
6,1
6,1
Avatar del usuario
Hi, as you described in your project description that you need an excel expert. Microsoft excel is my top skill. I am software engineer basically. I know how to use tools. I can build Logic expertly. I can complete this task within given time span. Hope to hear from you. Consider me once.
$15 AUD en 1 día
4,8 (16 comentarios)
3,6
3,6
Avatar del usuario
Hi, I have more than 10 years of experience in Day-Job role and Freelancing. Please ping me for a chat to decide to how to achieve it in the expected time and budget. Regards, Param
$25 AUD en 1 día
5,0 (3 comentarios)
2,1
2,1
Avatar del usuario
Dear Hiring Manager, Thank you for posting your job opening for Data Entry. I have five years of data entry experience and I have performed all of the duties listed in your job description. I have excellent typing speed and data entry skills which make me a good fit for the data entry position mentioned in job description. I also have experienced in working with Microsoft tools e.g. Excel, Word and PowerPoint. I can assure you that I can perform data entry tasks with high accuracy while maintaining the 100% quality. I can be available for the job at least 30 hrs/week. I assure you to deliver : - Desired job/document with high accuracy - Document will be Error Free You can reach me out to discuss job requirement on my email or Skype. I will be available for any further review and modification in document after submission on desired document.k question here.. Typing speed : 60 wpm Delivery of the document : [mentioned date here based on the job nature] Please feel free to ask any question you may have. Thanks and Regards, Manoj G.
$15 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Trust for us we Able to do this task and we can give you a living example before we start working with us the Company Professional in:excel
$11 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello I will do data entry work Relevant Skills and Experience Data entry
$10 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can do this work sir please provide me this work
$25 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Plz sir hire me ireally need this project Relevant Skills and Experience Copy typing Excel Data entry
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi Rexx Fernandez, I will provide you Excel file with required macros as per your budget. Best Regards, Amit
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
ELSTERNWICK, Australia
5,0
4
Forma de pago verificada
Miembro desde oct 16, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.