Em Andamento

VBA Macro which copies Sheet with formula's to many other workbooks (with no reference links to original book)


I have created a macro which copies an excel sheet from my current workbook to many other workbooks which are located in another folder. It works great but the problem is each workbook has the reference links back to the workbook it was copied from. I need the code adjusted so that each sheet that is copied to each workbook is referenced to itself. Please do not use a Replace function as each workbook is 5 MB and replace is very slow.

I have attached the code in a txt file to this project which you can test out and adjust.

Habilidades: Excel, Visual Basic

Ver mais: kamasutra original book illustrations, original book reader, orb original book reader, excel macro print sheet, using macro print sheet, macro excel sheet input, reference excel add macro, macro delete sheet, excel project macro samples, excel permutation macro, excel unicode macro, excel comparing macro code, excel project macro, excel 2000 macro web

Acerca do Empregador:
( 32 comentários ) melbourne, Australia

ID do Projeto: #11764196

Premiar a:


hi.i can start right now and can deliver to you in a couple of hours.contact me if interested.Thanks!!

$23 AUD em 0 dias
(16 Avaliações)

4 freelancers estão ofertando em média $38 para este trabalho

$50 AUD in 0 dias
(354 Comentários)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 AUD em 1 dia
(99 Comentários)
$30 AUD em 1 dia
(39 Comentários)