进行中

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

Hello,

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.

技能: Excel, Visual Basic

查看更多: research i need a good author to write my book it's about my life, freelancer pulover's macro creator, children's book illustrator's, original book reader, orb original book reader, original book reader orb zip swf pdf, input create file output excel data macro, excel macro print sheet, cut paste formula vba macro, using macro print sheet, macro excel sheet input, macro display graph excel vba, excel macro cut paste formula, excel macro historical stock quote vba, reference excel add macro, macro delete sheet, excel project macro samples, excel permutation macro, excel unicode macro, excel comparing macro code, excel project macro, convert excel 2000 macro excel 2007 macro, excel 2000 macro web

About the Employer:
( 32 reviews ) melbourne, Australia

项目ID: #11764196

已悬赏给:

nwss1986

hi.i can start right now and can deliver to you in a couple of [url removed, login to view] me if [url removed, login to view]!!

$23 AUD 在0天内
(16条评论)
3.5

4名威客为此工作的平均竞标价是$38

$50 AUD 在0天内
(354条评论)
7.6
P0L

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.

$50AUD 在1天里
(99条评论)
6.2
$30AUD 在1天里
(39条评论)
4.7