Search results for query: *

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

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...

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...

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...

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?

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...

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

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...