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 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 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 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'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'm currently working with PowerPoint in VB.NET and having a bit of trouble getting a slide to have an individual background. Using the SlideMaster method changes all slide in the presentation and I want only one to be affected
PS Using the Background.Fill.UserPicture method doesn't seem to be working, but I'm not sure why...
MS PowerPoint, on the left side, there is a slide bar showing slides/pages available, is it that a slides pane? And how can I do that, let say if I want to create a new page/slide, how can I create a new blank slide? Also the side bar will display the pages/slides but is in smaller view...
View 1 RepliesI have been using VB to manipulate notes in PowerPoint presentations.Until today, everything had been working fine (in PowerPoint 2007) using:[code]But today I tried the code on a PowerPoint 2003 presentation and it threw an error saying that the object didn't exist.I tried looking in shape 1 and 0, but I don't find the notes.I then tried updating the presentation to the 2007 format, but the notes are still not accessible using VB, although they appear in the PowerPoint window fine.
View 1 RepliesI have a project Visual Studio VB2010 which controls PowerPoint and is working, I now want to copy a slide and put it into a Picture box but it does not work. I need to find what format PowerPoint puts it on the clipboard in. The copy is working because I can paste it into Paint or Word but when I use the code below I get nothing. If I copy a bmp/jpeg/tiff/png/meterfile in Paint it then shows in picturebox, so it appears the format is not right for powerPoint
If
My.Computer.Clipboard.ContainsImage()
Then
[code].....
I have written a VB.net 2010 Powerpoint addin that needs to be able to advance the slide via a button on it's main form when running the presentation. The functionality I require is exactly as if you press the space bar while focus is on the slide show window.
I have tried-PowerPointApp.ActivePresentation.SlideShowWindow.View.Next
But this does not work in excatly the same way, namely when working with several animation sequences on the same slide.I am looking into using the API - FindWindow & SendMessage but I do not fully understand the steps to get this to work, or even if it can. Or is there another way?
I am using Visual Studio 2010 RC with Powerpoint 2010 Developer Beta.
if this is the case.What I'm trying to do:1) have a way to save / copy screenshot from an Air app2) automatically paste such screenshot into a new powerpoint slide in the current presentation
View 1 RepliesI have a strange problem on one machine that my VB.Net (.NET 3.5 - VS2008) app is running on, it runs a custom sized Powerpoint presentation in an IE control within my VB app. However, on one of the machines my app is installed on, the presentation always pauses on slide 2.
This is a kiosk type app, where there is no user interactivity. On all the other machines running this software, there is no problem. So it must be something related to the machine itself.
The PC is an XP Pro machine and was originally running IE6, which displayed the problem, I ugraded it to IE8 to see if this would fix it, but the problem persists. The machine is running Powerpoint 2003 (don't recommend upgrading the machines OS/Software- this is out of the question, as it is a business spec machine - even getting IE8 installed was a battle!)
The presentation itself has no complexity, all 15 slides are basic text and photos, no animation, no video etc. As far as I can tell, the problem is nothing to do with my software, or the Powerpoint slideshow, as this operates fine on similar machines and reinstalls made no difference, it must be a problem with the machine/installation itself. I've tried running the slideshow on the problem machine, in PowerPoint itself, rather than in my app, and it runs fine. I've also tried running it in an IE window, without running it through my app, and again, it seems fine.
I am trying to send a keystroke to a running powerpoint presentation with SendMessage or Postmessage. But I can't get as far as the handle for the presentation.
<DllImport("user32.dll", SetLastError:=True, CharSet:=CharSet.Auto)> _
Private Shared Function FindWindow( _
ByVal lpClassName As String, _
[code]....
As I understand it, you have to use FindWindow to get the application's handle and then FindWindowEx to get the sub-window's handle. The problem is that the line below FAIL returns 0, not a handle.Relevant material / possible answers are given in these sites but in C-type languages and I just can't see how what I'm doing is making the code fail: RE: hide cursor for kiosk application (powerpoint) hide cursor for kiosk application (powerpoint) | keyongtech Passing Event to Other Application.
Powerpoint 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 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......
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 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 RepliesIm using this code
Private Sub Form1_MouseEnter(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.MouseEnter
For i As Integer = 38 To 2 Step -1
Panel1.Height = i
Next
[CODE]...
I have 2 panels on the form butttt for panel one i want to slide height and panel 2 i want it to slide width.
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).
ok to start i know very little about VB6 but i am very good in true basic lol (stupid school teaching the wrong language -_-) anyway im just asking you to make the answer as clear as possible because i don't know very much. heres the problem . ok in the above example i have a button that (for my example) can be used to build a house (lol) i then have a variable in the button sub called money which will have 150 subtracted from it when the button is clicked my problem is it say variable not defined when using this button ... i have declared the variable in a module and in form load along with my other 50 or so variables. my question is how do i pass the variable into this sub and then send the new value back into form load so it can be sent into another sub for more calculations.
View 14 RepliesI currently have the following funcion:
Public Sub GetUserAmount(ByVal ConnectionString As String)
Dim command1Text As String = "SELECT Wager FROM Donations1 WHERE DonationId = (SELECTCOUNT (BidCountHistory) FROM BidCountHistory)"
[Code]......
I need to pass a variable by name like this
Dim html_news = "...the news ..."
Dim var = "news"
Dim a = "html_" & var
' content of that variable
How can I do that in VB.NET ?
I am currently trying to teach myself how to program VB.Net in Visual Basic 2010 Express.I've been working on a little project for a while and have hit a wall. Normally I can find what I need online but I am now at a complete loss. Essentially I am trying to pass a pair of variables from Visual Basic (file names actually) to VBA so that I can copy/paste data from them using VBA. What I need is to find out how I can pass variables (in string form) back and forth between VB and VBA
View 13 RepliesI have a Public Sub where I declared
Dim Elev As Double
later under that Sub I have the program go to anothrer SubRoutine that uses the same Elev variable. Within that subroutine I get a Variable not declared error. My book talks about using "Static" but in the context i guess I am using it, it hasn't worked.
What is the best method of tranfering the information from one sub to another.
I am using VS 2008.I have an application that has a variable defined as an Application Setting. I use this variable to define the connection string so I can change the location of the database withour having to recompile the application.My application references a class library. The Class Library is the one that manages the database. The DLL is referenced by my application.How can I make the class library use the Connection String defined as an Application Setting of the consuming application? If I say in the class library:sdRadhaAllied.Schema.Connections(0).ConnectionString[code]...
View 4 RepliesVS 2008, .NET 2, Win XP I need help with passing a String variable from App to DLL?Why: I have App that on UnhandledException needs to call ErrorReport dll, send to that dll some strings like: App name, stack, error... Dll will send through internet this gathered data to me.
I can open Dll, close it, code it, but I can not figure it how to send data to it like VB App name, VB App version, VB App error.message For example I can in my form make a global variable like Public TestGlobal As String and that I can call from anywhere in my app, but how to do it with dll?
[Code]...
I'd like to know, if I have a variable,for example, a string, how to pass its value to my new app domain:
static string _str;
static void Main(string[] args) {
_str = "abc";
[Code].....
i have a dialogbox (dialog1) i will assign the input from textbox a variable to the from1 but i cant do that.the variable in form1 is Dim get_from_dbox As Long i try to assign to it from dialog1 like below it fails form1.get_from_dbox = Textbox1.Text but i can assign to textbox??like that which works well
form1.RichTextBox1.Text=Textbox1.Text I am new programing i know i am wrong .don't know where?
How can i pass a global variable from dll project to a exe file, after this i want to run the exe also from the dll.
View 9 Replies