Excel Macro Remove Help

alyy8128 · 17th Nov 2008, 04:19 PM

Anyone familiar with Excel Macro/VBA here

I need some help to remove the embeded Macro/VBA code inside a excel file. My client sent me a file with Macro/VBA code built-in. My excel just crash everytime i tried to open the file. Because a windows will pop-up for prompt me wheter to run the macros or not. Whether I choose "enable/disable" the Excel also will crash.

Is there any method to remove the Macros without open the Excel?

Chai · 17th Nov 2008, 05:19 PM

Have you tried opening the same file on another PC? Sometimes the excel file could be corrupted.

alyy8128 · 17th Nov 2008, 05:28 PM

Quote:

Originally Posted by Chai

Have you tried opening the same file on another PC? Sometimes the excel file could be corrupted.

Already tried few PC. Still having still problem. All PC using Excel 2000, with WindowsXP.

Chai · 17th Nov 2008, 06:16 PM

Looks like the file could be corrupted.

Try opening the excel file using the Open and Repair option.

lee_what2004 · 17th Nov 2008, 09:10 PM

try to run
excel /a

then drag the file excel to it?

alyy8128 · 18th Nov 2008, 09:04 AM

Quote:

Originally Posted by lee_what2004

try to run
excel /a

then drag the file excel to it?

Cannot also.

I wonder is it caused by the different language of Excel version? Because my client if from Korea.

I manage to open the file using other computer installed with excel 2003. Then to remove the Macros inside. However, the same problem happen when i bring the file back to my office using the Excel2000.

lee_what2004 · 18th Nov 2008, 10:04 AM

Quote:

Originally Posted by alyy8128

Cannot also.

I wonder is it caused by the different language of Excel version? Because my client if from Korea.

I manage to open the file using other computer installed with excel 2003. Then to remove the Macros inside. However, the same problem happen when i bring the file back to my office using the Excel2000.

how about copy paste the content to a new excel ?
not just removing the macro

alyy8128 · 18th Nov 2008, 11:36 AM

Yup. Just been done with that method.

Anyway, after I used excel2003 to copy all the content into a new sheet. Then the new file can be open in my office stupid old computer.

Just wonder what is the root causes of this problem. Is it due to the language pack installed?

Chai · 18th Nov 2008, 08:16 PM

Maybe it's backward compatibility problem. Save as Excel 2000?

alyy8128 · 18th Nov 2008, 10:36 PM

I had tried using the same file, open with excel2003 and save in Excel2000 format. The file size growth from 7MB to 160MB. But still cannot open in my office's excel2000.

I have to manually copy the content of every sheet into a new file created in Excel 2003 then can be use.

17th Nov 2008, 04:19 PM	#1 (permalink)
alyy8128 Warming up Join Date: 22 Jan 2006 Location: Senai Johor Posts: 106 Reputation: 116 Rep Power: 4	Excel Macro Remove Help Anyone familiar with Excel Macro/VBA here I need some help to remove the embeded Macro/VBA code inside a excel file. My client sent me a file with Macro/VBA code built-in. My excel just crash everytime i tried to open the file. Because a windows will pop-up for prompt me wheter to run the macros or not. Whether I choose "enable/disable" the Excel also will crash. Is there any method to remove the Macros without open the Excel? __________________ 愿：世界和平

17th Nov 2008, 05:19 PM	#2 (permalink)
Chai Administrator Join Date: 6 Oct 2002 Location: Maranello Posts: 26,975 Reputation: 4108 Rep Power: 74	Have you tried opening the same file on another PC? Sometimes the excel file could be corrupted. __________________ Chai (Contributor & Forum Admin) http://www.techarp.com/

17th Nov 2008, 06:16 PM	#4 (permalink)
Chai Administrator Join Date: 6 Oct 2002 Location: Maranello Posts: 26,975 Reputation: 4108 Rep Power: 74	Looks like the file could be corrupted. Try opening the excel file using the Open and Repair option. __________________ Chai (Contributor & Forum Admin) http://www.techarp.com/

17th Nov 2008, 09:10 PM	#5 (permalink)
lee_what2004 Active Join Date: 28 Dec 2007 Location: Melaka Posts: 996 Reputation: 757 Rep Power: 9	try to run excel /a then drag the file excel to it? __________________

18th Nov 2008, 11:36 AM	#8 (permalink)
alyy8128 Warming up Join Date: 22 Jan 2006 Location: Senai Johor Posts: 106 Reputation: 116 Rep Power: 4	Yup. Just been done with that method. Anyway, after I used excel2003 to copy all the content into a new sheet. Then the new file can be open in my office stupid old computer. Just wonder what is the root causes of this problem. Is it due to the language pack installed? __________________ 愿：世界和平

18th Nov 2008, 08:16 PM	#9 (permalink)
Chai Administrator Join Date: 6 Oct 2002 Location: Maranello Posts: 26,975 Reputation: 4108 Rep Power: 74	Maybe it's backward compatibility problem. Save as Excel 2000? __________________ Chai (Contributor & Forum Admin) http://www.techarp.com/

18th Nov 2008, 10:36 PM	#10 (permalink)
alyy8128 Warming up Join Date: 22 Jan 2006 Location: Senai Johor Posts: 106 Reputation: 116 Rep Power: 4	I had tried using the same file, open with excel2003 and save in Excel2000 format. The file size growth from 7MB to 160MB. But still cannot open in my office's excel2000. I have to manually copy the content of every sheet into a new file created in Excel 2003 then can be use. __________________ 愿：世界和平

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel File Cannot Open	alyy8128	General Software	6	29th Apr 2008 06:40 AM
Convert Text to Excel.	Pluto_Flying	General Software	3	25th Feb 2008 07:58 AM
Excel Help! How to link two list?	aKho	General Software	0	11th Jul 2006 06:34 PM