Search results

Hi I am trying to add a textbox in the slide master having the user input as reference. I want to change the default font size from Timesroman 24 to arial 12. I would appreciate your kind guidance in this. For your reference, I am adding the code I am using to add the text box to my slide...

Hi I am a new bie to VBA. I wanted to write some code in PPT. What I am trying to do is to get the powerpoint open Excel application and open the workbook located in c:\ramp.xls and then copy the chart 1 into the present slide of the Powerpoint. The slide is blank. Whenever I use the following...

Hi I am new to the field of VBA. I would love to learn its application in VBA. Can anyone recommend any books on this? Appreciate your kind help. Regards Ram P

Hi Members I have a peculiar problem. I don't know why VBA is behaving like this. I have data in different columns, imported from a text file and during importing I get blank columns. First I count the maximum number of columns and then use this variable to do the removal of blank columns in Do...

Hi Can we not call PPT from Excel. I am on XL 97 SR2. I wanted to open PPT thru Excel. I tried the following statement, But i get compile error. Dim pptobj As PowerPoint.Application Microsoft Office 8 object library is already present. Can you thinnk why its happening? Thanks for your...

Hi Xlers I am trying to group isntrument data. I was able to do some coding with your help. But I am stuck up in reselcting the group. I have a list of instrments. I ask the user that How many instrument groupings are there. I use the user input to loop throught the selection process. I have...

Hi I wanted to have some clarifications from you. How can I call Private modules in Public modules. I have many macros. For eg. My Public macro is grouping_list() and my private macro is CommandButton1_click() I want to call the private macro into the public macro and perform a looping...

Hi I am trying to give access characters to my buttons. This I am doing by including & character in the caption property of the button. But this doesnt work. Whenever I press Alt and the access character, the buttons do not get activated. I am trying to simulate the working of my buttons when...

Hi all I am trying to display the selection made by the user in the list box. Its a Multi Selection List Box. I am trying to display to the user that he/she had selected this, this etc, depending on his/her selection in the list. The following code displays the selection individually. Can you...

Hi Xlers I am trying to get the chart height using the following codes. MsgBox ActiveChart.PlotArea.Height MsgBox ActiveChart.PlotArea.InsideHeight. I get two different answers to the above. I am confused. What is the difference between Height and Inside height for a Chart? Thanks for your...

Hi A simple doubt w.r.t Message Boxes and Input Boxes. Can we increase the Font Size, Style etc of the Message / Input Box text? If yes, Can you tell me how? I am getting short sighted by having to look close into the screen to understand what the message / input box says. Thanks a lot for...

Hi I am trying to extact the file name and use it as a variable in Xl. I am importing a text file in here and since it is a text file, the sheet shall have the same name as the imported text file. It is then saved as the same name with .xls extension. What I am trying to do is to extract the...