I have a text box on a Powerpoint Slide.The text box contains text that I need to use in an Excel program.The Excel program will berun from a button on a toolbar within Powerpoint.I need to be able to pass the text box text, from Powerpoint to a variable in Excel, so I can use it in my Excel VBA code.
View 1 RepliesI have a text box on a Powerpoint Slide. The text box contains text that I need to use in an Excel program. The Excel program will be run from a button on a toolbar within Powerpoint. I need to be able to pass the text box text, from Powerpoint to a variable in Excel, so I can use it in my Excel VBA code.
View 2 RepliesPowerpoint ver = 2003
Visual basic = 2008
This time i want to try to do, extract the text from powerpoint embeded excel data and show into my treeview?
I'm trying to copy a Range from Excel and Paste the information in powerpoint in either the HTML or the default format, however, I am having some difficulties. I am able to get the code to work for pasting the Range as an OLE Object but nothing else. The problem with doing this is that having the embedded excel documents in the powerpoint makes the file extremely large and unstable. I just need to be able to paste the information without the embedded information where it is editable (so, not as a bitmap or picture).
With ppt2Slide
Sheets(index2).Activate
Range("CP12:CT" & RangeIndex2).Copy
[code]....
i have a text file that contains words.. how would i get each line and pass it to a variable.here how it goes: string variable where each line will be passed and for each line will be passed to a function
View 9 RepliesI have a text file which contains some data as follows
1, 0,0,0,0,0,0,-288.000,-288.000,-16.200,0,0
2, 0,0,0,0,0,0,-432.000,-288.000,-16.200,0,0
3, 0,0,0,0,0,0,-360.000,-360.000,-16.200,0,0
4, 0,0,0,0,0,0,-288.000,-432.000,-16.200,0,0
There r 7 numbers in each row and need to read each of that and store it as an integer value ...I tried the following code..
Imports System
Imports System.IO
Imports System.Collections[code].....
This works and is showing each number by number ...But is there a way to store each number to another variable...something like a(1)=1, b(1)=0...., a(2)=2, b(2)=0......
Is it possible to use a TextBox.Text variable as button text? I have a textbox with text that is entered by the application user, I want a buttons text to change depending on what the user enters in the textbox. Is this possible?
View 2 Repliesi have this error in the line of with xl.active......Object variable or With block variable not set.
Dim xl As Object
xl = CreateObject("Excel.Application")
With xl.ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:Documents and SettingsUserDesktop429MEDICA2.TXT", _ Destination:=xl.Range("$A$1"))
[code]....
I have the following situation: Contents of an Excel sheet have to be displayed in PowerPoint slides. I have put this in a function where the following line copies the contents of the Excel table as a picture:
View 1 RepliesHow do I open/view Office documents (Word, Excel, PowerPoint) in a VB.NET Form? remember to mark the replies as answers if they and unmark them if they provide. Welcome to the All-In-One Code Framework! If you have any feedback,
View 1 Replieshow to set a powerpoint presentation as the powerpoint.application.activepresentation? In the program below, when the form is loading, it will open 2 powerpoint files (Test1.ppt and Test2.ppt). After Test2.ppt is opened, it will be the activepresentation because it is opened last.What I am trying to do is when I press button1, it will set Test1.ppt as activepresentation so that when I press button4, it will show me "C:Test1.ppt".The same also goes to button2 making Test2.ppt as activepresentation..But what I get is, no matter how many times i press button1, Test2.ppt is always the activepresentation.[code]
View 1 Replieswhen i try do this:ListView1.Items(a).subitems(TextBox1.Text).text
i receive this error:Object variable or With block variable not set.
the number in the textbox exist this occor because the var type is not a valid number but how can i convert?
in other language i dont have this problem
I am try to pass the text input into the text boxes in form ( OrderScreen) into the text boxes in( PrintOrderScreen)I don't get any error it just does not pass the text over to the second screen.
the text boxes with OS at the end belong to (OrderScreen : txtCustomerSurnameOS)
and the one without belong to Print order screen
Here is the code on print order screen
[code]...
ListView1.Items(a).subitems(TextBox1.Text).text i receive this error: Object variable or With block variable not set. the number in the textbox exist this occor because the var type is not a valid number but how can i convert?
View 1 RepliesUsing Visual Basic 2008 Express. I need to pass a variable to another form. Or else make the variable visible to both forms.
View 4 RepliesI need to write a long-running process with a While/End While loop.
To avoid freezing the UI, I added a BackgroundWorker object on the form.
Next, I needed to update the UI, but found that the thread cannot do this. Instead, the thread must call ReportProgress() to trigger the ProgressChanged() event.
However, I need to pass the text from the exception (ex.Message) to the event, but didn't find an example on how to do this. I need that text message to update the form's title bar.
Here's the code:
Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
While (True)
[Code]....
How to convert a number from an Excel text in an Excel Form
View 1 RepliesBasically, I have a gridview that is opened in a new window from the parent window. It has a bunch of records with a view button to view the details of each record (which stays in the same newly opened window). I have a calendar in the parent window that accepts a Date querystring parameter to set the current date on the calendar at page load. I'm just trying to refresh the calendar in the parent window to match the date of the label in the newly opened window.
All the code below is in the newly opened window. The .Net code-behind below refers to when that view button is clicked and everything is populated. At the end, I call the js to refresh the parent window and pass the value of the LabelScheduleDate as the querystring parameter. Now the label comes through as '03/25/2010' in the code-behind, but when I pass it to the js, it comes through as '0.00005970149253731343' in the end querystring. I'm not really sure what is making the value change, and I want to pass it as just text. Do I need to pass it as a string object? I tried but I don't think I was doing it right.
JavaScript Function
function RefreshParent(inputDate) {
window.opener.location = window.opener.location + "?Date=" + inputDate;
}
[Code]....
I use Visual Studio 8 and Sql server for my database. I have a form with a DataGridView where my records are display on from the database and some text boxes. I want to pass the data from a specific record from the DataGridView to the text boxes whithin the RowHeaderMouseDoubleClick function.
View 3 RepliesI have a form with the following on it [code]then everything works as it should (as long as there is data in the text boxes) If there is one of the text boxes is left empty then an error is returned. The text boxes are not bound and the db is set to allow nulls. Is there an easy way to suggest that if name.textbox is empty then input "nothing" or dbnull etc.I have a lot of text boxes (approx 30) and ideally dont want to write if statements for each one. But will if i have to of corse.
View 2 RepliesI have designed my form like this it has a combo box and several text boxes. In the form load I want to load the customer IDs of my customer table into my Combo box.Customer IDs data type is varchar and this part is working in my form.The next thing that I want to do is if a user select a single user ID from the combo box I need to display the first name last name and there are several fields of that selected customer id in the text boxes.If anyone can help me in this it'll be a great help.I have designed my data base in sql server 2008 and I'm using visual studio 2008.I added a new sqldata adapter and I created the data set.But I want to know how to pass the selected id of the combo box as the select parameter of sql statement and how to bind data to the text boxes.
View 2 RepliesI've been trying to convert my VB6 code to VB10, I'm stuck on how I should write it so I can pass a font name to my
function, So far this is what I have and not sure where to go from here. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
With vb.net I would like to select 4 cells in Excel and then pass those cell values along with 1 button tag to a formula in Excel.I press a button with a month, say "May" as text. I want to grab a cell in Excel labeled "May1t" the value of which is the number of hours until may. This is the code I'm using.
xlsWB.Worksheets(2).Range(Month1 & "1t").Value I am able to set a variable with this as the value but,
I want to pass this cell (which will be updating as the time counts down) and 3 other similarly specified cells along with the button tag to an Excel formula.I have something like this:
Private Sub F_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles F.Click
xlsWB.Worksheets(4).Range("B2").Formula = "=MyFunction()"
xlsWB.Worksheets(1).Range(Month1 & "1t").Select()
End Sub
The formula takes the parameters in the order: MyFunction(Cell,Tag,Cell,Cell,Cell).
I want to add some text box text in excel and i don't know how...i am using this code to add in a new excel.[code...
View 3 Repliesother than GML (Yoyogames.com Game Maker Language), I am new to the coding world. The only "major" project I have completed using VB is a computer calculator that exactly mimics the capabilities of Windows 7's calculator. Yesterday, I began a Chatbot program for my girlfriend. Lol. I have used the instr() function to answer most of the questions or answers which are typed into the textbox1. I find this extremely troublesome because when using the instr() function you cannot say instr(textbox1.
Public Class Form1
Dim fos As String = "Foster: "
Dim ash As String = "Ashley: "
[code].....
I just need to know how to have plain text and a variable in a messagebox.
For example: I can do this: MsgBox(variable)
And I can do this: MsgBox("Variable = ")
But I can't do this: MsgBox("Variable = " + variable)
Dim SecondName As String = SecondNameTxtBox.text()Is the above statement a correct one?Here I want to assign the value of the text box into tat "SecondName".If it's wrong, please tell me the correct way to write this statement.
View 1 RepliesIm new to VB and have written an application which copies data around a network. Im trying to simplify the code that does the copying so i can get it to run as a module.[code]...
View 5 RepliesThe code below reads an xml file and for each row will populate a particular group of
View 4 RepliesI have an SQL database, and 50 text files, and Visual Basic 2010 Premimum,I need to find a specific line of text in the text files and then take the next 37 lines of text and save them in my database. I need advice as to point me in the right direction
View 2 Replies