Modify a VB Script and Excel Macro

We want to schedule some spreadsheets to automatically open, refresh query data, then save and close. This will require a Visual Basic script and Excel Macro running in conjunction with each other. You should be aware that there is a lot of data to be refreshed and also a lot of calculations that occur subsequent to the data refresh, so the spreadsheet cannot save and close before everything is done.

In one case, we need to save the spreadsheet as an excel file and also save one of the sheets as a csv file.

We have code developed, but we need someone to tweak it so that everything works properly. We've attached images of what we have already.

Habilidades: Excel, PHP, Arquitetura de software, Visual Basic

Veja mais: script macro excel, excel macro java script, vb script sql server table excel workbook, macro script read multiple cells excel, macro excel script, export data multiple excel sheets single excel file vb net, excel script lock sheets, convert multiple text files excel worksheets vb script, call excel macro perl script, excel script modify active directory, excel macro module script, excel script macro export xml, excel macro compare script, fun macro excel script, macro excel compare script, excel macro perl script, excel script copy paste cells macro, script macro excel 2003, excel macro name script

Acerca do Empregador:
( 14 comentários ) Barrie, Canada

ID do Projeto: #14520903

Concedido a:


That code looks similar. I think I wrote that code for someone. How Do I know? Well, Do you see the "~~>" in " ~~> Change Path Here" That is my style of coding. :) Found it :) [login to view URL] Mais

$35 USD em 1 dia
(178 Comentários)

16 freelancers estão ofertando em média $58 para esse trabalho


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Mais

$90 USD in 2 dias
(209 Comentários)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience Relevant Skills and Experience Le Mais

$94 USD in 0 dias
(141 Comentários)

update macro based on requirements Relevant Skills and Experience Excel/VBA/Macro Proposed Milestones $50 USD - Completed macro

$50 USD em 1 dia
(155 Comentários)

I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience designing and developing Excel spreadsheets filled with formulas and VBA code. Mais

$90 USD em 1 dia
(130 Comentários)

we have expertise in web scraping, excel VBA , data  [login to view URL] satisfaction is our main motto for long term relationship.

$30 USD em 1 dia
(60 Comentários)
$222 USD in 5 dias
(31 Comentários)

Hi I would like to work on your project. I hope you will be fully satisfied after completing this project with me. Relevant Skills and Experience VBA Proposed Milestones $30 USD - project

$30 USD em 1 dia
(53 Comentários)

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find my previous work samples. Please let me know if we can discuss further on this. Relevant Skills and Experience vba macro excel P Mais

$35 USD em 1 dia
(20 Comentários)

A proposal has not yet been provided

$50 USD em 1 dia
(48 Comentários)

Hi, I have went through images. There are small bugs that has to be reprogram to make it more efficient. I have 7 years of experience in this field. You can read client reviews on my profile Relevant Skills and Experi Mais

$30 USD em 1 dia
(24 Comentários)

Experienced Data Analyst and Macro Developer. Relevant Skills and Experience I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing Mais

$35 USD em 1 dia
(59 Comentários)

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Mais

$25 USD em 1 dia
(25 Comentários)
$25 USD em 1 dia
(19 Comentários)
$60 USD in 2 dias
(7 Comentários)

I agree that VB script is the way to do this. Examples are available in technical discussion groups. Relevant Skills and Experience Engineering degree. 16 years of working in IT industry in USA, UK & New Zealand. Mais

$25 USD in 5 dias
(1 Comentário)