Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Anoying Excel 2007 glitch

I tried to program a macro to open an online spreadsheet called
http://88.208.xxx.xxx/hello.csv via VBA

i.e I tried to use the proper IP address rather than the domain address
www.xxxx.com/hello.csv. This worked fine when I wasn't using VBA in 2007.
Worked fine in VBA in 2003.

Unlike 2003, 2007 VBA gave a 'could not open' error message before going on
to open the file . What's really annoying though is that now, even though I
deleted the VBA command and replaced the IP address with the domain name,
EVERY TIME I open 2007, it STILL gives me an error message telling me it
cannot open http://88.208.xxx.xxx/hello.csv

Anyone know how to get rid of it?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another odd VBA glitch in 2007 teepee Excel Discussion (Misc queries) 4 April 1st 07 09:16 PM
Formula Calculation Glitch? Jake Excel Discussion (Misc queries) 3 September 16th 06 05:15 PM
Excel function glitch? bdog Excel Worksheet Functions 1 April 11th 06 06:01 PM
Anoying Paste Window caliskier Excel Discussion (Misc queries) 1 September 27th 05 09:39 PM
EXCELL 2002 Glitch???? Gabriel20783 Excel Discussion (Misc queries) 1 November 29th 04 08:55 PM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"