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.

Problems:

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: excel specification, doc specification, save excel, macro script file, excel macro csv, coded management, project macro, 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, excel small, excel files directory, example macro script excel, project management excel format, script excel files, small project macro, excel macro run, excel script macro

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

ID do Projeto: #2995981

Premiar a:

schandraram

See private message.

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

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

dominique1

See private message.

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

See private message.

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

See private message.

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

See private message.

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