i would like to know how to automaticaly save a given chart from an excel 2007 file into a given folder with a given name ^^i have already got the vb sending the data i want to the excel, and with macros within excel to make the line chart in the excel file..
View 1 RepliesI'm using VB Express 2008 and I would like to open an excel file and save it with different name file. For example, I would like to open a file in
C: est.xls
And then I want to save them with different file name such as
C: ry.xls
I have a chart in Excel that I'd like to use a subtitle on. There is no SubTitle Property on the chart object, so I looked in the Excel User interface and found that you can only create a sub-title by using a text box. The text box looks like its associated with the chart, not the worksheet, so how would I access that text box from code?
View 1 RepliesI am trying to sort out how to save or export a excel chart to a jpg image. this is what I have so far, but is obviously not working.
Private Sub ButtonJPG_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonJPG.Click
' Export chart as picture file
[Code]....
I am trying to show my excel chart in visual basic listbox and it does not work. I have added the reference of microsoft.office.interop.excel in my code i have put the range of column "A" and i do not know how to change the range to where the chart is in the excel.
Here is my code!
[Code]....
I have attached the excel file screen shot if that can help in any way...So basically When i click on the button in VB than it should show me the excel chart. My code just shows me the column "A" which shows me the "data" column only from the excel file.
with the code to my form on week numbers. below is what i have on my form code at the monent. and where the text in green is
View 11 RepliesHow can i save my data into a pdf Using visual basic?
View 1 RepliesI need a code that will hide a folder and if i wanted to find that folder i could click a button and it would be vissible again.
View 1 RepliesI was wondering what is the easiest way to save and load data through different forms in vb. I just want to save 3 textbox.text that a user saves and be able to load it o
View 16 RepliesI am building a business intelligence application for my organization. I have a form in which I would like to display existing excel spreadsheets. I have searched high and low for a control that would allow me to display a spreadsheet. Basically what I need is a viewer control that I can user to call the individual soreadsheets and display them in the form.I do not want to open excel outside of the application, but instead display the spreadsheet in the form as part of the application.
View 3 RepliesI am trying to build an app that can search column A in an excel document (with textbox control). In column B, I have info about the column A items. When a column A item is searched, I would like a textbox (or similar) to display info about it from column B.
View 6 Repliesim trying to design a program where a user inserts text into some text boxes, and selects an item from a dropdown box, and clicks add, i want it so when they click add, it puts the data from the text boxes into an excel worksheet, so say, textbox 1 is product, put product in A1, the second would be cost so put the cost in B1, but the product type in C1(this is the drop down box) and then clear the visual basic form, so the user can enter a second set, and then when they click add, it adds the information into A2, etc, etc.
View 2 RepliesI have written a program that will export data from access data to Excel by using XML programmatically, But I seem to be having problem when I tried to open in excel.
View 2 RepliesMy project is using Visual Basic 2010. I have a pure text save file with the following format:
num_TEC|1
num_STR|0
num_PER|0
num_MEC|1
num_KNO|1
num_DEX|1
I'm trying to load the data by using the first column as the object name and the second as the value. I've had some success with the following (skipping some basic IO lines):
prop = FileReader.ReadLine().Split("|")
tempvar = prop(0)
If TypeName(Me.Controls(tempvar)) = "NumericUpDown" Then
Me.Controls(tempvar).Value = prop(1)
I have a problems with this because I have some objects in panels or group boxes and Me doesn't reach into them.
Is there a way to just strictly reference an object with a variable? I'd love to assign the first column into prop(0) and just say
if TypeName(object(prop(0))) = "NumericUpDown" then
object(prop(0)).Value = prop(1)
trying to save the settings in a settings form but every time m setting the settings (when the form is running) then exiting it and then reopening itare the settings that i setted not there Ex : I open form2 by clicking on a button thought form1 and change the settings for example i uncheck a checkbox then do i close form2 and then open it again. And the settings should be saved so the unchecked checkbox should still be unchecked.BUT when i close form1 should the settings be unsaved and go back to normal :)
View 3 RepliesI have yet another Problem with the save button on my form. After filling out all the textbox's, Selecting the date from dateTimePicker Selecting comboBox's Items I get an Error message saying: "Column 'JobID' does not allow nulls". "(I thought this ID column Inserted a number automatically").
View 5 RepliesIn visual basic code works as below MyWorksheet.Range("A1:D1").Formula = "A1B2"
In excel it shows in
A1 as A1B2
B1 as A1B2
C1 as A1B2
D1 as A1B2
what i want do
A1 as A1B2
B1 as A1B3
C1 as A2B4
D1 as A2B5
I have to write an application in Visual Basic.Net that will open an excel file, run through the contents an export a test file for processing.
The application works great for me (Windows 7) but when transferred to a WinXP PC gives the following error: HResult 0X800A03EC
I can replicate this error by making the Excel Application visible so it seems like it is an issue where it can't access the file because it is open. Error occurrs when trying open the workbook.
Original Code
Dim excel As Excel.Application
Dim wb As Excel.Workbook
[Code].....
Im trying to add an export import method in visual basic. Export from Access database to Excel Worksheet or .csv. And Import From Excel worksheet or .csv to Access database
View 3 Replies[code]....
View 12 RepliesI'm trying to save a setting that keeps what background image I'm currently using.If it's an external file, there is no problem, i can just get the .location and set it in a String setting to store it.
But, if I want to store an image resource as a setting, how do i do it?I know i can store rawdata, like bitmap information, but then i can't set that type of data to the my.background.
I don't know if the question should be: "how do i reference resources", but the my.resources.resource.methodsList doesnt contain anything that seems to be of use.
How can I save the design page of the form? I can only save the code
View 1 RepliesI am working on an virtual operating system. And I want the user to be able to change background, and at the same time save it! So, the next time he opens the application, the background is saved and changed.
I know that I have do this through project > settings, but I don't know how to program it. I have managed to allow the user to change background, but dont how to save it. Could anyone solve this little problem for me?
my chart loads data from a datagridview. how can i automatically update my chart with new data if new values are inserted into the datagridview.
[Code]...
I need to save the contents of a picbox to a jpeg file.I suspect the error exists because I do not actually load an image, but draw lines on its using picbox1.addline(), but I do not know how to fix this.
[code]...
at the Moment in my code I have the words("C:PrivateWords"). and that is where the Username & Password is Stored/kept, But is there a way to store the Username & Password into the Programe. ect... in a form that only the owner of the programe can see. And what would you use on that form ie: listbox, textBox multiline, TableLayout Panel, that if it is possible to create a Form.
and would the code be something like The Altered code Below the code Below:
Public Class CreateUser
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
[Code].....
I have created an excel 2003 file using visual basic 2010 express edition with access as backend. The excel is created using a select into query. I would need help to protect this excel file once it generated using visual basic 2010 so that the users cannot edit the same.
View 1 RepliesI am trying to read off some cells from an Excel File. I can't figure it out. Here is my code:
Public
Class TOC
Dim ExcelObj As New Microsoft.Office.Interop.Excel.Application
[Code]....
After making WorkSheetObj I dont know what to do.. I am trying to dynamically change the Texts of Four buttons. The text values are to be to read off of Excel cells.
We are testing the visual basic 2010 ee in one of the computing suites at a secondary high school. The installation was fine When we tried opening or saving a project it saves it into a default location i.e my documents. The problem withthis is pupils dont have access to c:. They their own drive on the network (h:) where they save their work. When i went and changed the settings in VB in tool > options.
View 3 RepliesI am a student and trying to start a programming career, my colleague asked me to make a multi tier or multi client desktop application for the schedule tracking using xml as a database; however the desktop application would be deployed in one or more computers but my leader can monitor the info from her office in addition she wanted me to put administrative privilege to avoid unauthorized access in some database features of the system. an info regarding multi-client desktop app.
View 3 Replies