"Reference doesn't exist" is usually an indication that you're missing
an add on. The highlighting of the code line is simply a hangover from
what it was doing when it discovered the missing reference.
Hit the "stop" square on the toolbar, then open Tools/References and
look for something that is marked as missing. Chances are you'll find
something there.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of ohtechie
Sent: Friday, 20 May 2011 12:50
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] VBA/Macro Version problem
Ok I hope i can get an answer to this maddening problem. I have a
spreadsheet originally written in excel 2003, I am using 2010 and do not
have any problems with it. However, other coworkers that are using 2007
have run into a myriad of problems. overview of the vba/macro is that on
sheet1 there are a list of links, clicking on start button opens a form
where current date is entered, and there are options on what row to
start the macro on.
once the macro starts running, internet explorer opens to first link,
navigates to certain page, downloads a document (or multiple docs),
opens another spreadsheet to log what is being downloaded. closes
spreadsheet (log), then moves to next link.
however the users that have 2007, the file (log) opens readonly, there
are some errors reporting that the reference doesn't exist and int he
debugger the reference is a variable i= 1 to irow... with the i
highlighted.. i was not explicitly declared as integer but this works in
2003 and 2010.
Is there a setting or option that needs to be selected to not have
strict syntax? or is there any other reason why this would happen in
2007 and not the other versions?
Also one of the users was upgraded to 2010 and now the macro runs
without a problem... so it appears to be a version thing.
Any ideas?
Banging my head on the wall
thanks
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar