I have an application that automatically updates addins for excel from the server to all the computers on our network. right now all i get is an error if excel is open, but what I want to be able to do is check if excel is open on each computer first and give the user a chance to save their current work then close excel. otherwise i cannot update their addins if excel is open.
View 3 RepliesPart of an application that I'm building searches the network that the current computer is connected to and returns a list of the IP & MAC addresses and the hostname. It is based largely on the post by richard__deeming at [URL] At the moment, it will only get the information about computers that are in the same workgroup, but I have several computers that need to be shown, that are joined to a domain rather than the workgroup. How can I get the program to find every computer on the network?
View 2 Replieshow to program an application that scans the computer in the network in vb.net?
View 3 RepliesI am writhing a program to replace a file in network computers. but the problem is in our network there is 32 bit systems and 64 bit systems. There are different files to be replaced for 32 and 64 bit systems. I have written a program to replace the file.if we give the target of the location (eg \drd001-dsk1C$Documents and SettingsAdministratorPlayerfilename where drd001-dsk1 is the computer name in the network) Is there any way to check if the system that i need to replace the file is 32 or 64 bit
View 7 Repliesam trying to get the IP address of all of the computers on a network. I know how to fetch the names of the computers on the network but I need to fetch the IP address to. I have a listview control with 2 columns 1 for the name of the computer (1st) and another column for the IP addres (2nd). I have the code so can the IP address be displayed in column 2
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
ListView1.Items.Clear()
[code].....
How can i get a List of all Arivable Computers in my Network/Workgroup ? I need to add all to a Listbox
View 7 RepliesI wonder how do I list all computers on the network with vb 2008?I know to do in vb6 I have no more sense in vb 2008.
View 2 RepliesHere is my Prob- we have a main router from which we use a distributor or hub for internet connection distribution, ever computer connected automatically obtains IP address of format say - 180.50.50.xxx to access net connection.if any connected computer has different IP format than the given one, it cannot access internet.
View 1 RepliesI need to write a program that can be distributed over a network of 400 computers and that can be updated if necessary. How do i do that with VB if i can at all? What should i learn?
View 2 RepliesI want to develop a process that will monitor computers that logon to my network. Gather information such as computer name, time of logon and log out.The process would be located in the icon tray?
View 3 RepliesI need to write an app that transfer files and folders to others computers in my network vb.net.
View 3 RepliesI am trying to write a program to ping computers on my network to see if they are turned on. So far i have the following:
Code:
If My.Computer.Network.Ping("192.68.0.5") Then
MsgBox("Computer is on.")
Else
MsgBox("Ping request timed out.")
End If
If i use ip addresses, this works fine but i would rather use hostnames due to the ip addresses being dynamic (something which is outside my control). Using the hostname, it reurns "Computer is on" if the ping is successful, but if the hostname cannot be found, instead on returning "Ping request timed out", an error occurs as follows:
A first chance exception of type 'System.Net.NetworkInformation.PingException' occurred in System.dll
I have recently finished a console application and deployed it to several computers on our network for testing. As it is just an EXE a copied to the hard drives of selected computers for now. When the app is launched it writes info to an sql DB so I always know which computers it is on.
During the past few weeks I have modified this app at least 6 times (improvements, adjustments, etc)
It is a paint to keep going back to the computers to update it with the new version, and getting mixed up which version i am on - LOL I am looking for advice on how I would go about doing this automatically, for example, it would be cool if I just had to put an updated file in a repositry and clients would use this to update.
In Visual Studio, when I view the properties of my application>assembly information - I can set a file version. Is it possible to extract this info and store it in a variable? I would like to dump the in my DB. Also I could then possibly compare the file version of the launched app against an updated file in a network share folder.
I have created a program that allows me to remotely access computers on my network (not all done by me i found some code online) however i want to modify that program to allow me to connect to computers not on my network. How can i go about doing this? My program consists of a client and a server. When the server runs it listens for the client on the client side i enter the IP address and it connects so i can send remote commands to the remote system.
View 4 Repliesi m new in .net programming i am wanting to develop a network application by which i can watch the screens of other computers connected in LAN,i can give permissions/privilages to other users.
View 5 RepliesMy issue, however, is connecting to the wireless laptops as well.
[code...]
I need to grab a list of all networked computers, and I definitely include systems on the wireless
network in that list. I'm just not sure how to approach this. Being able to enumerate through a
'tree' of all networks and systems available would be a major plus.
how can I determine if there is network traffic?I would like for example to show how fast the network traffic goes or to add a flash using a picturebox to animate the network activity
View 5 RepliesHow do i determine the network name of my computer?
View 2 RepliesSince it will be run by the user I don't want the user to have to do anything but send the IT department the log file it creates.
What I want to do is see if a folder on the network can be opened successfully. I do not want to ping it, but actually open it and see if it loads. I can do this for a website by retrieving the http status code, but I can't find any references to something similar for explorer.exe. Here is a basic flowchart of this part of the program:
ping server --yes--> access \server_namefolder
--no--> access \server_IPfolder
--no--> Authentication Issue
--yes--> DNS Issue
Note also that just checking authentication won't work because it could also be a DNS problem. I guess I could check them both, but I would rather do it this way if possible (and I don't know how to go about checking either one)
Im coding an application that needs to list all computers inside my LAN, and get the status of the machines ex. Power On, Power Off.. in order to Wake On Lan, or Turn it Off.. im using Visual Basic .Net.I all ready listed all machines, now i need to get the status of them..
View 5 Repliesi am using a tabcontrol with close button.i have 4 tabpage and i call each tabpage through menustrip.
MainTab.TabPages.Add(TerminalPage)"for tabpage1"
MainTab.TabPages.Add(Attendance)"for tabpage2"
MainTab.TabPages.Add(Multimedia Projector)"for tabpage3"
MainTab.TabPages.Add(Conversation)"for tabpage4"
i can open and close it without any problem. my problem is that how can i determine if the tabpage is already open? bcoz for example if the tabpage1 is already open, clicking MainTab.TabPages.Add(TerminalPage)"for tabpage1" this will add another tabpage named terminal page.
My program has many forms that can be launched from the main form, and when launching a form, I need for my program to know whether or not there is already an existing instance of the requested form open before it launches the requested form.
So, if I have form "Search" with button "View" that launches form "Details", I need to know if the "Details" form is already open when the user clicks the "View" button.
Apparently, if I had developed my application as an MDI application intead of an SDI application, I could just do "If frmDetails.visible = True then DoStuff()", but the Details form's Visible property always comes back as False, even when the form is already open. If the form is always being reported as not being visible even when it is indeed visible, what method do I use instead to find out that the form is open/visible/in use?
I am currently using the FileOpen method wrapped in a try/catch block to determine if a particular Excel file is currently in use or not.
When my app tries to access the file, I would like to be able to notify the user who it is that already has the file open. If I try to open the file in excel while it is in use, the message that Excel provides includes the network login of the user that has the file open. Is it possible to get this information via code so that I can tell the user of my app the login of whomever already has the file open?
I want catch excel file close event
Like this :
if Xapp.exit = true then...
I am developing a new shell for a windows project using VB2008.
I would like to open the network IP properties for the Local Area Connection, in order for the user to change the IP address for the computer.
I have done some research, but can't find any way of doing this through Process.Start("RunDll32.exe", "shell32.dll,....... like I have done with the other items I needed from the control panel, and the information I do find tells me to use the INetCfgComponent::RaisePropertyUi.
Unfortunatly I have no idea in how to use this function from within VB....
I have Visual Studio 2008/VB application that opens Excel workbooks, reads all the sheets, and writes some data to a SQL database. I need an easy way to determine if a sheet has any data on it. By default most books has three sheets (Sheet1, Sheet2, Sheet3) and usually, but not always, my books have data only on sheet1. But i need to look at alal sheets to check for the existence of data. I know I can do a nested for loop from 1 to columns.count and rows.count, but that would take a good bit of time since those numbers usually are something like 256 and 65K.
Is ther some easy way to determine if there is any data on the sheet? If there is, is there an easy way to find the "first" cell with data in it?
I would like to open the excel file after create the excel file. The creating file function is done, but the system unable to open the excel file. My coding as below:
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim misValue As Object = System.Reflection.Missing.Value
[code]....
I'm trying to export a datagridview to Excel and open the Excel spreadsheet (not SAVE the worksheet).
Public Sub ExcelRpt(ByVal DgvName As GridView, ByVal url As String)
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet
[code]....
I have a VB.Net App that on ButtonRun_Click open Excel to get the "tab" and "column" then another buton that past content from textboxes. I get a "COMException was Unhandled" If I reopen excel it's in use.
Private Sub ButtonRun_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonRun.Click
Dim MyExcel As New Excel.Application
[Code]....
I have an application the contains several excel files bundled with it. I'm not opening the files and processing them within my application. These files contain a data-connection to reload all of the pivot-tables within each excel file. I have a 'link' on my form, that when clicked, it determines which file to open and calls a sub using filename and executing Process.Start(filename) for any excel file I want to open. I have no problems opening any one of the files and then exiting excel.
The problem is when I 'close' a file, but don't exit Excel; then try to open another file(clicking link on form)... it creates a new instance of Excel.
I know from experimenting that the fileopendialog form will 'reuse' an existing Excel instance, IF it does not already have a file open.
How can I do the same thing without using the fileopendialog?
I don't want the end-user to have access to the folders where these files live. That's why I have multiple 'links' on my form, one for each xls that already exists. I just want them to be able to click on a link and the xls file opens AND if they choose to merely 'close' a file and not exit... Don't create a new instance of Excel, but re-use the existing one.