Macro Question Again

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'v never had any dealings w/ macro before, so this is all new to me. I have
a windows 98 computer that is running office 2000 and there is an excel macro
on this pc that was created by someone years ago. I have to get this 98
machine of the network and replace it w/ a 2000/XP platform also running
either office 2000/xp. So far i'v copied the macro and am able to run it, but
its not gathering the correct info. It is collecting the correct info on the
98 machine, just not the one im replacing it w/. It looks like some of the
fields are supposed to be populated w/ info in a text doc, but it looks like
it taking the date of that text file and adding txt at the end. I'v coppied
all the files it needs. What might i be missing, or can i run the macro step
by step to see where it's going wrong. I'v tried step through a couple of
time, but doesn't look like its doing anything. Thanks in advance for any
replies.
 
I think it's probably impossible for anyone to guess from afar why your
macro is not running correctly on the new machine. You will have to step
through the code as you said. If the code 'isn't doing anything' you'll
have to figure out why. Compare it to what it does when you step through it
on the old machine. It would be good if you could latch on to someone with
a bit more VB experience.

--
Jim
| I'v never had any dealings w/ macro before, so this is all new to me. I
have
| a windows 98 computer that is running office 2000 and there is an excel
macro
| on this pc that was created by someone years ago. I have to get this 98
| machine of the network and replace it w/ a 2000/XP platform also running
| either office 2000/xp. So far i'v copied the macro and am able to run it,
but
| its not gathering the correct info. It is collecting the correct info on
the
| 98 machine, just not the one im replacing it w/. It looks like some of the
| fields are supposed to be populated w/ info in a text doc, but it looks
like
| it taking the date of that text file and adding txt at the end. I'v
coppied
| all the files it needs. What might i be missing, or can i run the macro
step
| by step to see where it's going wrong. I'v tried step through a couple of
| time, but doesn't look like its doing anything. Thanks in advance for any
| replies.
 
Back
Top