im trying to edit an existing excel file. some cells were merged but after saving the file, all merged cells were unmerged again. Here's my code
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
[code]....
First off let me just say i have imports for the excel and office applications. I am using office 2007. I am hoping someone can show me what I am doing wrong here.
I have been searching and researching for a few days now on formatting excell cells within the VB code. It works for most objects such as bold, font size, where i want to place the data and what I want contained in the cells.
I have been using the VBA within excel (macros) to determine the code i should use to format the cells, however, The underline feature doesnt work correctly as with any justification of the cells. or merging. I can't seem to make many of the format options work and am wondering if they are slightly different or if i need a few more code lines so that when i declare something like this...
CODE:
I get an error, xlcenter is not declared. I cant declare it as a string i just recieve a com error starting it couldnt be done.. I am stuck on how to get by these so called "undeclared" command strings that i need to format the cells properly.
I am looking for a way that on the form I am designing , there will be a section that displays an excel type spreadsheet that stores rows of similar information as show below.
length(mtr) width(mtr) height(mtr) cubic weight(kg) physical weight(kg)
eg. 0.15m 0.25m 0.35m 3.38kg 5kg I need the spreadsheet to allow the user to select rows and the form can have command buttons to allow then to delete selected row, etc. But I dont want to have it that the system this program eventually runs on to need to have excel actually installed on the system.
I am writing a windows application that interacts with data stored in an Excel Spreadsheet. I merely want to change the text value of a cell that already has text written in it.
View 2 RepliesI need to open a .xlt for editing, like so:
System.Diagnostics.Process.Start("Template.xlt", "Editable=True")
But I don't know the correct switch in Excel. This is the same as right-clicking on an .xlt and choosing "Open", whereas the default action is "New".
I have created a program in vb2008 that when first run will make all the required regisry changes it requires by creating a path in the registry.
View 10 RepliesUsing vs2008 9.0.30729.1 SP. Inserting a new record works but editing a record doesn't. Tried databindingsource but no joy as well.
Private Sub Gr1A_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Gr1D.CheckedChanged, Gr1C.CheckedChanged, Gr1B.CheckedChanged, Gr1A.CheckedChanged
sAns1 = ""
If Gr1A.Checked = True Then
sAns1 = "A"
ElseIf Gr1B.Checked = True Then
[Code] ......
I have a datagridview, 3 textboxes, 1 NumericUpDown and a button.What I want is that when the user clicks the button, the current row that is selected in the datagridview will change to the values in the textboxes and NumericUpDown.
View 4 RepliesIs it possible to disable editing a combobox. With a textbox you have the option readonly. Is there something like that for the combobox?
View 7 RepliesIt gets some links in a listbox, And i had to create a new ListBox for because i only want to keep some items, So i got this.[code]But i had to do a new listbox for it, I dont mind that, But the problem is, It creates duplicates, I've tried making it delete the item from the first listbox after it was added to the new listbox, But it is not edible during the process structure so i thought i could get some help here because im getting so many Duplicates of 1 item.
View 8 RepliesI can add new data to the database and have it saved and everything (though my method not be great, but it works) but I'm having a hard time figuring out how to edit existing data and save it. assume it would be better to have it check whether or not the row exists, and if it does, just update it rather than trying to insert new rows? This is the code I have right now to
Dim newRefractiveRow As EyeBaseDataSet.Spectacle_RxRow
newRefractiveRow = EyeBaseDataSet.Spectacle_Rx.NewSpectacle_RxRow
With newRefractiveRow
[code].....
I have one CheckedListBox called cListBox, and I have one ListBox called ListBox.In my cListBox I have, for example:IDS_PROPITEM_TXT_011131Space Cadet Set for male characters comes complete with hair piece, Space Fleet Uniform, hands, and boots.IDS_PROPITEM_TXT_011141Space Cadet Set for female characters comes complete with hair piece, Space Fleet Uniform, hands, and boots.It is ALWAYS the case that you have IDS_PROPITEM_TXT_somekindof6longvalue (TAB seperator) some kind of text.
View 2 RepliesI have this code here:
Public Declare Function RegSetValueEx Lib "advapi32.dll" Alias "RegSetValueExA" (ByVal hKey As Integer, ByVal lpValueName As String, ByVal Reserved As Integer, ByVal dwType As Integer, ByVal lpData As String, ByVal cbData As Integer) As Integer
Public Declare Function RegCreateKeyEx Lib "advapi32.dll" Alias "RegCreateKeyExA" (ByVal hKey As Integer, ByVal lpSubKey As String, ByVal Reserved As Integer, ByVal lpClass As String, ByVal dwOptions As Integer, ByVal samDesired As Integer, ByVal
[code]....
But when I execute it it doesn't correctly change the value of the DWORD from 0 to 1, it creates an invalid value.
I have problem, when i click on save it gives me an error.'Cannot perform '=' operation on System.Int64 and System.String.'My code looks as follow....
vb.net
Private Sub ItemsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ItemsBindingNavigatorSaveItem.Click
[code].....
I've been searching in google for some time now and i've just found answers like "Resources are embedded in the exe so you can't retrieve the path" and other answers which are complicated and not even explained how to use the code. ~~However my problem is that i have a .txt resource file in my resources and i want to edit the content of the file so i triedIO.File.WriteAllText(My.Resources.MyTextFile, "some string")but that didn't work out since [My.Resources.MyTextFile] retrieves the content/value of the resource so what i want to do is edit the resource file simply, from within my application, not by going to My Project > Resources and from there, edit the file
View 1 RepliesNot sure if I'm posting this in the right area, but here goes anyway. I've been working with sql databases for practice, but can't seem to get around one thing; after I add it as a data source, I can't go back and add tables.
I start off by going through the project, then add item, choose the service-based database, and go from there. I add the tables, then go in and add it as a data source.
After I've added it as a data source, I can go back into the .mdf form and add lines and edit properties, but it wont update in the data sources. So, I can't add it to the form.
I must change the textbox value of a form a thread that is located on an other module. I've already tried with the CheckForIllegalCrossThreadCalls to False on the onLoad event of the textbox's form but it doesn't seems to work because everytime the thread executes the lines that should change the textbox value nothing happens at all (not even a warning). I really don't want to use that "safe cross threading" with delegates and stuff because it's too much trouble for me, I don't know how to use it and I just have one thread on my project and it's the only control that is accessing those textboxes.
View 2 RepliesI reopened my project to edit it but it is only showing the code not the design I cant get it back how do I do it?
View 3 RepliesCan VB 2008 use the system variable %1 that contains what filename a program was opened with? I am making a new app that when you click a .exe file and select the right option, it will edit the registry but I need to be able to keep the filename that I right clicked on so that I know what registry value to edit, is this possible?
View 1 RepliesWhat im trying to achieve is editing the value of this key; But I've tried everything i can think of.. I've tried just entering the name and type etc. but nothing..I've decalred:
Imports Microsoft.Win32
and the code im attempting to use:
Dim regKey As RegistryKey
[code]....
What i want it to do is create a key from the Drive Selection box i.e. 'H' then create two sub keys called 'DefaultIcon' and 'DefaultLabel' and assign values to their (Default) key but its not working.
i have written a c program for calculating some financial task It accepts the input file name or path name from the user processes it and displays the output in 6 output files. i want to execute the same c -source code using visual basic .net.I want to know how to compile the c source code and execute it .
View 3 RepliesI know this is doable in C++, but I have no idea if it would be doable in VB.NET/C#. This is the C++
DWORD ModuleHandle = ( DWORD ) GetModuleHandle("Module1.dll");
int AddressToEdit = ModuleHandle + 0x12345;
BYTE Buffer[1] = {0x00};
WriteProcessMemory(GetCurrentProcess(), (void*)(DWORD)(AddressToEdit ),&Buffer,1,0);
Is it possible to edit the memory of a Processes' module?
I have a text file called: list.txt This is a list with all kind of lines like this:
14II_ARM_S_CLO_CLO_CLOVERIDS_PROPITEM_TXT_01194611IK1_ARMORIK2_CLOTHIK3_CLOAK=TRUE==200050000====PARTS_CLOAK=1==11=1===11_NONE Ofcourse every line has different numbers and letters.
The complicated bit is this:
I want to let Button1 check whats in TextBox1.Text and search "list.txt" for it. When it has got a match (there is only ONE of these numbers in list.txt).For example TextBox1.Text = "IDS_PROPITEM_TXT_011946". And I search for that so I find the line above. Now I want 3 other textboxes which show the 21st, 22nd, 23rd column/number after "IDS_PROPITEM_TXT_011946". And they should be editable by changing those 3 textboxes and clicking the apply button.How can I best do this, and please give a little example.
I have a datagridview hooked up to a bindingsource. I have a comboboxcolumn. Now, I only want the combobox to be visible if a new row is being added. Otherwise, that column should not be editable. How can I achieve this. If so, on what event should I add code.
View 10 Replieshow to code memory editing software? Like they use to make game trainers...
View 3 RepliesEdit 1: Uninstalled & Reinstalled Edit 2: Same problem. Seriously? Yes.I am having a problem with msvb7.dll eating 50%+ cpu on my dual core system. This usually lasts 10-30 seconds or so, during which time the IDE is non-responsive.
This occurs when I do pretty much anything in the text editor, and can be replicated by simply adding blank lines to a function, and then deleting them. Or pasting some code. Or... lotsa stuff.
SP1 installed I had DevExpress' refactor/coderush, components, and codeit.right installed, but have removed all 3 of them. (I had installed the latest version of Refactor Pro! (9.3.4), perhaps the day before)
I have tried a VS.NET Repair. There is a kb that referenced some cpu destroying with vb, but it was included in SP1
[Code]...
Trying to use a str = Replace, but having issue. Seems that after it does the first string replace it will not let go of the file or the Dim or something???
'Make first file
Private Sub MakePwdFile()
Dim fso, inputFile, outputFile
Dim str As String
fso = CreateObject("Scripting.FileSystemObject")
'1 means for reading
[Code] .....
i have used this code to insert information into microsoft access database.however i dont know how to edit information from vb.the coding is below:
Private
Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
Public objword As New Word.Application
objword.Documents.Open(FileName:=ofilename)
^ Showing the declaration of the word document that i wish to edit.
Dim oDoc As Word.Document
objword.Visible = True
oDoc = objword.ActiveDocument
oDoc.Range.Text = codes(j, 1) & " " & codes(j, 2)
This gets the document and adds text into it, exactly what i want it to do. But it replaces the whole document. I just want it to add text at the start of the document. Not replace the whole document.
New to VB.NET Programming. Im trying to set the dates pickable on a Date Time Picker to the current day and onwards, i do not want someone to be able to chose DateToBeShipped to yesterday for example.
View 7 Replies