Em Andamento

Excel Macro Help/Modification

I have an excel Macro that works but has two small issues that I am unable to figure out how to resolve.

What the Macro Currently Does:

The macro will open files in a certain directory (hard coded) - format them to the correct specification (for example, turn all | into sections).

The macro will then save the file as file_2 and save as a CSV.


1. The macro will only run if there is a blank excel document open. For example, if there is 5 files in the run folder, I must have 5 open excel documents. It will not open a new doc, format, save, close, and open another one.

2. When saving the _2, it is placing it in the wrong spot. For example, the original file is called [url removed, login to view], it is saving as File.csv_2 instead of File_2.csv.

Habilidades: Engenharia, Gestão de projetos, Instalação de Script, Shell Script, Arquitetura de software, Teste de Software

Ver mais: what is specification document, what is a specification document, how excel works, excel specification, excel macro how to, doc specification, what is macro in excel, save to excel, macro script file, excel macro csv, coded management, script open excel file save csv, project macro, document modification, excel management, excel macro open file, excel macro save, macro excel 2010, macro excel format, doc excel, excel macro modification, turn excel, macro script excel file, macro format, help document

Acerca do Empregador:
( 68 comentários ) Old Bridge, United States

ID do Projeto: #2995981

Premiar a:


See private message.

$38.25 USD em 1 dia
(137 Avaliações)

5 freelancers estão ofertando em média $42 para este trabalho


See private message.

$63.75 USD em 1 dia
(282 Comentários)

See private message.

$49.3 USD em 1 dia
(39 Comentários)

See private message.

$25.5 USD em 1 dia
(3 Comentários)

See private message.

$34 USD em 1 dia
(0 Comentários)