Deploy VB Code To The Personal.xls Spreadsheets Of Other PCs On The Network?
Apr 20, 2010
What is the easiest way to deploy VB code to the personal.xls spreadsheets of other PCs on the network? This is a server network, not peer-to-peer.
View 2 Replies
ADVERTISEMENT
Jun 30, 2009
I have developed a visual basic app in Visual studio 2008. I have created a windows installer file. Can I deploy this on a network drive and does .NET framework have to be installed on server? The application has a MS access database associated with it, so I would like to have it backed up via the network.
View 1 Replies
Aug 17, 2009
I have my vbnet application with sql server express designed for individual desktop pc. Now I want to have it work on a network.
1_ how can I make my customer to install sql express and the Database on the server and enable the network protocols seamlessly? dont want to have my customer configuring sql expess manually. 2_ how can I have my client software to look for the sql express and connect to it in a seamless way??
Can I avoid the customer to enter configuration data?
View 7 Replies
Nov 17, 2009
I've created some functions / procedures with VB.NET and want to deploy them to a SQLServer. Within Visual Studio you can click right and select "deploy". An assembly will be created on the server and a lot of functions and procedures. It's really easy.Now I want to script the whole deployment process. What is Visual Studio doing when I make a deployment? Can Visual Studio autoscript all the deployment steps for me? Can I save it to a file and execute it manually?
View 1 Replies
Apr 6, 2011
My project that I had built used spreadsheets and charts within the forms to provide the user with the necessary data. This worked fine for VB2008 as it had all of the ActiveX office web components built into it. It seems that VB2010 has a different set of base components and emphasis office 14.0. I was wondering how people have gotten around this or if they can. I tried using DataGridView, but it doesn't seem to be able to do what I want to do. I need the ability to have users enter data into a table and then use that information to be able to build graphs real-time based on their data.
View 2 Replies
Jan 24, 2011
I am trying to write code that will compare the information in all row(one column) in the two spreadsheets and if they are not the same update another column on the row with a difference with Updated. but i am getting this error
countExcel = xlsSheet.UsedRange.Count
first_index = 1
last_index = countExcel
[code]....
View 1 Replies
Apr 11, 2011
I have a directory with 1600+ excel spreadsheets, all of which have one row of data located in row 2 which I need to get into a single spreadsheet for importing into Access.
View 1 Replies
Aug 18, 2009
Here is my idea so far: I have a bunch of computers connected in a local network. One of them is a MySQL server, one will have a vb.NET program wich will act as a "second server" and the rest will be different clients. What I want to do is that the "second server" will send out some kind of message or network package to some of the clients in the network, and they will execute a code based on what message it is, or what kind of package it is. I'll give you a simple example:
[Code]...
View 6 Replies
Jan 27, 2012
Has anyone successfully transferred data into Excel with multiple spreadsheets?
View 2 Replies
Mar 18, 2010
I'm trying to use the ComboBox items to reference specific spreadsheets at location 1 and copy them to one singular spreadsheet as location 2.
oExcel = CreateObject("Excel.Application")
myDirM = "L:DC Productivity ReportTA Temp"
oBook2 = oExcel.Workbooks.Open("C:TestBook1.xlsx")
[Code]......
View 5 Replies
Aug 15, 2011
I have produced some VBA in Access that creates a spreadsheet.I have also created an SQL query that retrieves records from an Access table.I have 48 tables (each table for a specific institution centre).I have created another bit of VBA code that creates a spreadsheet and loads the records from the query in to the spreadsheet.Each centre has a unique Sequence Number (Indent Number)At the moment though, all I can do is import one table (records for one institution) in to a spreadsheet. I want to end up with calling the function and having an output of 48 spreadsheets being saved to my desktop, each spreadsheet containing records of a different center.I have thought about putting a loop in, but not sure how I would quite go about it.
Here is my code to create the spreadsheet:
Public Sub ExcelExport(lngIndentNumber As Long, strFolder As String, strCrit As String, strReport As String)
', ctlLabel As Label,
DoCmd.SetWarnings False
[code]....
View 2 Replies
Jan 12, 2009
I am trying to write a simple program which will simply have buttons to open spreadsheets, and a search facilities to look for spreadsheets with a title which is an invoice number. I have my basic forms layed out, all a need now is help with the code.
I am using Visual Basic 2008 Express, and just need a line of code for a button to open an application/spreadsheet. Also, is it possible to have a search box open a file automatically?
View 9 Replies
Sep 20, 2011
Can anyone convert these C# code to VB.NET
NetworkChange.NetworkAddressChanged +=
new NetworkAddressChangedEventHandler(NetworkChange_NetworkAddressChanged);
[code].....
View 4 Replies
Mar 4, 2010
find a source code of using a local area network(LAN) in visual basic.net 2008?
View 1 Replies
Oct 1, 2010
Basically, if you go to Start and click Computer and then click on the Network link on the left hand side, you'll notice on the right hand side several categories, one of which is titled "Network Infrustructure", in that category, my router is listed, and in my case, it is "LINKSYS WAG160N Wireless-N ADSL2+ Gateway" and when you right-click and select properties, it lists basic info such as internal/gateway IP address, on mine it is "192.168.1.1" I would like to know how to retreive this information in code, preferably a Windows API so that i can call it using a legacy VB6 app. Also, even if you just know a .NET version or a Delphi version, please do list that as well as i can code in both. However, the answer i'm ultimately seeking is a method to access this via VB6 so that would probably be a WinAPI call (will upvote & select this as answer), however, other methods are also welcome incase i can't find a legacy method (i will upvote these).
View 3 Replies
Dec 8, 2010
For a school project we need to visualise a computer network graph. The number of computers with specific properties are read from an XML file, and then a graph should be created. Ad random computers are added and removed.Is there any open source project or algorithm that could help us visualising this in VB.net? Or would you suggest us to switch to java.
Update: We eventually switched java and used the Jung libraries because this was easier for us to understand and implement.
View 1 Replies
Jun 7, 2012
I would like to ask something about Network in VB.NetI try to search network code sample to produce VB.Net application (Like Server and client)But I found a lot of codes (Server and client) and the codes are very complicated for me because codes are mixed with chatting process So I would like to know or want some sample Network VB.Net application(code) the application has two forms
form1(server) and form2(client)
form2(client) has (one button or textbox)
form1(server) can make visible or invisible (button or textbox) of the form2 (Like that code, I can able to make or learn other processes) I want to know how to code it. If I can get the code, I can learn more smoothly with various way
View 2 Replies
Jun 7, 2009
Dim fs As New FileStream("C:Womanizer2.m4a", FileMode.Create)
Dim writer As New BinaryWriter(fs)
Dim reader As New StreamReader(networkStream)
'Dim send As [Byte]() = reader.ReadBytes(fs.Length)
[code]....
These are two code blocks from the two programs I have wrote. The first is the server program that receives a connection and writes the file to disk. The second is the Client program that sends the file to the server to be written to disk.As it is - it hangs. I did once get it to write to the disk - but the file was twice the size of the original. what objects to use for transferring a file over a TCP IP network connection with TCPClient and TCPListener.
View 3 Replies
Aug 24, 2010
how to write code on network programming that is window based. most of the code i read are console application.
View 4 Replies
Jun 19, 2011
ok i am working on a dvd ripper for my self i am trying to figure out the source code to rip a dvd i am also wanting to put a video converter in the dvd ripper
View 3 Replies
Aug 10, 2011
I have 2 clients connected via a server program.When 1 client hits an arrow key, a picturebox moves on client1 and on client2.Before adding this network functionality, the picturebox on client1 moved fast with each click.Now, there is a delay of like 2-3 seconds.I know the code isn't optimal, but i'm not a networking wizard.What i'm doing is when pressing a key on client 1, it passes a text to a textbox in client 2 which then has the picturebox move in client 2 depending on the text.The slowdown occurs on client 1, which is odd because the picturebox isn't directly connected to the network code.[code]
View 3 Replies
Feb 4, 2010
I am a new member that has just start coding. Im currently working on a small application for a desktop that will give me information from my system. I have code that works but might not be great. I have code that checks that the network is connected but need it to keep checking and updating. I Have tryed loops, goto and timers but not having any luck. Can anyone help point me in right direction. Here is my code so far.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text = TimeOfDay
Label8.Text = "Time :"
[CODE].........................
View 2 Replies
Oct 23, 2010
I'm sure a lot of people around here tried Rainmeter or Google desktop. They are nice but I never felt comfortable using them on my desktop, either because they ate too many space or aren't much flexible in terms of settings and stuff that can be grabbed from the Webs. So I thought I'd make my own personal tools. It's intended for Windows 7. What language, VB or C#, should be easier to implement this kind of stuff (small panels with no borders/frames, small memory usage if possible) based on experiences of people?
View 2 Replies
Oct 15, 2011
I have created an ASP.NET Website using VB.NET ASP.NET 4.0. Thing is, I want my visitors to hear some nice piano music as they browse my site. Now I don't know how to embed and play mp3s on an ASP.NET Website. So I need help with that.Further, if the website visitor changes pages, music should pick up where it left off before the page change. how to do this?
View 1 Replies
Jun 10, 2011
I coded a small application in VB Express 2010 and I wish any one could provide for me some code on how to save personal settings from an options form so that the end user don't have to keep making their personal choices every time that start my application that I created.
Personally I don't have a clue on how to accomplish this feature with in VB Express 2010.
I used check boxes and radio buttons in the options section on a form for the end users choices.
View 7 Replies
Aug 4, 2010
I've been looking at accessing shared folders, read and write, via the network without being prompted by the OS for the username and password.
On this forum, and googling, I can find many things about accessing network shares, but none using code which also passes the username and password required.
What I'm basically looking for is to not have to map a drive on the users computer. Then using code, write or read files from a network share and at the same time pass the username / password required for that network share.
View 11 Replies
Oct 10, 2009
I am planning to write a recipe storage program for personal use. I know what I want to do, but I am not perfectly clear on the most efficient way to do it. I am using SQL server 2005 and I am comfortable writing stored procedures. This is one of my first vb.net projects and I am still getting comfortable with ADO.net.What I want to do is create a form that can handle an list of ingredients of an unknown number.
The form will also accept a cooking procedure of an unknown number of steps. Each step will be written by the user into Rich Text boxes (vb 6 term?)I am planning to use combo boxes to select ingredients from a list or add new ingredients as needed. I also want to eliminate duplicates in the ingredients table of the sql 2005 db. I am looking for the most efficient method to save all the parts of a recipe to the database. saving a recipe will require dozens of database hits and therefore be unacceptably slow.
View 1 Replies
Oct 8, 2010
I have a personal website that I want to see when the last post was made to it. Is there a way to find the last posted date on my blog?
In my application, I have a notification that I want to fire if we've made a 'News' post on our site so that our users are aware of any issues and I figured the best way would be to see when the last post was made.
View 2 Replies
Apr 28, 2010
I am using window 7 now, I am trying to write up a wee program by vb.net to edit the image properties like edit the title, author, comment, rating, description. I have try the DSOFile, but it only edit the file attribute and wouldn't show up.
View 3 Replies
Mar 17, 2011
Just knowing 20 commands i am developing a app?very impressed on myself!Just knowing 10 commands + common sense + special sense each man has i had world most dangerous spy tool....but on my guru & best friend advice i dropped it..but in future will use for good purpose So here is the new scene We are team of workers had blogs,microblogs and other things i decided to create a tool for my self which is like office assistant to assist in our work at office
my tool will do the submission process when we are not in our office
my idea is using a web browser control and do it with vb commands
so kindly think yourself in such position do you agree to do submission task with web browser control or you can do it some other methods?
whats your opinion? what i mean open a website on web browser control submit the details from listbox(which increment on every submission)i think you now got how we are going to do this!!!
so i am need some one advice shall i proceed with this?i had three big challenges
1.Time
2.Yes Of Course Time
3.Ya Time But Time + Work Accuracy
so kindly guide shall i use the web browser control or use method like direct server post?
View 1 Replies