已完成

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

该项目成功由nwss1986 ,以 $23 AUD的价钱在 天内完成。

为像这样的项目获取免费报价
雇主工作
项目预算
$10 - $30 AUD
完成于
1 天
全部竞标
4
项目描述

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.

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online