.net - Copying Multiple Worksheets Simultaneously To Preserve Chart References?
Apr 22, 2009
I've created a two-worksheet template in Excel - the first sheet is for pretty charts, and the other sheet is for the data that drives those charts. I've written a vb.net 2005 app that can dump in all my data on the second worksheet, and the chart worksheet updates perfectly.I would like to do this report several times over in the same workbook. (So the tabs would read 'Person1 - Chart', 'Person1 - Data', 'Person2 - Chart', 'Person2 - Data', etc.)
My solution was to, for every person this report was going to be run for, copy the chart template, and then copy the data template. The problem is that every chart template that is created points to the original data worksheet. How can I set what worksheet each chart worksheet is pointing at?
View 3 Replies
ADVERTISEMENT
Jan 18, 2010
In VB 2008, I am trying to create an app that will copy a range of cells from one worksheet ("xlWS1") in the first workbook ("xlWB1") to another worksheet ("2") in a second workbook ("xlWB2"), starting in cell A1. I would like this to be activated by a button.Then, another button will copy the same cells from "xlWS1" to "xlWB2", worksheet "3", and so on for each subsequent button.
xlWB1/xlWS1 contains data in the cells that is updated from our data acquisition system once per second. (we perform jet engine testing). "xlWB2" sheets (6 of them) will contain the saved data from the "live" screen (xlWS1, came cell range) in the first WB. There are several different versions (filenames) of the second workbook, one for each engine model.Both workbooks should already be open, but I would also like the app to open them if they are not open already.
We have been using VBA macros to do this, but run into problems when someone saves the second (destination) workbook under a different filename. For some reason, if the filename of the Wb that is already open isn't the same as what's in the macro for that button, the macro's defined workbook is renamed in the macro. I am trying to get away from using the macros to keep this from happening, and to make an app that's "foolproof" so it is more reliable.
I already have an app that will open the proper workbooks. I may combine the two apps in the future. I can't find a solution for this. The VBA code is quite different and simple as far as opening, activating, copying, etc. Basically, I can't seem to find any self-explanatory "activate/copy/paste, etc." namespace in Vb 2008 like I used in the VBA macros.
I'm sure the solution is simple, but I just can't seem to find it in the MSDN library or the VS 2008 book I have. Everything in the book talks about accessing databases, which we don't use (yet). There's nothing concerning this issue with Excel 2003 workbooks/worksheets.
View 10 Replies
Mar 8, 2010
I was developing a small function when trying to run an enumerator across a list and then carry out some action. (Below is an idea of what I was trying to do. When trying to remove I got a "Collection cannot be modified" which after I had actually woken up I realised that tempList must have just been assigned myLists reference rather than a copy of myLists. After that I tried to find a way to say
[Code]...
View 4 Replies
May 10, 2010
I wrote code that creates an Excel workbook wit a single worksheet (see below). How can I update this to add multiple worksheets to the workbook?
''' <summary>
''' Create a new XLS Excel spreadsheet based on a passed CSV (comma separated values) file.
''' </summary>
[code].....
View 6 Replies
May 8, 2010
I'm trying to delete worksheets that contain PX in their name and leave the worksheets with EQ alone.
View 2 Replies
Dec 23, 2009
I have 2 workbooks( Book1 and Book2) with multiple sheets.I am only interested in one of the worksheets in the workbooks(both the worksheets names are the same).The thing is that the data is in the form of pivot tables, so each time i have to filter according to specific categories, copy and paste into another new workbook.The thing is column headings in both the worksheets are different,BUT BOTH the worksheets data must be combined into 1 single worksheet( row after row).
Meaning in Book1, my columns are in the form of Cost, revenue,margin and in book2, the columns are in the form of Cost,Revenue, Profit Margin %.... That means i must add a profit margin % column in Book1 and a Margin column in Book2 before I combine the data into a single worksheet. Each week, new data gets added into Book1 and Book2, so I wish to automate this by creating a code, so that when the source data changes, my new workbook's data also changes.
View 1 Replies
May 5, 2010
I used different backgroundworkers to instantiate some 'heavy' forms thinking that it will reduce the time to instantiate them if I did them at once but it looks like I am wrong since it is still taking about 43 seconds to load all of them. Am I missing something or do you have a tip on how I can speed up their instantiation?
View 15 Replies
Jun 18, 2011
Not wanting to hijack 45minutes thread, I thought I might spawn a thread of my own based on his question.
PlausiblyDamp was kind enough to provide some generic code, which I have modified and attached.
I have made a few alterations mostly around removing random objects, as the game in question (Space Invaders) has a set amount of aliens and set starting positions.
As a start I have limited the UpdatedPostion to horizontal movement as the aliens only go side to side unless they hit an edge.[code]...
View 15 Replies
Feb 18, 2010
I am creating a GUI that monitors the entered application and if the application crashes the GUI starts the application back up. Problem is to run this application (WoW Private Server) I need 3 running applications. Is there a way to shell and wait 3 applications all at once. OR if i was to create a separate console application who's only job was to start the three applications at once how would I pass the application variable?
Here is my program thus far: [URL]
View 8 Replies
Feb 17, 2011
We are looking to design a security application that does the following on laptops:If the ethernet adapter is used (cable plugged in) disable/block all other network connections (wireless WIFI, mobile broadband (PPP), virtual VPN adapters etc)When ethernet adapter is not being used again, all connections allowed.We have looked in the WMI a lot but there are no good ways of doing this. Only disabling the network connection is not secure enough because most mobile broadband applications try to re-establish the connection. This should be an application that works on all laptop vendors without any user interaction (such as choosing interfaces etc..).
View 3 Replies
Feb 7, 2012
I'd like to allow the user to select up to an entire column of cells and type and/or paste a single value that would then change the value of all the selected cells in the DataGridView to the value that was typed or pasted. I understand this is probably two separate answers, but perhaps if there is a way to set the contents of the clipboard with the value typed, I was thinking it may work well to identify both things I want to do.
View 3 Replies
Dec 14, 2009
I need to play multiple files simultaneously at the moment i am trying to use mciSendString() API it plays the files listed in a listbox. But it is only playing the first one i assume it would play the next one after the first is finished... cbf waiting to see.
Note this was an attempt in C#:
private void PlayButton_Click(object sender, EventArgs e)
{
if (SongsListBox.Items.Count > 0)
{
[Code]....
View 3 Replies
Feb 6, 2010
I have been using the My.Computer.Audio.Play method for sounds in my program for a very long time, but now I have reached a point where the program needs to be able to play more than one sound at a time. What is the best (and preferably simplest) way to do this?
View 8 Replies
Dec 13, 2010
I want to play multiple sounds simultaneously from My.Resources in Visual Basic 2010. I have tried:My.Computer.Audio.Play(My.Resources.SoundName, AudioPlayMode.Background)
I have also tried using multiple Windows Media Player controls, but that also didn't work.The first sound is cut off when the next sound plays.When searching around the internet I found people suggesting using 'DirectSound', but there are only tutorials for DirectSound in VB 6.0.
View 1 Replies
Jun 6, 2012
How to run multiple funcations simultaneously using multithreading concept?
Actually i am making a software which has backend tool as MS ACCESS. it has 15000+ records in database and i need to display that records as my software loads..but it is much time consunable and sometimes it even goes out of time exception
View 7 Replies
Nov 6, 2009
I'm writing a program which gets the time and date from forums which only show "x hours ago" on the main thread list.What I do is get a list of threads, open their print version and fetch the info.I'm currently using a single webbrowser, because there's no control array anymore. This makes the proccess very slow.Is there a way to open all the threads' print versions simultaneously?(BTW, I'm using DOM functions like GetElementsByTag, so I'll need to get the page's "Document" object.)
View 8 Replies
Apr 16, 2009
I have three listboxes with vertical scroll bars. I'd like it so that when one is scrolled, so are the others. However, I can't seem to find a "scroll" event. I tried this:
vb.net
Public Scrolling As Boolean
Private Sub ListBox1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles ListBox1.MouseDown
If e.Button = MouseButtons.Left Then
[code]....
It works when you click and drag on the listbox area where the items are, but not when you click on the scroll bar!
View 4 Replies
Mar 25, 2010
Consider I have a shared function:Public Shared Function CalculateAreaFromRadius(ByVal radius As Double) As Double
[Code]...
If I have two or more threads in the same vb .net app and each of them calls the shared function at the same time with different RADIUS, will they each get their own AREA? I want to know for each call to the function if it is using same local variables or each call creates new instances of local variables?Will the answers to above questions be same If I have multiple (2+) single threaded apps and they all call the function at the same time with different RADIUS value?
View 2 Replies
Jul 14, 2011
Using Visual Basic in Visual Studio 2008, I have created a Windows form with multiple tabs and questions. Each question has an associated drop-down listbox that the user will eventually click on to enter his or her response. My client has now informed me that she wants to change the standard responses in each response box. There are well over 100 drop-down listboxes, all with the same items, and they all must be changed.
I originally inputted the items using design view. Would someone please tell me if it's possible to edit all of these boxes in the design view simultaneously? When I control + click on more than one box, the Edit Items option that is normally available disappears. Is there a way to do it in code in a manner that would save back into design view?
View 9 Replies
May 31, 2011
I have two unrelated databases and I need to pass data back and forth between them. Right now I have created two separate entity models - one for each database - but this is causing issues in my code b/c I have to do a Using nameofcontext / End Using and when I try to then use some of the results from the first section of the code in a second Using nameofcontext / End Using it doesn't like it - b/c I've closed the connection to the first database!
View 1 Replies
Jun 9, 2011
I'm making a simple game. I want simultaneously go up and left.
Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
' If e.KeyCode = Keys.Z Or e.KeyCode = Keys.Up Then
[CODE]...
Left, right, down and up work. now diagonal.
View 1 Replies
Oct 14, 2011
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 Replies
Jul 10, 2009
I know you can copy a file using:[code]The only way I know how to copy multiple files is by using a for loop, but if you choose to display a dialog box, you get a dialog box for every file you copy instead of one showing the progress of all the files.So with that said, is there any way to copy multiple files, and only have one dialog box displayed?
View 2 Replies
Mar 9, 2011
I have Crystal Reports 2008 installed on my win7 laptop but when i go to insert references from my application settings the CrystalDecisions references are missing and im not able to find them. Note: they do exist in my "c:windowsassembly" folder.
View 3 Replies
Dec 29, 2011
is there any way to copy multiple files at the same time WITH PROGRESS BAR like in windows explorer? I am using system FileIO.FileSystem.CopyFile for copying single file, but I want to do this with more then one file.
View 8 Replies
May 17, 2012
I recently designed a web application using VB.Net and tried to copy a folder (containing multiple files) from one disk drive to another but unfortunately I didn't succeed.I tried using a file upload but that is only for single/multiple file selection however I want to select a complete folder instead of multiple files.
View 4 Replies
Mar 28, 2011
I'm trying to copy multiple files from a directory, put them into an array, then copy just the 30 newest files(I haven't coded the 30 newest loop yet). I added a list box to the following code just to ensure the all the files are storing into the array properly... they are. When it try's to copy, it renames the first file to .log, then tells me that the .log file already exist. How do I get it to copy and keep the source file name in the destination folder Eventually I'll loop this and grab only 30 of the files.
Here's the code I'm playing with:
Private Sub transferButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles transferButton.Click
[code].....
View 2 Replies
Mar 15, 2012
I've got a bar chart on my form which when I click a button, it populates with some data showing the clients net position, which is their assets vs their liabilities. This is shown on a year-by-year basis, so the graph will go up or down accordingly. If the graph goes into negative, or is negative at any stage, I would like it to turn red, and leave the positive values green. I have no idea how to do this, or even where to start looking into the properties. I'm still new to using the charts. How can I make the x-axis labels in increments of 5 from 0, instead of increments of 5 from -1?
View 3 Replies
Mar 4, 2012
How do I plot multiple series (say about a thousand) on one chart at runtime?
View 7 Replies
Jul 6, 2011
I am importing data from an excel file, and it is stored in a dataset. The data is then filtered with a binding source, and that data is outputted into a datagridview. The filtered data in the datagridview contains data for 2 identification numbers. I want to graph each ID number in a chart on their own bar, in either a stacked bar graph, or a double bar graph.
I am having trouble assigning each series to an ID number: I have tried using multiple binding sources, but each seems to override the previous giving too much/too little data. I have tried using multiple datagridviews, however I cannot assign more than one datagridview as the datasource for the chart. The code I have pasted below outputs a double bar graph, however both bars graph the same ID number.
Private Sub dataButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dataButton.Click
Try
Dim cnRange As String = "provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" & strFileName & "';" & _
"Extended Properties=""Excel 8.0; IMEX=1; HDR=No;"""
'moApp.Visible = True
[Code] .....
View 1 Replies
