We want to create an makro who change all cells who has an hyperlink ex." \serversubsub3example.pdf" to \newserversubexample.pdf. All cells have different pdf´s who they are link to. Not alls cells have hyperlink.
View 1 RepliesI have a spreadsheet with Proj Numbers: "049410-001" in column B6:B60. I have the URL to the Database: I want the links to show up in the A column with the Tag being the Proj Number "049410-001".
Also, if I could clear the A column and use it "A column" to enter the Proj Numbers and then run the Macro to enable the Hyperlinks I could eleminate the Proj number taking up 2 columns. I have 80 rows set aside for projects so it needs to go through and enable the links that have text in them.
i used =HYPERLINK(E24,B105) (E24 was another wasted cell that combined the static first part of the link, and the proj) as the formula way to do it, but I'm trying to make a Macro that does it behind the scene. but I am just getting into VBA, and I have no idea what i'm looking at when I look at a code.
In my page there is a fileupload control and a gridview. When I upload a file, the DocName and the path of the saved file will in the gridview. I put the filepath in a hyperlink field so that it will show "View file"(not the path). My problem is - the gridview is showing "view file" text when there is no file saved.It works fine when I upload a file.
GridView :
<
asp:GridView ID="gvFile" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataSourceID="odsrcInsertUpload" Width="552px" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal">
[code]....
From a macro I am accessing a command that is on the toolbar:
Dim name As String = "Macros.MyMacros.MyMacros.ToggleExceptions"
Dim cmd As EnvDTE.Command = DTE.Commands.Item(name)
How do I now change the caption of the command on the toolbar? It does not seem to have the necessary properties. Do I need to cast it to something else?
I have a richtextbox in a form. I would to insert in this richtextbox a hyperlink with a text that will appear in the box, and a web address(hidden) that will open by clicking on the link. what is the correct code rtf to do this?
View 9 RepliesI have got the code to create a Hyperlink in a richtextbox, I'll share it with you but to the experts, I have a question...
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dim newlabel as new linklabel
newlabel.Text = HYPERLINKNAME.text
newlabel.AutoSize = True
[code].....
I need to somehow get the NEWLABEL THAT THE PERSON CLICK!
I am trying to hide Hyperlink visibility in Repeater if there isn't any Text value in Hyperlink. Something like this:
Protected Sub rptReferenca_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles rptReferenca.ItemDataBound
Dim lnkThumb As HyperLink = CType(rptReferenca.FindControl("lnkThumb"), HyperLink)
[Code].....
Oasically outlook express now uses windows search to keep a count of emails sent. Whenever you get to 100 it forces you to manually compact them.
There is however a counter in the windows registry which can simply be set back to zero. I was wondering if i could create a macro that would load on windows startup that would reset the counter automatically in the registry whenever it got past say 75.
I just read little bit about macro and was trying to create the one in .net I was able to do very small operations since I dont know much about vb.net and regular expressions.I want to create a properties and variable declaration for the below code.What will be the regular expression to parse this string. So that I can get all the components to create a property from this.
,<Status, tinyint,>
I am trying to create macro that can parse above string into
private byte _Status;
prublic byte Status { get; set; }
How to create a macro recorder that will save each and every keystroke, like the one in MS WORD, and save the saved keystroke in a database, and it will allow user to assign it a hotkey to paste the saved data anywhere in e.g. text editor, emails, etc!
View 5 RepliesI am using Excel 2003 and I am wanting to create a simple macro in order to run a for loop and then have the information output the numbers to cells.
Sub ForTest(i As Integer, j As Integer)
For x = i To j
y = Rnd
Next x
End Sub
This is my code. Now how can I print my x values to the A column and print my y values to the b column so that they line up as a pair of coordinate points.
As a follow up to my previous question Putting together a tricky SQL query
since I now have the records returned as URL format, how can I display those as hyperlinks in my gridview? (this is how the client wants it done, not much I can say to change their mind)
My vb code is:
Dim pds As PagedDataSource = New PagedDataSource()
GridView1.DataSource = pds
GridView1.DataBind()
How do I write a macro that opens a folder and calls a previous written macro to update the files within the folder?
View 2 RepliesI'm have a program (GUI) that interfaces with excel to execute macros. We're using Microsoft.Office.Interop.Excel to call/run the macros and this works great.What I can't figure out is a good way to cancel the macros from the GUI.One idea we had was to use the excel.application variable that runs the macros to write a "stop" value to a specific cell in the workbook, and in the macros (they are all mostly loops), check for the "stop" value in that cell. This crashes my GUI with this The program '[2188] BVLReports.vshost.exe: Managed' has exited with code -336589910 (0xebf00baa).And excel gets tied up, and won't respond. I know how to Exit Sub from within the macro if the "stop" value exists, so I don't need answers on how to check/cancel from inside the macro. Any ideas on a better way to write this "stop" value or a better way to cancel the macros externally?
View 2 RepliesIs it possible to change the forecolor if individual cells depending on its value (for instance changing from Navy to Red if negative in currency columns?
View 1 RepliesI am trying to create a form that will update a database of school tests with checkboxs.Basically, i have a textbox for a student id, a combobox with the subjects in it, and a datagridview with the tests of the selected subject.(There are about ten subects with about ten tests each).What i want to happen is when you put in an id number, it should bring up all the tests the student passed in each subject in the datagridview. So when you select a subject it will load the datagridview with the tests (in a checkbox format) (with the tests he already passed checked) so you can click and add tests and then save it to the db.
View 7 RepliesI using Microsof Visual Basic 2008 Express Edition. I need to create a form like: 2 buttons are open and save existing .xls file which each generation can choose a different.2 textbox that can be entered on the column
and last button to when choose two columns, to find duplicates values and mark different color same values. Is it possible?
At the moment Excel file opens, but the comparison does not require the introduction of the columns
I'm trying to change a range of cells on the SS to be checkbox type.
View 3 RepliesI have a Windows Form that contains a DataGridView. The DataGridView ReadOnly property is set to TRUE. The DataGridView as 3 columns. I would like to make the cells edible (ReadOnly=False) when the RowHeader is clicked. I thought that the following code would do it, but when I click on a RowHeader and then click in one of the cells in that row, the cell is still ReadOnly.
Private Sub dgvData_RowHeaderMouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles dgvData.RowHeaderMouseClick
[Code].....
I tried to convert the date format in all cells DGV in column(7) from "dd-MM-YYYY" to "yyyy-MM-dd". So I create this code but I don't know how to complete
For Each row As DataGridViewRow In Form7.DataGridView1.Rows
If row.Cells(7).Value = "dd-MM-YYYY" Then
........
End If
Is it possible to give individual cells in a data grid view row different styles such as backcolor, fontcolor etc?
I do not mean giving the whole row a new style, only a specific cell.
i tick a check box in my datagridview, the cell in column 3 of the same row will change colour? this needs to apply to all check boxes and corresponding cells.
View 5 RepliesI am trying to create a macro to enter data in a label printing application for hundreds of labels- I use an external third party software that's not very user friendly. It has several fields that accept text. The problem is, manually entering the data and clicking "print" each time is very time consuming. Can anyone suggest a way to put a line of text in the field, printing, and repeating the process?
View 15 RepliesI am trying to change the font color of cell(s) that are selected by the user. So, the user highlights the cells, then presses a button to change the font color. I tried using datagridview1.selectedcells, but couldn't figure it out.
View 8 RepliesIf i have a DGV where i change the color of some of the cells like this...
DataGridView3(0, 1).Style.BackColor = Color.DimGray
DataGridView3(5, 3).Style.BackColor = Color.DimGray
DataGridView3(6, 0).Style.BackColor = Color.DimGray
is there a way i can change the entire DGV back color to something else (including those cells)i tried DataGridView3.DefaultCellStyle.BackColor = Color.Indigo but that does not seem to work on the cells already colored. Im guessing this is because im only changing the default cell color?
I was looking for some code that would change the colors of some rows in my datagridview but I could not get that to work. I have this code which should work but it doesn't, I could not find any replacements. I need to change the color of some rows.
Do While cnt > -1 If datagridorder.Rows(cnt).Cells.Item("DataGridViewTextBoxColumn16").Value.ToString.Substring(datagridorder.Rows(cnt).Cells.Item("DataGridViewTextBoxColumn16").Value.ToString.Length - 5, 5) = "Cease" Then
datagridorder.Rows(cnt).DefaultCellStyle.BackColor = Color.Red
End If
cnt -= 1
Loop
I'm trying to dynamically create a listview. on reports.aspx user selects a bunch of checkboxes. On the next page, user sees reports.aspx, and should see a table with columns of the checkboxes he selected. My idea was to create a listview, then dynamically change the header row of the LayoutTemplate, then change the select statement depending on which columns selected. This is what I have:
<asp:ListView runat="server" ID="ReportListView" DataSourceID="ReportListViewSDS">
<LayoutTemplate runat="server">
<table runat="server">
[Code]....
Problem is that this doesn't work because i can't put a code block (<%%>) inside the LayoutTemplate. Is there a way in the code behind to edit the LayoutTemplate, or another way to cycle through the Request.Form vars and build the table header row with it?
I have a question with jagged array, every element can contain strings, be empty or be nothing.
I would like to create a jagged array and put some strings into its cells.
Public Sub S1 ()
Dim MyArr(7)() As String ' OK
MyArr(1) = New String(8) {} ' OK the second cell contains 9 subcells
[Code].....
I want to auto fill a range like this:
In Sheet1!A1 i have the formula "='Sheet2'!D1"
In Sheet1!A2 i have the formula "='Sheet2'!H1"
In Sheet1!A3 i have the formula "='Sheet2'!L1"
Now the Sheet1!Ax increments with +1 value; The Sheet2!D repeats again with D, H, L but only with a +4 to all 3 of them
[Code]...
I am converting a VB6 app to VB.NET The VB6 starts Excel to create a report.On several cells, the VB6 code does this:
[Code]...