Copied macro keeps referencing original worksheet?

**c2q** · 08-08-2012, 02:40 PM

I wrote a simple macro that basically extracts data from a worksheet and puts it into a text file. The problem is though when I copy the macro to a different entirely new workbook of the same format and different data, the macro will keep referencing the original workbook and keep extracting data from that one. What do I do?

**K m** · 08-08-2012, 03:20 PM

An easy way is to edit the VB code and change the references manually

**c2q** · 08-08-2012, 05:03 PM

How would I do that? This is my code:

Please Login or Register  to view this content.

It's really simple and just pulls off values from the current sheet, pastes them into a new sheet and then saves it as a text file.

**K m** · 08-08-2012, 05:17 PM

:="C:\BID" & j & ".txt",

This looks like it need to be changed. Change the BID to something else

**c2q** · 08-08-2012, 10:28 PM

Tried that, didn't work. Confused as to how a string would change anything?

Is there some code that I could add that would tell it to use the current sheet/workbook as the active sheet to extract data from?