vba activate workbook

I want to save activated worksheet i.e.template at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet(template) again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75...

I have three lines of code that do the following: (1) Opens another file based on a filepath in a cell in the current workbook. (2) Copies the values of a named range in the newly opened book. (3) Pastes values in tab "Detail" of the original workbook. When I put the three lines in the...

Hi All, I'm using the following code to open specific ribbons based on the Worksheet name (I've setup my RibbonUI's in the XML already). The code below opens up a particular ribbon based on the Worksheet Name or "CodeName" i.e. Sheet2: Private Sub Workbook_SheetActivate(ByVal Sh As Object)...

The following code (blue font) finds specific worksheets in an active workbook, and copies them into a new workbook then names the new workbook the same name of the worksheet. It all works perfectly. The second code below (red font) imports some vb into the new workbook. It works fine if I...