Jump to content

abiram01

Member
  • Posts

    15
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    United States

About abiram01

abiram01's Achievements

0

Reputation

  1. Hi Tain, I checked with a macro in my Office 2007. Am able to replicate it.. Thanks a lot. Regards, Abhi
  2. Hi Tain, Thanks for the thread.. It is helpful for me. But can we know whether this bug is fixed by Microsoft or not. Regards, Abhi Ram
  3. Thank you for the response I am not able to view the content of the page. If I copy the dotm file to the start up then, every time I open the word the template (dotm) gets added. But I require the dotm to be added when I click on the shortcut I had created. Thanks, Abhi
  4. Hi All, I understand that the SaveAs method saves the file in the specified location that is passed as parameter. But this method is not working as expected for me. May be my understanding is wrong. In PowerPoint 2007 I created a add-in. In this i added a application event an class. If the addin open I do want tthe user to save the file in .pptx format. So I added the following code in the before save event. Private sub AppEvent_BeforeSave(ByVal Pres as Presentation,Cancel as Boolean) Dim fd As FileDialog ' To check whether the documet is saved or not If InStr(1, Pres.Name, ".") = 0 Then If Pres.Saved = False Then IsSavedAs = False Else IsSavedAs = True End If End If If isNitroReport(Pres) Then If IsSavedAs = False Then Do Set fd = Application.FileDialog(msoFileDialogSaveAs) iSaveFile = 7 fd.FilterIndex = 3 fd.Show On Error Resume Next strFileName = "" strFileName = fd.SelectedItems(1) If Right(strFileName, 5) = ".pptx" Then iSaveFile = MsgBox("This supports only PowerPoint 97-2003 Presentation (*.ppt) format.Do you want to save with *.ppt format?", vbYesNo, MSGBOX_TITLE) ElseIf iSaveFile <> 7 Or strFileName <> "" Then iSaveFile = 0 End If If iSaveFile = 0 Then ElseIf iSaveFile = 7 Then IsSavedAs = False Cancel = True Exit Sub End If Loop Until Right(strFileName, 5) <> ".pptx" 'SaveAsUI = True If strFileName <> "False" Then IsSavedAs = True Pres.Saved = True Pres.SaveAs FileName:=strFileName ',' FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Pres.Save End If Cancel = True IsSavedAs = True End If End If Exit Sub err: IsSavedAs = False Cancel = True Call AppEvent_PresentationBeforeSave(ActivePresentation, True) End Sub When the SaveAs executed the file name is changed but not the file path. And also the file is not saved at the specified location. When I click on Save the save as dialog box is again is displayed. I do not know why this is happing.
  5. hi, But the same is done wiht dot file. I can open that any number of times without closing the previous one. I am not sure how they are doing that. Regards, Abhi ram.
  6. Hi All, I created an .dotm file in word 2007. For that .dotm I creted a shortcut. the Target path for the short cut is "C:\Program Files\Microsoft Office\Office12\WINWORD.EXE" /l"C:\RibbonX\Example1\BlankPage-RibbonX.dotm" The problem is when I opened the shortcut for the first time its opening with out issues. When I again click on this shortcut without closing the first document Am getting en message dispalying want to open in read-only. I do not want to display this message. Please let me know how to accomplish this ? Thanks and Regards, Abhi.
  7. Hi All, I want to create a add-in for PowerPOint 2007 with some modules. These modules are imported from ppa. When I imported these modules and saved with .ppam extension, the file saved without any issues. After saving I closed the Add-In. When I opened the Add-In I was not able to make any changes to the modules and the modules are Read-Only. How can I change from Read-Only to Read-Write mode ? Thanks & Regards, Abhi.
  8. THIS IS RESOLVED. The other systems had previous versions of dlls
  9. Hi All, I created a ribbon tab in excel 2007. Such that it will replace the menu which I had in previous versions of office. The major problem is that the xlam I created for adding ribbon tab is working fine in my system. When I add the same xlam in some other machine that has same environment as mine it is crashing. In other system I got a error message message "Cannot create ActiveX controls" and its crashing. I am not able to figure out, what is the fault with the xlam. Please let me know if there are some settings that needs to be done. Thanks, Abhi.
  10. Hi found out some way to do that. But as you mentioned there are some limitations. Thanks, Abhi.
  11. HI All, How to dynamically add items to a dropdown control in the Excel ribbon? Thanks & Regards, Abhi.
  12. Hi All, We were using a menu in the previous versions of Office. To display the icon to a menu item I used face id property. Now for Office 2007 the menu's have been replaced with Ribbon. Please let me know how I can load the icons using face id value to a ribbon item. Thanks & Regards, Abhi Ram.
  13. Do you mean the Table of Contents ?
  14. -------------------------------------------------------------------------------- Hi All, I am wokring on ribbons on Excel 2007. I want to load a image to a button on the ribbon. The image is included as a resource in the dll. How can I load the image from the dll to the button. Thanks & Regards, Abhiram.
  15. Hi All, I am working on Word 2007 VBA. Am able to add Customized tab to the Word 2007 ribbon by using customUI.xml. However I would like to enalbe or disable some of the items on my cusotm tab. Also I want to the customized ribbon item to be removed when I click a item. Please advice me how I can accomplish the above mentioned task. Regards, Abhi.
×
×
  • Create New...