Over 1 million tech questions and answers.

Google Sheets Buttons & Scripting

Q: Google Sheets Buttons & Scripting

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that information (already voted or not) to persist once they close out of the sheet. 
 
 
Note I'm specifically doing this in google sheets, as opposed to google forms, in order to allow for them to add suggestions directly to the voting sheet (rather than filling out a form that sends me the suggestion, then me putting the suggestion in the voting form). This might not be the most appropriate forum to ask, but last time I got some amazing help here. Any help/suggestions/other is appreciated!

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Google Sheets Buttons & Scripting

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 116.8

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that informat... Read more

Read other answers
RELEVANCY SCORE 54

I'm trying to sort columns A, B and C alphabetically so that the correct # in Column A corresponds with columns A and B.
Thank You,
Gary
 

A:Google Sheets alpha

Well Column A are numbers in numerical order. The sort will not change because it's in order already.

What column are you looking to be in alphanumeric order?
 

Read other 1 answers
RELEVANCY SCORE 54

Hi All,
I am a secretary of a football club and I am looking to make a membership database using Google sheets which I can sync to Google drive and allow me to update while in the club office or while I am on my home PC.
As well as a database of members names and addresses, I would have column's for member type, DOB, email and a photo which I would like to open up in another page when I click on it


I was wondering if someone out there would have any ideas of how I could make this as I'm a bit of a novice.
Thanks in advance
Brianljnr
 

A:Google Sheets Question

Brian, you can probably find instructions at Google Docs \ Sheets Help.
 

Read other 1 answers
RELEVANCY SCORE 53.2

As mentioned in the heading, is it in any way possible to reset several checkboxes all at once?
 

Read other answers
RELEVANCY SCORE 52

Hi!

I'd like to get a few cells in a list from a Google Sheets.
I have the following data:
First list horizontally: 1 in C2, 2 in D2, 3 in E2
Second list vertically: 1 in C5, 2 in C6, 3 in C7
Here is the test sheet: https://goo.gl/UDooqL

I use the following script:

function onEdit(){
var tabla = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var aktivcella = tabla.getActiveCell();
if(aktivcella.getColumn() == 1 && aktivcella.getRow() > 1){
var vizszinteslista = tabla.getRange(2, 3, 1, tabla.getLastColumn()).getValues();
var fuggolegeslista = tabla.getRange(5, 3, tabla.getLastRow(), 1).getValues();
Logger.log(aktivcella.getValue());
Logger.log(vizszinteslista);
Logger.log(fuggolegeslista);
tabla.getRange("E8").setValue("a script lefutott");
}
}

This results in the log:

[<<timestamp>>] Igen
[<<timestamp>>]] [[1.0, 2.0, 3.0, , ]]
[<<timestamp>>] [[1.0], [2.0], [3.0], [], [], [], []]

Why the two list differs?

Thanks.
 

Read other answers
RELEVANCY SCORE 52

I am using conditional formatting with a custom formula in Google Sheets to fill color the minimum and maximum values in a column.

The minimum works just fine:

Code:
=$AG:$AG=min(AG:AG)
But if I change min to max nothing in the column gets highlighted.

Code:
=$AG:$AG=max(AG:AG)
The range is set to AG2:AG25
 

Read other answers
RELEVANCY SCORE 50.4

Google fixes cross-site scripting vulnerability in YouTube comments.

I use Firefox 3.6.6 with the NoScript Firefox add-on for an extra-measure of protection against cross-scripting attacks.

Added Note: Be careful what links you click!

-- Tom
 

A:Google fixes cross-site scripting vulnerability in YouTube comments

Good Read
 

Read other 1 answers
RELEVANCY SCORE 50.4

Hello Volunteer Geniuses, and thank you!

I am seeking help with two error messages I?ve received from Google, and I?ve detailed other things going on that might or might not be related. My concern is that my machine is infected with something I can?t discover using Norton 360 v.5, System Mechanic Pro 10.5, HijackThis and MalwareBytes.

Here are my machine?s specs:

PC Manufacturer Dell Computer Corporation
Model Dimension 8250
Motherboard Manufacturer Dell Computer Corp.
Product
CPU Intel® Pentium® 4 CPU 2.66GHz
Version x86 Family 15 Model 2 Stepping 7
Data Width 32bits
Approximate Current Clock Speed 2,652Mhz
Approximate Maximum Clock Speed 2,652Mhz
BIOS Default System BIOS
Date 1/27/2003
Version DELL - 8
Memory slots available on motherboard 4
Memory Chip RIMM1
RAM 256MB
Speed 400ns
Memory Chip RIMM2
RAM 256MB
Speed 400ns
Memory Chip RIMM3
RAM 256MB
Speed 400ns
Memory Chip RIMM4
RAM 256MB
Speed 400ns
Motherboard Device
Status Off
System Slot PCI1
Status Available
System Slot PCI2
Status Available
System Slot PCI3
Status Available
System Slot PCI4
Status Available
System Slot AGP1
Status In Use
CD Drive PIONEER DVD-RW DVR-109 (Currently dead, I suppose)
Media Type CD-ROM
CD Drive LITEON DVD-ROM LTD163 (Currently working or not working, as it sees fit)
Media Type CD-ROM
Video Manufacturer ATI Technologies Inc.
Video Card ALL-IN-WONDER 9600 SERIES
RAM 128MB
Mode 1024 x 768 x 4294967296 colors
Driver ati2dvag.dll... Read more

A:Receiving two errors from Google: "Unusual Traffic.." and "Cross-Site Scripting"

Hello and welcome to Bleeping Computer! I am HelpBot: an automated program designed to help the Bleeping Computer Staff better assist you! This message contains very important information, so please read through all of it before doing anything. We apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here. To help Bleeping Computer better assist you please perform the following steps:*************************************************** In order to continue receiving help at BleepingComputer.com, YOU MUST tell me if you still need help or if your issue has already been resolved on your own or through another resource! To tell me this, please click on the following link and follow the instructions there.CLICK THIS LINK >>> http://www.bleepingcomputer.com/logreply/419479 <<< CLICK THIS LINK If you no longer need help, then all you needed to do was the previous instructions of telling me so. You can skip the rest of this post. If you do need help please continue with Step 2 below.*************************************************** If you still need help, I would like you to post a Reply to this topic (click the "Add Reply" button in the lo... Read more

Read other 27 answers
RELEVANCY SCORE 46.8

Using Google Sheets. Why am I getting this error msg? "Cannot sort a range containing merges." I DON'T have any merged columns, or merged anything. No hidden columns, or at least they weren't hidden when I tried to do the sort.

I tried to attach the file as a XLSX, and CSV, and both formats gave me an error.

A:Error Msg "Cannot sort a range containing merges." in Google Sheets

Quote:
try selecting all cells, then click Format > Merge cells > Unmerge


https://productforums.google.com/for...cs/b1B5ZswXytE

A Guy

Read other 3 answers
RELEVANCY SCORE 46.8

So, I've been looking up the topic for quite a while and it's suddenly become critical to what I am doing. Everywhere I have looked, I see lots of ways to copy multiple sheets into one sheet. This doen't do me the least bit of good. I have two 70+ tab spreadsheets. One for actuals, one for forecast. I need to copy the actuals for the first 5 fiscal periods of the year into the Forecast file. As there are 70+ sheets, I would prefer not to do this one at a time. In know in the previous versions of Excel, I could simply highlight all the sheets, highlight the data I needed, hit copy, and paste the data in the new sheet. So long as the sheets were laid out the same, it was never a problem.

Do you have any idea how to do this now?

Thank you.
 

A:Excel 2010 copying multiple sheets into multiple sheets

Read other 7 answers
RELEVANCY SCORE 46.4

Hi,
I've been fighting with some sort of redirect virus. Checked my computer with Malwarebates in Safe MOde, Normal Mode, etc. It did find some viruses but removed them and nothing is present anymore. I also checked my comp with BitDefender online scanner, SuperAntiSpyware, HijackTHis. They don't find any viruses. Computer works fast, although aftre all this checking and removal I found that sometimes when I click two windows too fast it locks and I have to reboot it by reset button.
Now the annoying part is that when I do Google search it still redirects me to various random sites. I also found that when I disable active scripting it does not do that, but then I cannot view YOuTube movies, etc.
Is ther a way to analyze and search for scripts that cause this. I assume it's just some stupid script that gets activated when I'm on line, because none of the AV programs I use finds any viruses anymore.
Any help would be appreciated
Thanks

A:Google redirect? No viruses found but active when active scripting enabled

Could you please post the log files from all the programs you ran? (MBAM and SUPERantispyware) Do NOT post the Hijackthis log.

Read other 5 answers
RELEVANCY SCORE 45.2

When I try to add bbc news button to my google toolbar for firefox it displays an error displaying "Information not available, custom button values out of range." Please help!!!
 

Read other answers
RELEVANCY SCORE 45.2

after reload of win Vista everything works fine. but in about 3 months time I start to loose browser functionality. When I go to google maps it will start to load a very small portion of the map at the top of the screen and stop. no error messages. On other webpages the buttons that use to work no longer work. This happens for all browsers. I reloaded once to solve this problem. I would like to know what might be the cause. Has anyone else experienced this?

on a side note: is there anyway to change which mail application is used when clicking within the browser? Like when you click to email someone from a form.

A:google maps won't show map, some buttons don't work on other sites

Welcome
I can answer the second part of your post
Go to search, by the start button
Type the word default
When you see default programs, click on it
Check the program that you want to be the default.

Read other 1 answers
RELEVANCY SCORE 44.8

Hi there

sometimes when you are looking for stuff and you reach a site you are presented with a whole confusing array of download buttons, install applications or whatever really hiding the actual download you want - sites like DriverMax come to mind for example/

Finally Google is going to try and tidy up this lot -- about time too.

The confusing downloads can often lead to people installing all sorts of unwanted spyware, PUPS, viruses etc etc.
We should support anybody trying to clear those things up.

I consider myself as reasonably experienced - but sometimes I've found it incredibly hard to get the actual download I'm after having navigated through endless traps of arrows etc to spurious links.

Note Torrentfreak is a perfectly 100% legitimate News site so no illegal software being offered. !!!!

Google Targets Fake Buttons - TorrentFreak

Cheers
jimbo

A:Finally Google to help stopping confusing download buttons on web site

This is good news. It has reached ridiculous levels on even legitimate download sites. I tend to stick to MajorGeeks.com because they test out the software and offer clean, easy to find download links.

Read other answers
RELEVANCY SCORE 44.8

Hi there

sometimes when you are looking for stuff and you reach a site you are presented with a whole confusing array of download buttons, install applications or whatever really hiding the actual download you want - sites like DriverMax come to mind for example/

Finally Google is going to try and tidy up this lot -- about time too.

The confusing downloads can often lead to people installing all sorts of unwanted spyware, PUPS, viruses etc etc.
We should support anybody trying to clear those things up.

I consider myself as reasonably experienced - but sometimes I've found it incredibly hard to get the actual download I'm after having navigated through endless traps of arrows etc to spurious links.

Note Torrentfreak is a perfectly 100% legitimate News site so no illegal software being offered. !!!!

Google Targets Fake Buttons - TorrentFreak

Cheers
jimbo

A:Finally Google to help stopping confusing download buttons on web site

This is good news. It has reached ridiculous levels on even legitimate download sites. I tend to stick to MajorGeeks.com because they test out the software and offer clean, easy to find download links.

Read other 0 answers
RELEVANCY SCORE 42.4

If anyone has acces to the connections/schematics for the M4600 touchpad/button assembly, I'd love to see them! For some reason both the right buttons have stopped working. Tried to disconnect/reconnect  the 14 pin "touchpad cable from the mainboard, but unfortunately this did not do the trick. Need to look a bit deeper - so would love to see the schematics or at least the pinout of the connector(s)... (It's a button - how hard can it be to fix... ;-)
Thanks and best regards,
 Anders

Read other answers
RELEVANCY SCORE 42.4

Several times now, when I start my computer, everything seems normal. But when I try and click on the start button, a quick launch button or a task bar button - NOTHING HAPPENS. I just get a ping sound from my speakers.
Sometimes a restart fixes the problem and sometimes I have to turn the computer off and then on again to get it to work correctly.

Does anyone know what could be wrong and what I can do to fix it.

Thanks

A:Start button / Quick launch buttons / Task bar Buttons - Problem

Is everything fully loaded when you are doing this?

Read other 5 answers
RELEVANCY SCORE 42

hello Im having an issue with my laptop , two days ago i turned it on and i dont know what did i pressed but a dailouge box appeared with two options ( yes\ no ) and i was in a hurry i think i cilcked on yes or maybe no i dont remmber but  since then my brightness keys f2 and f3 and my volume control keys f6 and f7 and f8 none of them are working i tried every single soultion in the internet now the screen is too bright and i cant control it i wish u could help me asap thank you

Read other answers
RELEVANCY SCORE 37.2

Sometime over the last few weeks Google's "More" drop-down and its "Search Tools" menu items have quit working in IE10. The other buttons that let you select web, images, shopping, etc. still work properly.

The "More" and "Search Tools" buttons get focus when the mouse is over them and they animate when clicked but nothing happens. I have Google Chrome and Apple's Safari installed and the buttons work properly on these browsers.

I've googled it but most of the posts found are about a not-quite-the-same problem of the buttons just working momentarily. At any rate, I tried the fix [clearing cache and cookies] that some of the posters said worked but it didn't make any difference.

I've disabled all of the ad-ons and the problem is still there. I re-enabled each add-on one at a time and tried it but none of them had any effect.

I've disabled my Norton Security Suite and the problem still exists.

I've reset IE and, other than losing all of my saved passwords, it too made no difference.

I think this might be a useful clue.

I noticed that for all of the buttons that are working, when I pass the mouse pointer over them it displays a URL down in the status bar. However, for the two that are not working nothing is displayed. It appears that the controls associated with these buttons either don't exist or are being blocked.

Does anyone have the solution for this, or at least and idea of what the problem is?

Thanks in advance for ... Read more

A:Google "More" and "Search Tools" buttons no longer working...

Hello Howard,

you can observe one thing here. All the menu items are just links. But More and Search Tools menu items are different. More is drop down menu and Search Tools also kind of drop down but with sub menu items.

So it seems like there are some script errors with your IE 10 browser.

But i am sorry, re installing IE is the only option i can suggest.

Read other 4 answers
RELEVANCY SCORE 36.4

Is there a formula or macro I can use to add all the cells C4 in each of the several sheets? I am thinking of something like in the old Lotus 123 Release 3. A simple syntax might be "Sum(Sheet1!C4:SheetN!C4"). Does anyone know how to use Excel as a true 3D spreadsheet?
 

A:MS Excel Sheets

Read other 8 answers
RELEVANCY SCORE 36.4

hey everybody,
is there anywhere that i can find a good tutorial on creating CSS Style Sheets. i have searched and have found plenty of VERY beginner ones which i understand pretty well but im loking for one that has some more advanced stuff like background pictures and stuff like that.

thanx
 

Read other answers
RELEVANCY SCORE 36.4

I can't write macros so your help would be appreciated.

I have an Excel Workbook with a Paid sheet and an Outstanding sheet both sheets have a File Number column.

I would like to create a macro that looks through the Outstanding sheet and if the File Number from the Outstanding sheet is also in the Paid sheet the entire row will be deleted from the Outstanding sheet.

I've tried copying some macros but I keep getting them wrong.

Please help!
Cheers,
Ang
 

A:Maro between sheets

Read other 7 answers
RELEVANCY SCORE 36.4

Hey ladies and gents,

Looking for your views on the uses of style sheets on a website, I have tried in vain to find a site that will explain to me exactly how they work and why I should use them so I thought I'd ask u guys!

Thanx for your help

Rutter
 

A:Style Sheets

Read other 9 answers
RELEVANCY SCORE 36.4

hi,
i have a problem in writing macro for comparing two sheets in a workbook in such a way
if first row of first sheet match with any row of second sheet then copy that row on another sheet and then if second row of first sheet match with any row of second sheet then copy it to third sheet
this process must continue till all the row compared one by one of first sheet with second sheet
means i just need to compare 1st row of first sheet with all the rows of second sheet then 2nd row with all then 3hird row and so on
please help me to slove this problem i have attached the excel file that have two sheets i want to compare rows of sheet 700days with sheet Nifty BB-1 Long 250 days 60min
 

A:how to compare two sheets

Please attach the file.
 

Read other 1 answers
RELEVANCY SCORE 36.4

I've got a macro, that I want to modify so that it reads the one worksheet, then makes global changes to all the other worksheets. I only know how to get it to update the single sheet specified sheets(2), but don't know how to get it to do updates to all the sheets.

Code:

Sub test()
Dim lrow As Long, i As Long
With Sheets(1): .Activate: Application.ScreenUpdating = False
lrow = Cells(Rows.Count, 1).End(xlUp).Row
For i = lrow To 2 Step -1
If Cells(i, 1) <> "" Then
Sheets(2).[b:z].Replace What:=.Cells(i, 1), Replacement:=.Cells(i, 2), LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True: With Cells(i, 1): .Value = Cells(i, 2)
.Interior.ColorIndex = 35: End With: End If
Next: End With: End Sub

 

A:How to look through sheets in Excel

Hi welcome to the board:
you can loop through all the sheets

Code:

Dim ws as worksheet
For Each wS In ActiveWorkbook.Worksheets
< your code here>
next ws

You will probably have to include a check to see if its the sheet you nedd but since you can code some thing I imagine you'll be able to work with the code above?
 

Read other 1 answers
RELEVANCY SCORE 36.4

Hello,
i've a problem when i open browsers (Firefox, Internet Explorer, Chrome). Randomly, after 1 or 5 or 10 minutes the browser open these pages:
http://2080.hit.buy-targeted-traffic.com/load/hit_1.php?source_id=2080&sub_id=&source_mk=1d0d9744
or
http://oziris.zerohorizon.net/
or
http://ptp24.com/promote.php?id=fb9a9b909e237b49be76aaa30d95d33a
I'm on Windows 10 Pro x64, i scanned with Roguekiller, Adwcleaner, Malwarebytes, ZHPCleaner, TDSS Killer, Hitman Pro, etc. (removing suspicious items) but nothing has changed.
Obviously i couldn't launch Combofix because it's incompatible. I also tried to reset all browsers, but the problem remained.
Can you help me to remove this annoying problem?
Thank in advance
 
Nicco

A:Pop up sheets in all browsers.

I post the results:  Results of screen317's Security Check version 1.008     x64 (UAC is enabled)   Internet Explorer 11  ``````````````Antivirus/Firewall Check:``````````````Windows Defender    WMI entry may not exist for antivirus; attempting automatic update.`````````Anti-malware/Other Utilities Check:````````` Java 8 Update 60   Adobe Flash Player     18.0.0.232   Mozilla Firefox (40.0.3) Google Chrome (44.0.2403.130) Google Chrome (44.0.2403.157)````````Process Check: objlist.exe by Laurent````````   Windows Defender MSMpEng.exe`````````````````System Health check````````````````` Total Fragmentation on Drive C:  %````````````````````End of Log``````````````````````

 Farbar Service Scanner Version: 26-07-2015Ran by NiccoloM (administrator) on 01-09-2015 at 12:00:14Running from "C:\Users\ross03\Downloads"Microsoft Windows 10 Pro  (X64)Boot Mode: Normal****************************************************************Internet Services:============Connection Status:==============Localhost is accessible.LAN connected.Google IP is accessible.Google.com is accessible.Yahoo.com is accessible.Windows Firewall:=============Firewall Disabled Policy:==================System Restore:============System Restore Policy:========================Action Center:============Windows Update:============Windows Autoupdate Disa... Read more

Read other 1 answers
RELEVANCY SCORE 36.4

In Excel I am trying to have sheets copied from one workbook (The Template) to another (The report) with VBa. The first sheet is copied to a new workbook, this workbook is than saved temporarely as report.xls, the 2nd 3rd etc... sheet is added to this new workbook.

For adding the sheets this is the code I use:

Windows("Template.xls").Activate
Sheets("Samples_Charts").Select
Sheets("Samples_Charts").Copy Before:=Workbooks("Report.xls").Sheets(1)
'
Windows("Template.xls").Activate
Sheets("Yearly Average").Select
Sheets("Yearly Average").Copy Before:=Workbooks("Report.xls").Sheets(1)
'
Etc.. this code is simply copied 50 times. It works fine for approx. 20 sheets but it won't add anymore sheets! Is there a maximum to the number of sheets that can be added to a workbook in a row?? I have workbooks with more then 50 sheets! Am I overlooking something? why is it performing well for 20 times or so and then quit?

Goosemark.
 

A:copy sheets

Hi there, welcome to the board!

The only limit in Excel as to the number of sheets is your memory available. If you're going to copy all sheets, why not just copy the workbook as another file (SaveAs)?
 

Read other 3 answers
RELEVANCY SCORE 36.4

I'm needing to unzip a batch of files and rename them in the process since they were all zipped with the same name. Is there some way to script commands like this in Windows XP like there is in Linux?
 

Read other answers
RELEVANCY SCORE 36.4

Hello,

Basically I'm trying to write a script to do a basic repetitive action.

I have endless amounts of files, but for examples sake, I will just say 3 files.

doc1 doc2 and doc3.

I need to create folders for those files so they are named doc1 doc2 and doc3 and in those folders are the relevant files.

I'm trying to write a script so I don't have to create a new folder then rename it doc1 then place the file in it, followed by creating another new folder, naming it doc2 then putting the doc2 file in it and so an so on.

This would save me a massive amount of time as I have to do this for 1000's of files.

So if anyone has any ideas of a script or anything that would give me something similar to do that I would be incredibly grateful.

Thanks
 

A:VB Scripting

I do not know about "Script", but I could point you in the right direction using Excel or Access VBA.
But I have to ask the question, why do you need seperate folders for each File?
 

Read other 2 answers
RELEVANCY SCORE 36.4

i use a small program from doug knox that allows me to remove past items from the system tray.it now opens up in notepad form.does anyone know the registry changes required to re-enable scripts.thank you.

A:VB Scripting

Here's my registry entry for VBScript files. Backup your registry first! Open notepad and copy the text below into it. Save it as vbscript.reg, run it, it will merge to your registry. Make sure you don't save as a .txt file.

Good luck
The Hooligan



Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\VBSFile]
@="VBScript Script File"
"FriendlyTypeName"=hex(2):40,00,25,00,53,00,79,00,73,00,74,00,65,00,6d,00,52,\
00,6f,00,6f,00,74,00,25,00,5c,00,53,00,79,00,73,00,74,00,65,00,6d,00,33,00,\
32,00,5c,00,77,00,73,00,68,00,65,00,78,00,74,00,2e,00,64,00,6c,00,6c,00,2c,\
00,2d,00,34,00,38,00,30,00,32,00,00,00
"EditFlags"=dword:00000000

[HKEY_CLASSES_ROOT\VBSFile\DefaultIcon]
@=hex(2):25,00,53,00,79,00,73,00,74,00,65,00,6d,00,52,00,6f,00,6f,00,74,00,25,\
00,5c,00,53,00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,57,00,53,00,\
63,00,72,00,69,00,70,00,74,00,2e,00,65,00,78,00,65,00,2c,00,32,00,00,00

[HKEY_CLASSES_ROOT\VBSFile\ScriptEngine]
@="VBScript"

[HKEY_CLASSES_ROOT\VBSFile\ScriptHostEncode]
@="{85131631-480C-11D2-B1F9-00C04F86C324}"

[HKEY_CLASSES_ROOT\VBSFile\Shell]

[HKEY_CLASSES_ROOT\VBSFile\Shell\Edit]
@="&Edit"

[HKEY_CLASSES_ROOT\VBSFile\Shell\Edit\Command]
@=hex(2):25,00,53,00,79,00,73,00,74,00,65,00,6d,00,52,00,6f,00,6f,00,74,00,25,\
00,5c,00,53,00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,4e,00,6f,00,\
74,00,65,00,70,00,61,00,64,00,2e,00,... Read more

Read other 3 answers
RELEVANCY SCORE 36.4

I have googled this some, but I don't believe I am really finding the answer.

What exactily is AD Scripting and what are some examples of things you can do with it?

I assume AD is active directory...

thanks for the help!
 

Read other answers
RELEVANCY SCORE 36.4

Now that I have found this site, I probably am going to show my ignorance to everybody in the world. You can only try to resolve a problem for so long. If you are forunate, you may find to others for support. Thank you all for being here.. I am continuously receiving an error message... ....Do you want to continue to run scripting on this page...... What is This??? I have just been applying "yes" but it seems to create more error messages similar to same mutiply. Maybe I should say "no". I plainly will admit, I do not know what I am answering. Could anyone PLEASE HELP!!!! I will surely try to return the favor.
 

Read other answers
RELEVANCY SCORE 36.4

okay, i havnt done much scripting for windows and by not much i mean, ive never done this before in my life. il figure it out as i go along. but i need to make a script that saves certificates from IE and saves them to users drives. was wondering if there was something in command line or powershell that i could use. any help is really appreciated
 

A:scripting help

Read other 12 answers
RELEVANCY SCORE 36.4

VB Script!!!

I need the program to check for even or odd numbers using VB script!!!

Like...i created a webpage with one text box and button. A number is to be input in the text box and when the button is clicked a message box should pop up saying if the number is even or odd....

I tried a lot but couldnt get the right one....

Hope anybody can help!!

Thanks in advance!!!....
 

A:Odd or Even..VB scripting!

This sounds like homework.

But I'll give you a hint. The modulus operator is your friend
 

Read other 1 answers
RELEVANCY SCORE 36.4

I'm having problem getting cgi scripts to execute in iis under windows 2k advanced server.I've tried everything i can think of but the script just times out.What does this mean? This is the url of where the script is at http://www.paradoxmusic.com/cgi-bin/admin.cgi
Do you have to have NTFS partition to run cgi files?
 

Read other answers
RELEVANCY SCORE 36.4

I need to attach the system date (prefix) to a file name on NT server to make it unique or historical. Can this be done using scripts?

For example: 100902.filename.txt
 

A:NT Scripting

Yes, very simple. Use the system variable %date%. Test the output of this variable and parse or use parameters to format as you would like.
 

Read other 1 answers
RELEVANCY SCORE 36.4

I apologize if I'm in the wrong spot and it seems trivial in the scheme of things, but it seemed as close as I could come. To put it simply...is there any quick or easy way to tell if you're the victim of .bat scripts? What started out as a joke in the workplace by some script kiddie no doubt has escalated into something more malicious. Slowing down production. I know it started with one because the first time it was in the form of a message ...a personal shot if you will. Now it's gotten to computer shutdowns, Blue screens, fake virus messages, etc, none of which seem to be real or harmful with the exception of work stoppage(maybe this has become the point). Well, anyway, is there anyway to find out quickly? I've searched the joke sites I could find and though they have loads of scripts they don't divulge how to rid yourself of, or find them before they're executed. Any advice is greatly appreciated.
Thanks, and have a great New Year!
doc

A:Possible scripting

If you know the person, may I suggest you contact the authorities?

Read other 3 answers
RELEVANCY SCORE 36.4

heres what i need to do:

make a calculator that does this...

formula: R=(((A/2)^2) + (B^2)) / 2B
(R = radius) (A = Chord Length) (B = Arc Height) h= height (1")

help would be greatly appreciated
 

A:Scripting help

Help will not be very helpful if you don't tell us what language you want to use...

In general, you need to prompt for values and then compute and display the result.
 

Read other 3 answers
RELEVANCY SCORE 36.4

I am running a Unix command from within a php script. (ls -1) I want the output to be placed in an array so I can verify some files. Any one know the exact syntax?
each line of the dir will be a location in the array.

Thanks
 

A:php Scripting

malcolmd3111 said:

I am running a Unix command from within a php script. (ls -1) I want the output to be placed in an array so I can verify some files. Any one know the exact syntax?
each line of the dir will be a location in the array.
ThanksClick to expand...

malcolmd3111,

There is a tutorial on PhP arrays at http://www.hotscripts.com
You will have to register to get access, but they appear to be free.

-- Tom
 

Read other 3 answers
RELEVANCY SCORE 36.4

I have a VBS script that can read the registry of a PC and report it's Microsoft office product keys. This script works for XP, Vista, Windows 7, Office 2003, and Office 2007. However, the script cannot pull office 2010 key, but a tool included with office 2010 (ospp.vbs) can be used to pull Office 2010 keys.

I'm asking you experts, how can I integrate the ospp.vbs script with my attached script to make the key report to the database.

I am an extremely novice to VBS syntax so much help is needed.

Please see attached vbs scripts.

Thanks,

IT_Core
 

A:Help with VBS scripting

Read other 15 answers
RELEVANCY SCORE 36.4

Is it possiable to create a script in Windows 7 that will enter commands into Command Prompt? And how would i go about doing htis?

A:Scripting?

Hello Kidfork,

You can use a BAT or VBS file for this. You would just type it in Notepad and save with one of those file extensions.

Hope this helps,
Shawn

Read other 1 answers
RELEVANCY SCORE 36.4

I just started studying IT earlier this year, but I am having extreme difficulty with one subject, AUTOMATE PROCESSES. We have been given some tasks that are due next week but i am still completely lost. Any help would be greatly appreciated. The tasks are as follows:
1. Write a script that asks for a number.
a. The script should then ask for another number, and another number, until the user enters the word ?quit?.
b. The script should then display the total of the numbers entered.
2. Write a script that asks for a number.
a. If the number is less than 50, the script should display the word fail.
b. If the number is 50 to 67, the script should display the word pass.
c. If the number is 68 to 82, the script should display the word credit.
d. If the number is 83 to 100 the script should display the word distinction.
e. If the number is any other number, the script should display the word invalid.
3. Write a script that creates a file. The script should
a. Ask for a folder name
b. Ask for a filename
c. If the file in that folder already exist, delete it
d. Ask for text from the keyboard to write to the file
e. Write that text to file
f. Save and close the file
4. Write a script that
a. Asks for a drive letter from the user
b. Displays the type of drive this is
c. Displays its state (ready or not ready)
d. Displays its serial number
e. If the user enters no drive letter, or presses Esc or Cancel, the script shou... Read more

A:VB Scripting in WSH

Sorry. We don't do homework help here. See the rules.

Read other 3 answers
RELEVANCY SCORE 36.4

Hello I am new here. I hope my question makes sense. I was wondering if anyone can tell me what this is and what it means.

"hideforkids="true" info ="msn:[email protected]@/settings/safety-personlinfo .htm."infotext=protecting your privacy">

contactUs IA "link(or /ink) not sure) ="[email protected]@/redir.htm.

I look forward to your responses. Thank you so much in advance.

rvsdaughter
 

A:scripting

Welcome to TSG!

I can't help with your problem but someone else might if you supply more information. such as;

1 What you were doing when this message came up,

2 Which program(s) was/ were in use at the time,

3 Does this involve something like MSN Messenger and/or parental controls?
 

Read other 3 answers
RELEVANCY SCORE 36.4

(Admin, feel free to move to more appropriate thread)

I wrote a script to download and update some files on my system when i was using my xp installation. It reads a list of URLs and descriptors from a txt file then downloads the files using wget for windows then looks up a key in the registry to tell where to extract the files to. The script worked fine under xp but under 7 it seems to fail when trying to lookup the registry key. I tried a couple of things to get it working but can't seem to figure it out, the attached file is the original version that was working under xp.

A:scripting

Hi smokes2345,

For reference, here is the code:


Code:
@echo off
set urlFile=addons.list.txt
set tmpFile=tmp.updater.zip
set computer=%computername%
set regpath="HKLM\Software\Wow6432Node\Blizzard Entertainment\World of Warcraft"
set regkey=InstallPath
if not exist cache mkdir cache
::reg query "%regpath%" /v %regkey%
echo REGPATH %regpath%
pause
FOR /F "tokens=3* delims= " %%a in ('Reg Query %regpath% /v "%regkey%" ^| find /i "%regkey%"') do set installDir=%%a
echo Installdir is %installDir%
pause
for /F "tokens=1,2" %%a in (%urlFile%) do (
echo Installing %%a to %installDir%\Interface\Addons\...
wget -N %%b -P cache )
start /D "%installDir%" Launcher.exe
for /r cache %%X in (*) do (
echo Inflating %%X
7za x "%%X" -o"%installDir%\Interface\Addons\" -y )
REM ::if not exist "cache\%%a.zip" ( move %%a.tmp.zip cache\%%a.zip ) ELSE ( if NOT "cache\%%a.zip" EQU "%%a.tmp.zip" ( move %%a.tmp.zip cache\%%a.zip ) ELSE del %%a.tmp.zip ))
::start /D "%installDir%" Launcher.exe
Looking through the code, I can see that it refers to the HKLM branch of the registry. Are you running the file as a standard user? If so, try running it in elevated mode. Right-click on it and select Run as administrator and provide administrative credentials. See how that goes, but I'm sure that a scripting guru will drop by soon.

Read other 3 answers
RELEVANCY SCORE 36.4

when i get on p/c and get ready to do something it starts scripting and loading porn stuff and as i try to close them they keep popping up and norton 2003 comes on and says computer is running scripts and suggestsb stop so i do and it says something about embedding where in win 98 do i go to get this stuff out of my computer. thanx for any help
 

A:scripting

Please do this. Go here http://www.tomcoyote.org/hjt/ and download Hijack This. Un Zip it and click on the Hijackthis.exe.

Click the "Scan" button when the scan is finished the scan button will become "Save Log" click that and save the log.

Go to where you saved the log and click on "Edit > Select All" then click on "Edit > Copy" then Paste the log back here in a reply.

Do NOT have Hijack This fix anything yet. Most of what it finds will be harmless or even required. Someone here will be glad to advise you on what to fix.

The log may reveal the source of the problem.
 

Read other 1 answers