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 Rhinorhino 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: *

  • Users: AlexIT
  • Content: Threads
  • Order by date
  1. AlexIT

    Make Excel Visible

    Following up to a previous question I had, when I wshell.run "c:\test.xls" I create an instance of Excel that is not visible...in VBA I would add an oExcel.Visible=True. How do I do this in vbscript?? Thanks, Alex
  2. AlexIT

    WshShell.run works for some and not others

    As in previous posts I am using WshShell.run FileNm to open the file using the system settings. But this only works for some programs and not for others. I can open .pdf this way (opens with Adobe Reader) but trying an .xls doesn't open Excel, it does nothing. If I double-click the .xls it...
  3. AlexIT

    UNC naming in wscript.shell.run?

    I was using this: Createobject("wscript.shell").run FileNm but when FileNm = "//server/folder/file.txt" this fails with "The system cannot find the file specified" If I manually browse and double click the file it opens in Notepad correctly. So I cannot use UNC with the .run? Anyone else...
  4. AlexIT

    Script to open file with random characters and extension.

    I have a couple programs generating files into different directories...so I don't always know what extension they will be. Since they save as previous plus one (like log0001.txt, log0002.txt etc.) I had a script that worked in VBA when I knew the extension but now I want to use the users default...
  5. AlexIT

    Material shortage list

    Not new to SAP but for some reason I cannot remember how to generate a material shortage list. What I want to see is BOM like with quantity on hand: Main PN Plant SubPN1 Qty SubPN2 Qty " " Anyone know where this is?
  6. AlexIT

    Use ADO to change case in existing SQL Dbase

    I have not tried this yet, because I need to take the database offline to do it...but here is what I have put together: Set conn = New adodb.Connection conn.Open "DSN=ERP;" & "TRUSTED_CONNECTION=YES" statement = "SELECT DB_ItemID, DB_ItemName, DB_UnitMeasure, DB_Classification, DB_ItemTypeCode...
  7. AlexIT

    Insert array contents in messagebox

    I want to post the output of a portion of a string array into a message box. I was trying something like this: For j = 0 to endrow For i = 0 to endcol strOut = strOut & strArray(j, i) & (CHR(13)) next i next j msgbox(strOut) This only displays the last line...any ideas? Thanks, Alex
  8. AlexIT

    Output Multi-dimensional Array to Excel Sheet

    Here is a snippet of the code...pls note this must be in Excel 2000 VB. I know I am making a simple mistake: Dim vMain as Variant Dim vComp as Variant Dim xcel as Object Dim sht as Object Dim i as Long Dim j as Long Set otherapp = CreateObject("Other.Application") vMain = File.GetData For j =...
  9. AlexIT

    Scripting a web-query

    Many years ago, we matched our small parts inventory item numbers to that of a big supplier of such items. If they sold a screw as P/N98010A541 this is what we would use in our inventory system. Good idea at the time as everyone knew the numbering system and could immediately identify the...
  10. AlexIT

    Firewall now blocks VPN

    I have been running a Symantec VPN client on my own equipment from inside many different networks, just using the client's bandwidth to reach my own servers while visiting. They have given me permission to do this. Now, one client has patched their firewall and I can no longer access my VPN. I...
  11. AlexIT

    Hidden Computer

    I was asked a question I thought I'd post here: Is there a way to have a hidden computer on the lan? (i.e. can you use the name$ to hide the whole computer, not just the shared directory?) I didn't think the dollar sign would work, but anyone have another way? The purpose is to have a PC...
  12. AlexIT

    Undelimiting a cell

    I keyword searched and found a few good script examples to create a cell merging other cells and using a specified delimiter, but I have a single cell being generated by an outside system that I need to split into multiple cells by the delimiter...note this is not a file imported to excel, but...
  13. AlexIT

    Forward spam to local congress critter?

    Anyone know how to setup a server side rule in Exchange5.5 to forward mail by filters? I want to ship off all the V!agr8 and such to our local representative because he voted no on the spam legislation... Just kidding, but seriously can a server-side rule forward mail selected with the text...
  14. AlexIT

    AD Script: change computer local admin password & disable local guest

    I got started with this in another thread and I am not sure where I went wrong...I am looking to call an AD script from our login.bat file to change the computer's local admin password and to disable the computer's local guest account. I am doing this so each time any machine is used to log into...
  15. AlexIT

    Similarly to another couple posters

    Similarly to another couple posters, I have a SLOW macro to compare cells in one workbook against cells in another...I mean this kludge takes 5 hours to run on a fast machine. Could someone point out the many ways I've programmed this worng? Sub Comparison() Application.ScreenUpdating...
  16. AlexIT

    XP Networking Browse Problem - Not the same old Questions!!

    Ok, I am a 10 year veteran of M$ networking. I am not stupid, but I am stuck about this one: Remote office, one XP Pro, One Win2K Pro and Netgear WGR614 connecting them. Both machines are connected wirelessly sometimes and wired other times. I have checked, rechecked, deleted and re-entered...
  17. AlexIT

    Script for file copy

    I was trying to script a file save operation to create copies of a closed database on a periodic basis: set tm=%tm::=-% set dtt=%dt%%tm% xcopy C:\folder\folder2\maindatabase.mdb z:\folder\folder\backup\"database-%dtt%-%tm%".bkp I plan to schedule this for multiple backup copies...
  18. AlexIT

    Dynamic DNS?

    OK, I am really stumped here now! I put four Win2K servers (AD/DNS/DHCP, Exchange, Mail Marshal, OracleDB) behind a Raptor firewall to host a remote AD domain. I have the raptor set as the default gateway, and using its DNSd service, it is now the forwarder for the AD/DNS server, which has...
  19. AlexIT

    I am working on a new network confi

    I am working on a new network configuration. We put four Win2K servers (AD/DNS/DHCP, Exchange, Mail Marshal, OracleDB) behind a Raptor firewall to host a remote AD domain. I have the raptor set as the default gateway, and using its DNSd service, it is now the forwarder for the AD/DNS server...
  20. AlexIT

    I am working on a new network confi

    I am working on a new network configuration. We put four Win2K servers (AD/DNS/DHCP, Exchange, Mail Marshal, OracleDB) behind a Raptor firewall to host a remote AD domain. I have the raptor set as the default gateway, and using its DNSd service, it is now the forwarder for the AD/DNS server...

Part and Inventory Search

Back
Top