1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Windows Security problem

Discussion in 'Business Applications' started by Teacherless, Jul 8, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Teacherless

    Teacherless Thread Starter

    Joined:
    Jun 28, 2012
    Messages:
    94
    Hi people, my problem is this:- I have a workbook in Excel 2003. In this wb is a hyperlink to a Yahoo site which downloads a csv file containing up to the minute dollar rates of exchange. Everything works fine. However, I also have the same wb saved as a .xlsm file, for users of Excel 2007, but when the hyperlink is selected, the wb "hangs" for 30 secs or more, then a "Windows Security" dialogue box appears asking for a password. After clicking about 4 or 5 times on the Ok button, a connection is eventually made, and the download is completed. Can anybody tell me how to stop this dialogue box appearing in the first place or, failing that, tell me what password is being asked for, as other people will be using this wb on their own pc. I have no administrator password entered on my pc and I do not have to log in. I am using Windows 7 Ultimate and I have both versions of Office installed. This problem doesn't occur in Excel2003, only 2007. Any help would be greatly appreciated. :confused:
    Cheers, John.
     
  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,055
    Might try making this a trusted site. Newer versions of office try and protect you from running macros and such from non trusted sites. Downloading the file to local storage might be an easy test.
     
  3. Teacherless

    Teacherless Thread Starter

    Joined:
    Jun 28, 2012
    Messages:
    94
    Hi there draceplace, yes, your idea would probably work ok. The problem is, this wb is to be used on other computers by other people, so they would get the same message, even if I find a workaround on my pc.
    I have attached a sample workbook (Book2) so that you can see the problem first hand. I have also tried to write code that, when the csv file has been downloaded, and the contents copied, the file is then closed or deleted. the reason for this is that, if an updated rate of exchange is needed later in the day, the download will not work if the first csv file still remains open, and thus the first rate of exchange could be mistaken for the update. Hope this helps to solve things.:confused:
    Cheers, John (Teacherless)
     

    Attached Files:

  4. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,055
    You are correct, other people would have to change settings. I'm not a web developer so I can't offer a better solution. Maybe if the spreadsheet was an .xls or .xlsx instead of an xlxm if there are no needed macros

    When you play with micro$oft you play by their rules.
     
  5. Teacherless

    Teacherless Thread Starter

    Joined:
    Jun 28, 2012
    Messages:
    94
    Hi draceplace, thanks for replying. As you can see, the wb that I have attached is an .xls file. There are 2 or 3 macros in it just to do the download that I am having problems with in the Excel 2007 version. In the full version there are 24 sheets just with the data bases on, another 3 user interface sheets, another which is shown if the user does not enable macros and another 2 which take the place of sheets 2 and 3 in the sample wb that I attached. There are many macros as they are needed to make the spreadsheet work. Again draceplace, thanks for applying your knowledge to my problem, I'll give it a little time, maybe someone will come up with a solution.
    Cheers, sleep well, John
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1060112