Project Detail

Files from Excel Macro

Files from Excel Macro is project number 332326
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: excelvbacoder

Budget: $30-250

Created: 10/21/2008 at 15:01 EDT

Bid Count: 15

Average Bid:
$ 87

10/31/2008 at 15:01 EDT

Project Creator: blakilox
Employer Rating: 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 (4 reviews)

Description

I would like 2 small Excel Macros written

First Macro Exports each cell in a spreadsheet to a tree of small text files where column A2,A3,A4... through AX represents the directory name

Row B1,C1,D1...through X1 represents the file name

The resultant output will look like

Subdirectory1
File1.txt File2.txt File3.txt... FileX.txt

Subdirectory2
File1.txt File2.txt File3.txt... FileX.txt

Subdirectory3
File1.txt File2.txt File3.txt... FileX.txt
.
.
.
SubdirectoryX
File1.txt File2.txt File3.txt... FileX.txt

up to at least possible 1000 directorys and 20 possible text files with the XY range controllable in the macro

If a Cell is empty but falls within the macros XY range
it creates a empty file within the specified subdirectory

The second macro does the reverse of the above however, it imports the cells back into the spread sheet by reading each small text file contained in a like tree of directories/files where similar to the above the directorys are specified in column A2 through Ax, and the filenames are specified in row B1 through X1

Each Cell(/Text file) would probably never need to exceed 110 chars
Cell A1 would simply be blank or ignored
In macro 1 during the export to files it would be cool if the directory names are created if none exists however no prob if I would need to first create the corresponding directory names with a simple mkdir batch script.

Report Violation

Job Type

Excel

See more: create, directory, excel, excel macro, export, file, macro, macros, reverse, similar, simple, small, spreadsheet, text, text file

Messages Posted:2

If you are the project creator or one of the bidders Log In for more options

PMB

3 days

10-21-2008 18:33 EDT

9.9767/10
(43 reviews)

Hi, i m the best VBA expert. i would deliver fast efficient code..

johnsinit

1 day

10-21-2008 18:26 EDT

9.8205/10
(39 reviews)

Dear 4ustralia! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB.

hiratariq

3 days

10-21-2008 15:36 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(18 reviews)

Please see PM

CDspace

1 day

10-21-2008 19:26 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(7 reviews)

Please Check PM

JackBradford

1 day

10-21-2008 18:57 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(6 reviews)

Hello, Please see your PMB for details.

ioanaprof

3 days

10-21-2008 16:26 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(4 reviews)

Hi, Can be done. Thank you, Ioan

agusgfl

100

5 days

10-21-2008 22:34 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Thank you Dear Sir, I am willing to do this project. it will be done and give you a good result. Thanks & Regards

divamL

3 days

10-22-2008 05:58 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

I'll do it!

excelvbacoder

3 days

10-21-2008 18:18 EDT

(No Feedback Yet)

Hello there, I have worked a lot with Excel VBA in the IT Department of the company I work in to automate repetitive processes and retrieve and pass data to and from databases. Looking at the project description I believe I can create, test and document the code for these two macros. Found this freelance site tonight when browsing internet and signed up to bid for my first freelance project ever. Don't have any ratings so looking to get started here. I won't let you down. Your sincerely Michael

excelexpertz

250

1 day

10-21-2008 18:14 EDT

(No Feedback Yet)

plz view sample macroz

Christbalinet

3 days

10-21-2008 18:32 EDT

(No Feedback Yet)

Hi see my Pm

sumiwati

3 days

10-21-2008 22:00 EDT

(No Feedback Yet)

Ok... SIr I will do this project TQ :)

bizsoft14

240

5 days

10-22-2008 00:55 EDT

(No Feedback Yet)

Respected Sir, First i want to introduce my company Business Softwares, a IT company deals in all related feild, we have a different setup for every department. After seeing your project details, we think that it is not a difficult job for us, you can get result of your choice from us. If you have any querry please dont hesitate to ask, we are just a PM ahead. Regards, Team Bizsoft14

zoxno6

1 day

10-22-2008 02:17 EDT

(No Feedback Yet)

I'm ExcelVBA expert.See PM please.

bolek

1 day

10-22-2008 07:34 EDT

(No Feedback Yet)

Consider it done. Fast delivery. Quality moacros only. Let me know whether you're interested. Thanks

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.