DS Forums

 
 

Can somebody make me a "clash detector"?


Reply
Thread Tools Search this Thread
Old 22-04-2009, 10:05
awo1949
Forum Member
 
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
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.
awo1949 is offline   Reply With Quote
Please sign in or register to remove this advertisement.
Old 22-04-2009, 10:37
savvy
Forum Member
 
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
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.
savvy is offline   Reply With Quote
Old 22-04-2009, 10:53
awo1949
Forum Member
 
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
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.
awo1949 is offline   Reply With Quote
Old 22-04-2009, 11:59
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
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. Reason: typo
grahamlthompson is offline   Reply With Quote
Old 22-04-2009, 16:39
savvy
Forum Member
 
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
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.
savvy is offline   Reply With Quote
Old 27-04-2009, 14:05
Stone Free
Forum Member
 
Join Date: May 2002
Location: Crystal Palace
Posts: 958
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.
Stone Free is offline   Reply With Quote
Old 27-04-2009, 14:38
awo1949
Forum Member
 
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
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.
awo1949 is offline   Reply With Quote
Old 27-04-2009, 14:48
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
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)
grahamlthompson is offline   Reply With Quote
Old 27-04-2009, 15:50
David500
Forum Member
 
Join Date: Aug 2008
Location: Somerset. UK
Posts: 102
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
David500 is offline   Reply With Quote
Old 27-04-2009, 15:56
awo1949
Forum Member
 
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
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.
awo1949 is offline   Reply With Quote
Old 27-04-2009, 15:58
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
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
grahamlthompson is offline   Reply With Quote
Old 27-04-2009, 16:08
awo1949
Forum Member
 
Join Date: Nov 2008
Location: Co. Donegal
Posts: 797
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.]
awo1949 is offline   Reply With Quote
Old 27-04-2009, 16:21
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
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 is offline   Reply With Quote
Old 19-05-2009, 16:08
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289

Talk Sport radio added to record clash app - no change in download link
grahamlthompson is offline   Reply With Quote
Old 16-06-2009, 13:22
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289

2 channels deleted and channel 205 transponder change - link unchanged
grahamlthompson is offline   Reply With Quote
Old 01-07-2009, 19:44
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289

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 is offline   Reply With Quote
Old 05-07-2009, 11:39
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289

Auto channel scan just removed BET HD. Record Check10 updated, DIY mod

Delete ROW 31, change Cell E1 to 148
grahamlthompson is offline   Reply With Quote
Old 08-07-2009, 10:38
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289

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
grahamlthompson is offline   Reply With Quote
Old 08-07-2009, 14:23
Geoff_W
Forum Member
 
Join Date: Jun 2004
Location: Nottingham
Posts: 372
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
Geoff_W is offline   Reply With Quote
Old 08-07-2009, 14:33
savvy
Forum Member
 
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
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.
savvy is offline   Reply With Quote
Old 08-07-2009, 14:36
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
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 is offline   Reply With Quote
Old 08-07-2009, 15:07
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
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 is offline   Reply With Quote
Old 08-07-2009, 15:10
grahamlthompson
Forum Member
 
Join Date: May 2005
Location: Redditch Worcs
Posts: 17,289
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
grahamlthompson is offline   Reply With Quote
Old 08-07-2009, 15:15
Geoff_W
Forum Member
 
Join Date: Jun 2004
Location: Nottingham
Posts: 372
Yes, that works fine now.

Thanks for the fast response.

Geoff
Geoff_W is offline   Reply With Quote
Old 08-07-2009, 15:16
savvy
Forum Member
 
Join Date: Nov 2008
Location: Hawkwell, Essex
Posts: 2,186
Les I have sorted it out it works now I think same link.
Yes, confirmed as fixed.

Rgds.

Les.
savvy is offline   Reply With Quote
 
Reply




 
Forum Jump


All times are GMT. The time now is 09:35.