Macro Won't Run on Certain Machines

tlukareski · Apr 15th, 2002, 04:18 PM

I searched both here and on msdn for info on this and have been unsuccessful.

I have a Macro that I created on one machine and will not run on the other. I get the following error message...

Run-time Error '1004'
Application-defined or object-defined error

Both machines are running...
WinNT 4.0 SP6
Excel 2000 9.0.4402 SP-1
VB 6.0
VB Version 8967
VBA: Retail 6.0.8714
Forms3: 2.01

I also checked the VB TOOLS->REFERENCES and they matched exactly.

Any suggestions on what to do?

Thanks-
Thomas

dk · Apr 15th, 2002, 04:29 PM

Hello mate,

It's always best to post your code. In this case error 1004 as you described is a general error and could be one of many things - difficult to diagnose without seeing the code.

Regards,
Dan

brettvba · Apr 15th, 2002, 04:43 PM

what version was the code orig from I had some code in xp that would not work in 2000 but would work in 97 and so on may pay to go through the code and debug it if you know how to do that otherwise post your code and someone will be able to do that for you maybe

tlukareski · Apr 16th, 2002, 08:46 AM

I was able to figure out the problem. I was using Windows("Workbook_Name.xls").Activate when I should have been using Workbooks("Workbook_Name.xls").Activate.

Everything works just fine now...

Thanks-
Thomas

Mark O'Brien · Apr 16th, 2002, 09:02 AM

So the "certain" machines it wouldn't run on were all those with Windows and Excel installed on them.

Jack in the UK · Apr 16th, 2002, 12:57 PM

Hi --

for years and years i have disagreed on this but from today im convinced thisis true WHY?? no ideas yey, just wild quesses.

My cmpany has rolled out XP Win and XP Office now some of my VBA wont work, ie calculation codes,,, ???

And im still on the old server.. ODD. i get fails as break in close program menu?? no reason and heavy crashes, all codes ive used and not developed in months..

seems things do get upset.

sorry no fix,,, but i see your problems..

Apr 16th, 2002, 09:02 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	So the "certain" machines it wouldn't run on were all those with Windows and Excel installed on them. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 16th, 2002, 12:57 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi -- for years and years i have disagreed on this but from today im convinced thisis true WHY?? no ideas yey, just wild quesses. My cmpany has rolled out XP Win and XP Office now some of my VBA wont work, ie calculation codes,,, ??? And im still on the old server.. ODD. i get fails as break in close program menu?? no reason and heavy crashes, all codes ive used and not developed in months.. seems things do get upset. sorry no fix,,, but i see your problems.. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 04:18 PM	#1
tlukareski New Member Join Date: Apr 2002 Posts: 3	I searched both here and on msdn for info on this and have been unsuccessful. I have a Macro that I created on one machine and will not run on the other. I get the following error message... Run-time Error '1004' Application-defined or object-defined error Both machines are running... WinNT 4.0 SP6 Excel 2000 9.0.4402 SP-1 VB 6.0 VB Version 8967 VBA: Retail 6.0.8714 Forms3: 2.01 I also checked the VB TOOLS->REFERENCES and they matched exactly. Any suggestions on what to do? Thanks- Thomas

Apr 15th, 2002, 04:29 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hello mate, It's always best to post your code. In this case error 1004 as you described is a general error and could be one of many things - difficult to diagnose without seeing the code. Regards, Dan

Apr 15th, 2002, 04:43 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	what version was the code orig from I had some code in xp that would not work in 2000 but would work in 97 and so on may pay to go through the code and debug it if you know how to do that otherwise post your code and someone will be able to do that for you maybe

Apr 16th, 2002, 08:46 AM	#4
tlukareski New Member Join Date: Apr 2002 Posts: 3	I was able to figure out the problem. I was using Windows("Workbook_Name.xls").Activate when I should have been using Workbooks("Workbook_Name.xls").Activate. Everything works just fine now... Thanks- Thomas