• TV
  • MOVIES
  • MUSIC
  • SHOWBIZ
  • SOAPS
  • GAMING
  • TECH
  • FORUMS
  • Follow
    • Follow
    • facebook
    • twitter
    • google+
    • instagram
    • youtube
Hearst Corporation
  • TV
  • MOVIES
  • MUSIC
  • SHOWBIZ
  • SOAPS
  • GAMING
  • TECH
  • FORUMS
Forums
  • Register
  • Login
  • Forums
  • Entertainment Services
  • Satellite
  • Freesat+ Recorders
Can somebody make me a "clash detector"?
<<
<
5 of 7
>>
>
awo1949
22-04-2009
Originally Posted by savvy:
“The option is in Excel itself.

In Excel 2003, it's under Tools | Macro | Security.

Change to Medium Security Level, and it will then ask you each time if you want to run Macros; obviously say yes to allow Graham's application. This is safer than Low, which will run all macros, even those you don't know ”

If you are using Excel 2007 (not sure about other versions) there is another option available. From within Excel, you can specify a particular folder on your PC as being trusted. Any excel file containing macros opened from that directory will open seemlessly.

You can actually specify more than one folder as being trusted, but what I do is to have a single folder in which I store all Excel files with macros that I trust. I then create shortcuts to the files in the (untrusted) folders that I would have stored them in if it wasn't for the macros.
savvy
22-04-2009
Originally Posted by awo1949:
“If you are using Excel 2007 (not sure about other versions) there is another option available. From within Excel, you can specify a particular folder on your PC as being trusted. Any excel file containing macros opened from that directory will open seemlessly. ”

The "Very High" Security Level within Excel 2003 "appears" to offer a "trusted locations" option, but when you select this, it doesn't seem to offer the option to specify the location. I've tried looking in the Help, but it's not much use in this respect.

If anyone knows how to do this, it would be useful here.

The other way of doing it is for the author to digitally sign the macros from within Excel, and then when you open the Workbook with Security Level Medium, you can get the option to add the author as a Trusted Publisher. But to do this, I think the author has to obtain a Digital Certificate, which I don't think are free

Rgds.


Les.
awo1949
22-04-2009
Originally Posted by savvy:
“The "Very High" Security Level within Excel 2003 "appears" to offer a "trusted locations" option, but when you select this, it doesn't seem to offer the option to specify the location. I've tried looking in the Help, but it's not much use in this respect.”

With Excel 2007, you get to it by selecting "Excel options" followed by "Trust Center". Pressing the "Trust Center Settings" button brings up the "Trust Center" window. From here you can select a number of options. The ones relevent here are

- "Trusted locations" where you can manage trusted folders including adding new ones, and
- "Macro Settings" where you can chose what Excel does about macros in files not in a trusted location.

I have this "Macro Settings" set to "Disable all macros with notification". With this setting Excel will let me chose what to do about macros for files stored in a "normal" location and open files in trusted locations with macros automtically enabled.
grahamlthompson
22-04-2009
Originally Posted by savvy:
“Graham, there are no http links

Rgds.

Les.”

Thanks Les, very wierd it was a copy and paste from a posting on AVforums. The links work there but for some reason don't survive the clipboard

Here they are (hopefully )

http://www.4shared.com/file/10021431...ableWatch.html

http://www.4shared.com/file/10021432.../OneCable.html

http://www.4shared.com/file/10021434...leSuggest.html

http://www.4shared.com/file/10021437...ableWatch.html

http://www.4shared.com/file/10021439.../TwoCable.html

http://www.4shared.com/file/10021441...leSuggest.html

Graham
Last edited by grahamlthompson : 22-04-2009 at 12:00
savvy
22-04-2009
Originally Posted by awo1949:
“With Excel 2007, you get to it by selecting "Excel options" followed by "Trust Center". Pressing the "Trust Center Settings" button brings up the "Trust Center" window. From here you can select a number of options. The ones relevent here are

- "Trusted locations" where you can manage trusted folders including adding new ones, and
- "Macro Settings" where you can chose what Excel does about macros in files not in a trusted location.”

The Trust Centre, nor Trusted Locations, appears to be present on Excel 2003, but thanks anyway.

I've got Office 2007, but when I installed it for my daughter on her PC, I really didn't like the interface at all, I couldn't intuitively find my way around it, and I don't do manuals

I'll stick with 2003, and it really isn't that much effort to press the "Run Macros" button when opening the file.

Rgds.


Les.
Stone Free
27-04-2009
Originally Posted by savvy:
“The other way of doing it is for the author to digitally sign the macros from within Excel, and then when you open the Workbook with Security Level Medium, you can get the option to add the author as a Trusted Publisher. But to do this, I think the author has to obtain a Digital Certificate, which I don't think are free ”

Les,

Comodo offer free Digital Certificates for email, I don't know if it could also be used to sign macros - http://www.comodo.com/products/certi...ces/index.html

The signup page does mention X509.
awo1949
27-04-2009
Originally Posted by savvy:
“I've got Office 2007, but when I installed it for my daughter on her PC, I really didn't like the interface at all, I couldn't intuitively find my way around it, and I don't do manuals ”

I hated the Office 2007 interface when I first installed it, but I was updating from Office 1997 so I stuck with it. It took me a long time to get used to it (I also don't do manuals) but, now that I have, I find it a lot quicker to navigate than 1997. I doubt if there would be a lot of point in upgrading from 2003, though.
grahamlthompson
27-04-2009
Originally Posted by awo1949:
“I hated the Office 2007 interface when I first installed it, but I was updating from Office 1997 so I stuck with it. It took me a long time to get used to it (I also don't do manuals) but, now that I have, I find it a lot quicker to navigate than 1997. I doubt if there would be a lot of point in upgrading from 2003, though.”

Someone sent me spreadsheet from Excel2007 with vba code. I could not even view it in Excel2000. If anyone want's to distibute code to earlier versions it might be wise to stick to an earlier version. (Unless someone out there knows how to make 2007vba accessible to earlier versions)
David500
27-04-2009
Originally Posted by grahamlthompson:
“Someone sent me spreadsheet from Excel2007 with vba code. I could not even view it in Excel2000. If anyone want's to distibute code to earlier versions it might be wise to stick to an earlier version. (Unless someone out there knows how to make 2007vba accessible to earlier versions)”

Microsoft do a free 2007 compatablity download for Office 2000, 2002 & 2003 see:
http://www.microsoft.com/downloads/d...displayLang=en
awo1949
27-04-2009
Originally Posted by grahamlthompson:
“Someone sent me spreadsheet from Excel2007 with vba code. I could not even view it in Excel2000. If anyone want's to distibute code to earlier versions it might be wise to stick to an earlier version. (Unless someone out there knows how to make 2007vba accessible to earlier versions)”

It may not be the VBA code that's the problem, but the way in which the spreadsheet was saved. Excel 2007 has its own format (.xlsx) which it will default to. Even the simplest of spreadsheets saved as a .xlsx file won't open in earlier versions. Excel 2007 does have a "Save as Excel 97-2003 Workbook" option (which can be set as the default). This saves to .xls format. If there are functions in the workbook that won't convert to .xls, you will be warned. I always save to .xls if I'm sending the file to someone and I've had no problems with speadsheets containing VBA code (but that may be because my VBA efforts have been very basic). Most of the issues I've seen have been cosmetic.

If you get a .xlsx file from someone, ask them to send it again as .xls. It should be easy enough for them to do.
grahamlthompson
27-04-2009
Originally Posted by awo1949:
“It may not be the VBA code that's the problem, but the way in which the spreadsheet was saved. Excel 2007 has its own format (.xlsx) which it will default to. Even the simplest of spreadsheets saved as a .xlsx file won't open in earlier versions. Excel 2007 does have a "Save as Excel 97-2003 Workbook" option (which can be set as the default). This saves to .xls format. If there are functions in the workbook that won't convert to .xls, you will be warned. I always save to .xls if I'm sending the file to someone and I've had no problems with speadsheets containing VBA code. Most of the issues I've seen have been cosmetic.

If you get a .xlsx file from someone, ask them to send it again as .xls. It should be easy enough for them to do.”

It was a .xls file, I could open it and run the code but not view it or edit it any way
awo1949
27-04-2009
Originally Posted by grahamlthompson:
“It was a .xls file, I could open it and run the code but not view it or edit it any way”

OK. I thought you were saying that you couldn't open the file or use it in any way. The .xls version of the code is obviously 2000 compatible otherwise you couldn't run it. Odd that 2000 won't display the code for editing. I assume you have the VBA plugin installed. [Note: Not quite sure whether that's what it's called, or whether it's relevent to 2000. What I'm remembering is that, with '97, the VBA editor was a seperate component which was not installed by default.]
grahamlthompson
27-04-2009
Originally Posted by awo1949:
“OK. I thought you were saying that you couldn't open the file or use it in any way. The .xls version of the code is obviously 2000 compatible otherwise you couldn't run it. Odd that 2000 won't display the code for editing. I assume you have the VBA plugin installed. [Note: Not quite sure whether that's what it's called, or whether it's relevent to 2000. What I'm remembering is that, with '97, the VBA editor was a seperate component which was not installed by default.]”

It's installed by default, using the same version of Excel used to write the record clash application.
grahamlthompson
19-05-2009
Talk Sport radio added to record clash app - no change in download link
grahamlthompson
16-06-2009
2 channels deleted and channel 205 transponder change - link unchanged
grahamlthompson
01-07-2009
Todays changes uploaded

142 BET HD added
401 Name Changed to Wedding TV Asia (was Wedding TV + 1)
801 Price Drop TV transponder change

No change to link
grahamlthompson
05-07-2009
Auto channel scan just removed BET HD. Record Check10 updated, DIY mod

Delete ROW 31, change Cell E1 to 148
grahamlthompson
08-07-2009
With thanks to Savvy who spotted some inconsistency in the results.

For both single and dual options programme incorrectly identifies channels 208, 513 and 801 as viewable with ITV HD as one of the recordings

Similar bugs in single cable and dual cable suggestion and what can I watch fixed

West Country (Exeter) post code now default due to ITV1 picture quality

For anyone interested the problem was due to ITV HD having the same transponder frequency but differing polarity to some channels on Astra 2.



http://www.4shared.com/file/11660217...dCheck011.html
Geoff_W
08-07-2009
Found a bug in V11.

Select Dual Cable
Select First Recording = 108 BBC HD
Select Second Recording = 101 BBC 1 E Mids
Click on Alternate Watch Options

The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required.

I am in the East Midlands, so my first four rows are as follows:-

101 BBC 1 E Mids 10788 V
102 BBC 2 England 10773 H
103 ITV HD (red button) 11426 H
103 ITV1 Central E 10832 H

Geoff
savvy
08-07-2009
Originally Posted by Geoff_W:
“Found a bug in V11.

Select Dual Cable
Select First Recording = 108 BBC HD
Select Second Recording = 101 BBC 1 E Mids
Click on Alternate Watch Options

The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required.

I am in the East Midlands, so my first four rows are as follows:-

101 BBC 1 E Mids 10788 V
102 BBC 2 England 10773 H
103 ITV HD (red button) 11426 H
103 ITV1 Central E 10832 H

Geoff”

If you leave it for a while, it comes up with a VB overflow message, you don't have to End Program.

I think there are too many permutations with all the Regional BBC1 channel options.

I think we had this in one of the earlier versions, and Graham put a limit on the output.

I'm sure he'll be along soon.

Rgds.


Les.
grahamlthompson
08-07-2009
Originally Posted by Geoff_W:
“Found a bug in V11.

Select Dual Cable
Select First Recording = 108 BBC HD
Select Second Recording = 101 BBC 1 E Mids
Click on Alternate Watch Options

The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required.

I am in the East Midlands, so my first four rows are as follows:-

101 BBC 1 E Mids 10788 V
102 BBC 2 England 10773 H
103 ITV HD (red button) 11426 H
103 ITV1 Central E 10832 H

Geoff”

so it does - on the case
grahamlthompson
08-07-2009
Originally Posted by savvy:
“If you leave it for a while, it comes up with a VB overflow message, you don't have to End Program.

I think there are too many permutations with all the Regional BBC1 channel options.

I think we had this in one of the earlier versions, and Graham put a limit on the output.

I'm sure he'll be along soon.

Rgds.


Les.”

Les I have sorted it out it works now I think same link.
grahamlthompson
08-07-2009
Originally Posted by Geoff_W:
“Found a bug in V11.

Select Dual Cable
Select First Recording = 108 BBC HD
Select Second Recording = 101 BBC 1 E Mids
Click on Alternate Watch Options

The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required.

I am in the East Midlands, so my first four rows are as follows:-

101 BBC 1 E Mids 10788 V
102 BBC 2 England 10773 H
103 ITV HD (red button) 11426 H
103 ITV1 Central E 10832 H

Geoff”

Thanks Geoff try downloading again
Geoff_W
08-07-2009
Yes, that works fine now.

Thanks for the fast response.

Geoff
savvy
08-07-2009
Originally Posted by grahamlthompson:
“Les I have sorted it out it works now I think same link.”

Yes, confirmed as fixed.

Rgds.

Les.
<<
<
5 of 7
>>
>
VIEW DESKTOP SITE TOP

JOIN US HERE

  • Facebook
  • Twitter

Hearst Corporation

Hearst Corporation

DIGITAL SPY, PART OF THE HEARST UK ENTERTAINMENT NETWORK

© 2015 Hearst Magazines UK is the trading name of the National Magazine Company Ltd, 72 Broadwick Street, London, W1F 9EP. Registered in England 112955. All rights reserved.

  • Terms & Conditions
  • Privacy Policy
  • Cookie Policy
  • Complaints
  • Site Map