Search results

Hi, I have written a code to insert footers in all the slides of a PowerPoint presentation which is apparently working fine. But, now the requirement has got changed and instead of footers the code should create a text box with some text in all the slides of a PowerPoint presentation...

Thank you very much for the reply and it is already past mid night here..... However, I finally made the code corrected and good to be executed....below mentioned the corrected code... Dim PowerPoint As PowerPoint.Application Dim ppt As PowerPoint.Presentation Dim PowerPointSelection As...

Hi, I wrote a code to update header and footers for all the slides of a particular powerpoint file (I have huge number of power point files having various slides to update) but seems I have gone somewhere wrong because of which its not happening. Requesting if anybody can help me. Below is the...

Hey guys, I finally found the solutions for the problem and hope it help others in future.... Below is the code..... Dim word As word.Application Dim document As word.document Dim wrdSelection As word.Selection Dim strDocPath As String Dim fDialog As FileDialog ' Set up the File Dialog. ' Set...

Hi there, Thanks for the revert. Well I am creating a tool in access vba, where in browse and selecting multiple word file only and getting them updated with the footer. Below is the code for the same..... Dim word As word.Application Dim document As word.document Dim wrdSelection As...

Hi, I have been writing few codes in order to add a footer in a word doc through access vba and I also referred few of the threads but unfortunately nothing worked out. Requesting, if anybody could help me with this regard. Thank you, Rakesh

I wrote the below mentioned code but unfortunately while executing only the first file selected is getting updated but not the rest of the others…..Please guide… Private Sub Command0_Click() Dim Xl As Excel.Application Dim XlBook As Excel.Workbook Dim XlSheet As Excel.Worksheet Dim...

Hi there, I am new to access vba….requesting to please guide for the below mentioned: I want to create an access vba tool and its purpose is to browse multiple excel files only and update/edit all selected excel files by adding a new row on (as in the first row of sheet1) with a text as “ABC”...

Hi Alan, Just got one more question to ask...Is it possible to export a access table and a access form located in the same access file to a excel file have two different sheets. Thanks in advance...

Thank u very much for the reply Alansidman. After going through the link though i got some idea but still i am not clear enough with the vba code. Requesting if u could further guide me with regards to access vba code. Thanks...

Hi there, well i have two sub forms in a ms access file and i want to export it to one excel file with different sheets. Can anybody please help me with vba code to export.