I made the mistake of trying to run a macro that opened a file online using
the ip address instead of the domain

ie http://number.number.number/filename.csv

instead of

http://www.domainname.com/filename.csv

Worked fine in 2003 but not in 2007

Problem is that now EVERYTIME I open 2007 for anything at all, it throws up
an error message "http://number.number.number/filename.csv could not be
found blah blah"

Any idea how to get rid of it, anyone?

Sounds like you put that file in your XLSTART directory. Check this out:
http://www.officearticles.com/excel/...soft_excel.htm
I'm assuming that Excel 2007 still uses an XLSTART folder, but I don't have
it so I can't check.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"teepee" wrote in message
...
I made the mistake of trying to run a macro that opened a file online using
the ip address instead of the domain

ie http://number.number.number/filename.csv

instead of

http://www.domainname.com/filename.csv

Worked fine in 2003 but not in 2007

Problem is that now EVERYTIME I open 2007 for anything at all, it throws
up
an error message "http://number.number.number/filename.csv could not be
found blah blah"

Any idea how to get rid of it, anyone?

"Anne Troy" wrote

Sounds like you put that file in your XLSTART directory.

Thanks for the thought but no, that wasn't it. I'm just going to uninstall
and reinstall I think.

I'm just going to uninstall and reinstall I think.

A time honored stalling device used by tech support desks everywhere.
Effective .1% of the time. You see, almost all problems like this are
caused user settings or files that reinstalling does not touch. (Hopefully
now that I said this, reinstalling will help<g)

I have no idea why you're having this problem but fyi there are two xlstart
folders on your machine so be sure to check both. One is under the Excel
application folder and the other is under your user folder under Documents
and Settings (Windows XP). Also there's the folder designated in Excel
Options to open files from at startup.


--
Jim
"teepee" wrote in message
...
|
| "Anne Troy" wrote
|
| Sounds like you put that file in your XLSTART directory.
|
| Thanks for the thought but no, that wasn't it. I'm just going to uninstall
| and reinstall I think.
|
|

"Jim Rech" wrote

A time honored stalling device used by tech support desks everywhere.
Effective .1% of the time. You see, almost all problems like this are
caused user settings or files that reinstalling does not touch. (Hopefully
now that I said this, reinstalling will help<g)

I have no idea why you're having this problem but fyi there are two xlstart
folders on your machine so be sure to check both. One is under the Excel
application folder and the other is under your user folder under Documents
and Settings (Windows XP). Also there's the folder designated in Excel
Options to open files from at startup.

Yeah I looked in both. We'll see if reinstall does the trick but I know what
you mean.