Thanks Noorain, appreciate the response.
The problem however isn't the opening of files so much as it is the
execution of the macros contained therein. I tried the articles
recommendations and it didn't help. The code I pasted works fine when
manually pasted into excel vba editor, however if I create an add-in or use
an xlstart file the code fails with a generic 400 error.
If I debug the macro in the add-in or the xlstart file it seems to failing
on the range select statement RANGE("A2").select and I have no idea why.
Why it works when manually pasted and not when included in the
add-in/xlstart file ?
That is my problem. When using the xlstart file, it opens automatically
every time I open a csv file no problem at all, it's just I get the 400
error every time I execute one of the macros contained therein.
Any other suggestions ? Regards, Fin.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
