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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VPN Gateway
I need to set up a VPN gateway at my parents house in UK. Dont want to use software on PC as I never know if the machine will be on or not. So looking at VPNrouter / Gateway Main usage is to trouble shoot the network / machines and mayb a little web surfing (UK IP address) So far thinking of...- uprichard
- Thread
- Replies: 1
- Forum: Virtual Private Networks (VPN)
-
finding offset within text for a given pattern
I have a large string (upto 900,000 characters). I need to search it for a given pattern i.e. "The dog sat on the mat" and then work with each part of the string. The string search string can appear in multiple places and I will need to get each sub section of the string. I thought of using... -
calling function using variable as its name
I need to be able to call a function depending on the contents of a variable i.e sMyVar = "Func_To_Call" call sMyVar Where the above would call "Func_To_Call". In other languages I could use the eval statement. Can it be done in VB? I would also like the function to be in a side file that...- uprichard
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Read range from excel into VB program
I have a workbook that has a number of sheets that each contain named ranges. I want to be able to pull out all the data that is contained within a given named range. I use the following to return a single cell Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSh As...- uprichard
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Keeping track of IE Windows
I create an IE browser window using the following: Dim oIE As Object Set oIE = CreateObject("InternetExplorer.Application") If oIE Is Nothing Then LogEntry "Could not invoke Internet Explorer Object" Exit Function End If oIE.Visible = True Set GetBrowser = oIE Set oIE = Nothing I...- uprichard
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Trying to save excel gives msg about RESUME.XLS
I have updated some cells within Excel workbook/sheet but when I issue a Save I get the following message "A file named RESUME.XLW already exists, do you want to replace it" My file name is "resource_list.xls" where does the above come from? Here is my code Set... -
How to write to excel sheet/cell wusing VBA
I have a .xls file that contains a number of sheets. I want to write to a given cell in a given sheet. How do I do this Thanks, -
Functions: variable parameter list- is it possible?
Did you ever get an answer to this? -
How to detect that program is running on Win2000
I need to detect which OS the perl program is running on. I can not use $os = $ENV{'OS'}; as that returns Windows_NT Any one know how to detect the correct OS? -
Checking status of a fso.movefile, fso.copyfile etc
I have a script that I use to perform filesystem functions. Is there anyway to check the status that comes back from the call? I know I could do a check to see that a new file exists after a copy and that the file does not exist after a delete etc, but that seams very long approach... -
Returning whole row from Excel
I have been able to return one cell at a time from excel using a=ExcelSheet.ActiveSheet.Cells(Row_Number,2).Value But can I return the whole row into an array? Also does anyone know how to change the active sheet that the data will be pulled back from. Thanks for any help -
counting entries
The code below reads a csv that contains a number of lines ie. "Agent","Complete","2" "Agent","Complete","3" "Agent","Open","1" "Blar","Complete","2" The first column is the... -
counting entries
I am reading data from a CSV file and after each read I end up with an array containing the data ie. $array[0]="HTM" $array[1]="complete" $array[2]="1" I want to be able to create variables that counts the number of times that a certain combination of data is... -
HTTP request timeout too long using IP address that dose not exist
Thanks that fixed it. -
HTTP request timeout too long using IP address that dose not exist
I am automating testing of a Network Load Balancing product. Part of the script needs to get a page from a Virtual IP address that has been setup. Everything is fine if the IP got setup correctly but if not the following bit of code take 15 minutes to execute on my Linux box, which is way to... -
Client / Server script required
I need a way to control a number of machines (Linux and Windows) from a central machine (Windows). So I am looking for a Client / Server setup. The central machine should be able to issues commands to the other machines (Only require it to talk to one machine at a time). It should also be...
