I'm a small developer in VB6 and VB.net, and use for bugtracking a simple Excel. Seemed to me that I didnt need anything more.I've wanted to add links to the code. Then:How can I do it for vb6 and for vs.net?Is this reasonable? Should I change to a (free) bugtracking tool? Do they have this functionality?
View 1 RepliesI have a program that creates excel and word documents from another main Excel workbook. Essentially it opens excel checks data, posts data to appropriate forms. It then saves them as (number from main excel) & date/time stamp and corresponding extension. I want to be able to list the created documents according to the number from the main excel workbook.
[Code]...
I have a link here that works perfect for calling the postback close that I need to happen:
<a href="javascript:parent.__doPostBack('Close','')"><asp:Label ID="Label5" runat="server" Text="Close Me"></asp:Label></a>
However, I would like to be able to call the *javascript:parent.__doPostBack('Close','')* method from the code-behind file rather than the user clicking the link. I.e., when I have completed my tasks in the application code, call parent.doPostBack as my last function call, which closes the window in question.
I am using the given code to copy my database files...it works like a charm in debug mode but as soon as I create a setup, it stops working. The error is
"Database Detach Failed"
I tried checking the code line by line and found that the code does not enter the IF block.I have no idea why.
Public Sub bk()
Try
Dim strDatabasePath As String = My.Computer.FileSystem.CombinePath(My.Application.Info.DirectoryPath, "LIC.mdf")[code].....
I can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 RepliesI have Office 2007 on my system. The client has Office 2003 on his system. Is it possible to "link" to both versions of Office from VB?It only gives me the capability to reference to my Office version, I'd like to be able to make it fully compatible with both versions of Office.
View 9 RepliesIs there a way to show the line number of the line of code that caused an exception within a Try...Catch block?
View 5 RepliesI am using WebBrowser1.DocumentText to get a websites source code, and then parse a string. I am trying to view the source line by line, and doing it as follows:
[Code]...
However what is displayed is each character from the source code, rather than the line. I am making the client log into a website, and the needed value from the source code is then parsed, so I need to use the WebBrowser type to get the source code.
show me a simple code for downloading a file from internet with a URL,Line by Line with streamreader?
View 6 RepliesUsing VB 2010, i want to input data from vb and save it to access or excel. And then use data from ms files on another form in this vb project. How can I accomplish this?
View 2 RepliesI have created a spreadsheet with multiple worksheets. I would like, after checking one of several checkboxes (which I could change to another button I really dont care) taking me to another of the worksheets within the same file. What I don't want to happen is the original sheet to disapear so that I can't return to it via the tab at the bottom of the page if I need to.
View 1 RepliesHow do I link data in an Excel spreadsheet to a chart object in Visual Basic 2010? Really basic here, I just want to draw a single simple line chart from a single column of data. Is it easier just to read the data into an array (which I can do) and somehow get it into the chart?
View 1 RepliesI'm not sure if it can even be done, or if this is the proper place to post this question. I'm hoping that someone could give me a start in the right direction.I am looking for a way to link an Excel Spreadsheet to Microsoft Visio. I am envisioning this as an add in developed for Visio.To Summarize I would like to be able to list the steps of a process in Excel, and import the excel sheet into Visio. Finally I would like Visio to generate a flow chart based off of this imported data.I have developed a more detailed flowchart as to how I think this should work as well as a sample Excel sheet. The files are in a zip file which I would be more than glad to send to anyone who may be able to shed some light on the subject.
View 2 RepliesHow do I link data in an Excel spreadsheet to a chart object in Visual Basic 2010? Really basic here....I just want to draw a single simple line chart from a single column of data. Is it easier just to read the data into an array (which I can do) and somehow get it into the chart?
View 1 RepliesHow Do I update a data source link of an excel File from VB.net?I need to update data source links when saving an excel file. All of this through vb.net app
View 1 RepliesIf anybody is having code for comparing files line by line using vb.net.
View 2 RepliesI am exporting data from vb.net to excel and it is dropping the leading zero when its displayed on excel. How can I avoid the dropping of leading zero? I read the solution of adding a single quote but it makes my excel sheet column ugly. Also users will complain if they see a single quote on zip code field.vb.net code
Response.AddHeader("content-disposition", attachment)
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
the stored procedure outputs XML and it is transformed by XSLT before it is displayed on EXCEL
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<HTML>
[code]....
adding a single quote or manipulating excel sheet with column formatter (general/numbers ) etc. I don't want user to make any changes on excel to get the display properly when the excel is displayed from web page it should be all set with proper formatting. also we have no control over client excel software?
I use the following code snippet
Dim exlapp As New Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook_new As Microsoft.Office.Interop.Excel.Workbook
Dim strOriginal As String
strOriginal = Server.MapPath(Request.ApplicationPath & "/Attachments/") & "abc.xls"
xlWorkBook_new = exlapp.Workbooks.Open(strOriginal)
The code hangs in the last line. It works fine in the development environment. i deployed in windows server 2000 ,where I get this issue. the browser goes half way and throws the below exception after some time
[Code]...
I have set the identity impersonate to true in web config. This should be mostly an access rights issue.I have even provided access rights for the "everyone " user in the excel file and as well for the interop component. Please post ur valuable comments.
I have one excel sheet which has ontime event of 5 mins to run some code.This code works fine when in debugging mode. But if I lock my PC or minimize excel windows and start working something else, this code just pauses at beginning and as soon as I activate excel window, this code runs.this code involves opening and closing of one userform and i think userform is culprit.
View 2 RepliesI am uploading an excel file to my app and want to read it. Do I need to have excel loaded to read this?I am getting an error of Object reference not set to an instance of an object.
Public Function GetExcelData(ByVal ExcelFilePath As String) As DataTable
Try
Dim OledbConnectionString As String = String.Empty
[code]....
I have this string just down loaded of a Unix server. I would like to remove the box (0x0A) Unix end line code; then replace it with CR+LF normal ASCII code. Also, I would like to do the replace before I save the data, while it in memory.
View 14 RepliesHow do I enable a check_change for a checkbox in VB.Here is what I have so far.
Code Behind:
Protected Sub CheckBoxCash_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBoxCash.CheckedChanged
Label1.Text = "Cash"[code]......
I am not sure if this is possible, in VB is it possible to link to some piece of code in the current document?
View 3 RepliesI've got a webapp that displays data in a GrdiView and one of the columns I need to have a link displayed for the user to click on, which I've got just fine:
[Code]...
Does any one know what the code is to open a website link from a button =]
View 4 RepliesI thought only Microsoft employees would be able to upload here? >>[URL] Why then, is the UPLOAD link enabled for me? This dialog pops up when I click on it, but I am not a Microsoft employee.
[Code]...
I want my form to navaigate into a link then open up the source code of that page it navigated to . Then get a link from the source code then display it on a textbox .Here's an example : i want this link in a source code :
http%3A%2F%2Fanime-omnibus.ning.com%2Fvideo%2Fvideo%2FshowPlayerConfig%3Fid%3D3382149%253AVideo%253A160429%26ck%3D-
This link is located just beside :
config=
That is:
config=http%3A%2F%2Fanime-omnibus.ning.com%2Fvideo%2Fvideo%2FshowPlayerConfig%3Fid%3D3382149%253AVideo%253A160429%26ck%3D-
How can i make my form to navigate into the source code and get the link beside config word . I know it is possible to do it , just don't know the function to do it .
I've tried to incorporate this code in my app and can't figure out what the missing link is? Lotsa experimenting and head scratching later, I'm coming here to the forum for help. The dialog opens and allows me to select the file saved earlier,except the file doesn't open. I can't figure out the missing code which goes at the comment "insert code to read stream here." The code:
[code]...
does it have something to do with StreamReader.IO ?
I'm trying to click a link in an embedded browser based on the link ID. However, I keep getting a NullReferenceException error. I have not declased anything from the code. Just dropped it in from another website. Any ideas?
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted
For Each link As HtmlElement In WebBrowser1.Document.Links
If link.Id = "ctl00_mainContentArea_submissionFileListTable_ctl02_documentHyperLink" Then
WebBrowser1.Navigate(link.GetAttribute("href"))
[Code]...
I'm just wondering, how do i make a class link into my main code, it is in the same project so no need to reference it
Ive set up the the class and typed
code:
But they aren't linking/ working.