Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activeworkbook problems
I have a customer who uses a excel file with a "movedata" macro. He is
using OfficeXP. The problem we have is this macro has a ActiveWorkbook.SetLinkOnData line in it. If he brings up another file (along with the original file) in excel and makes that the ActiveWorkbook by having it up then the macro in the original file gives a error when the movedata is initiated. Is there another replacement command for ActiveWorkBook.SetLinkOnData ? Please advise. Thanks, Tig |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
activeworkbook problems
Replace ActiveWorkbook with ThisWorkbook
http://HelpExcel.com "texastig" wrote: I have a customer who uses a excel file with a "movedata" macro. He is using OfficeXP. The problem we have is this macro has a ActiveWorkbook.SetLinkOnData line in it. If he brings up another file (along with the original file) in excel and makes that the ActiveWorkbook by having it up then the macro in the original file gives a error when the movedata is initiated. Is there another replacement command for ActiveWorkBook.SetLinkOnData ? Please advise. Thanks, Tig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
ActiveWorkBook | Excel Discussion (Misc queries) | |||
ActiveWorkbook.RefreshAll | Excel Programming | |||
ActiveWorkbook.Close | Excel Programming | |||
ActiveWorkbook.RefreshAll | Excel Programming |