Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GomezAddamz

    "No Disk" error when checking network drives

    No, I do not. I presume it's inside the "For i = 0 to WshDrives.Count - 1 Step 2" as that's the only time it would be accessing the D drive. I only use "On Error Resume Next" during the actual mapping, and then I use it to report if there are any errors with the mapping. I turn it off right...
  2. GomezAddamz

    "No Disk" error when checking network drives

    Hello! I have a script that will check network drive mappings and create/modify them as needed. The problem is that some users are getting the following error: "There is no disk in the drive. Please insert a disk into drive D:." There are options to Cancel, Try Again, and Continue. None of the...
  3. GomezAddamz

    Help I am trying to Run a VBScript inside VBScript

    I know you said prnmgr.vbs is working, but it sounds like that's where the error is coming from. What happens if you type 'cmd /k cscript prnmngr.vbs -ac -p "\\COL-FPS01\cae_adams"' into a run prompt? Or 'cscript prnmngr.vbs -ac -p "\\COL-FPS01\cae_adams"' into a command line? What if you put a...
  4. GomezAddamz

    HTA: Wait for event before continuing script

    I realized I was using faulty logic. I was thinking in terms of "VBS OR HTA", when I needed to be thinking in terms of "VBS AND HTA". I kept the main VBS script, and wrote a separate HTA to handle the user selection. I'm calling the HTA with WshShell.run with "Wait on Return" set to "True". The...
  5. GomezAddamz

    text file to excel + filter

    As far as looping through the files, check out the Files Collection on MSDN.
  6. GomezAddamz

    text file to excel + filter

    Per MSDN: The first time you save a workbook, use the SaveAs method to specify a name for the file. Info on SaveAs method: Link Note that's for Office 2013, but I presume it's valid for at least 2007+. I'm glad to see you can do that with VBS. I was going to point you toward using VBA.
  7. GomezAddamz

    help with script

    First off, you're deleting a directory and then trying to create a shortcut in the deleted location. My experience has been that VBS is not smart enough to know that it needs to create the directory before creating the file and will, instead, throw an error (which you will not see b/c you've...
  8. GomezAddamz

    script for clear type

    Just a guess, but it may be you're trying to use a keyword as a variable name (I noticed char 32 is the T in Type). Try using more specific variable names and that may clear the error (e.g. regType).
  9. GomezAddamz

    HTA: Wait for event before continuing script

    Thank you very much for the feedback. I'm sorry for the poor explanation. I know I can use events to trigger subroutines, but what I want to do is have a subroutine wait for an event before continuing. I was hoping to keep this simple, but it seems some context is needed. I'm working on a...
  10. GomezAddamz

    HTA: Wait for event before continuing script

    Hey forum! I'm looking for a way to make a VBS script inside an HTA wait for input before continuing execution. Specifically, I have a dynamically populated list box from which the user will need to make a selection and then click a button before the script can continue. I know I can use the...
  11. GomezAddamz

    XMLHttpRequest in IE and Chrome

    In the end, I switched to using an HTA w/ VBS. My main goal was to get it working in IE, but it seems that IE 8 doesn't support the File API I needed to use. I experimented with XDomainRequest, but that didn't look very promising either. Here's the final code, in case you're interested! <html>...
  12. GomezAddamz

    XMLHttpRequest in IE and Chrome

    I changed tack in my search and quickly found that IE and Chrome had built-in utilities for this (F12). Seems that IE is getting an access is denied error on the 'open' command, and Chrome is getting a "Cross origin requests are only supported for HTTP" on the 'send' command. Looking into those...
  13. GomezAddamz

    XMLHttpRequest in IE and Chrome

    As far as I can tell, it just stops running the script. I get the "Request!" alert box in IE and Chrome, and I get the "Open!" alert box in Chrome only. Neither IE or Chrome makes it to the "Sent!" alert box. It doesn't seem like the script is stuck, it seems more like the script has stopped...
  14. GomezAddamz

    XMLHttpRequest in IE and Chrome

    Hiya! I wrote a simple JavaScript to parse a CSV file into an HTML table. Works great in FF (23), not so much in IE (8) or Chrome (35). It seems like the XMLHttpRequest is gumming up the works. IE will create the request, but doesn't seem to want to open it. Chrome will open it, but chokes when...
  15. GomezAddamz

    Excel 2007 - Convert list of data to table

    Okay! Took a bit of tinkering, but that looks really good! Thank you! I should probably mention that the 'Fundamentals Of Relational Database Design' in the FAQ is a dead link.
  16. GomezAddamz

    Excel 2007 - Convert list of data to table

    Hello! I have a question regarding Microsoft Excel (I'm using 2007). I have data in this format: Store 1 Store 2 Store 3 Apples Cherries Apples Grapes Strawberries Blueberries Bananas Bananas Grapes Blueberries Tomatos that I would like to put into this format: . Store 1 Store 2 Store...
  17. GomezAddamz

    Different results from same if statement in VBA/Excel

    If Format(A - B + C, "hh:nn:ss") = Format(D, "hh:nn:ss") Then That got it! Thanks! AFAIK, Excel stores dates and times as doubles, with everything to the right of the decimal representing the hour, minute, seconds, and everything to the left representing the day, month, and year. I still...
  18. GomezAddamz

    Different results from same if statement in VBA/Excel

    I'm having trouble with an Excel VBA formula and have isolated the cause. I have a worksheet with the times 17:00, 13:10, 4:10, and 8:00 in columns A, B, C, and D respectively. In column E, I have the excel formula "=IF(A1-B1+C1=D1,"True","False")", which returns "True". In column F, I have...
  19. GomezAddamz

    Excel 2010: Seeking help to improve my macro and coding skills

    Thank you very much! That is very helpful! Regarding the 50 files, it's a bit hard to explain, but simply put, my department was asked to help out with this project. We won't be using these files, we'll be creating a file for each of about 50 different groups for them to use. A lot of the...
  20. GomezAddamz

    Excel 2010: Seeking help to improve my macro and coding skills

    Hey forum! I've written a macro for Excel 2010 for work. It's perfectly functional. It does everything I need it to and it doesn't have any problems. It is, however, clunky. At least it seems that way to me. I'm pretty new to VBA (for Excel in particular), and am interested in getting better. I...

Part and Inventory Search

Back
Top