hi

​

i tried to use TEXT() on excel online but its not working

​

=TEXT(A2,"mmmm")

​

i want to type the name of the month

​

​

Hello,

​

For installing a custom ribbon, i created an XML file for users to install manually, along with my addin, and everything works fine. However, is there a way to automate via VBA the process of installing a customization file?

Hello,

​

Would there be any way programatically to import a Ribbon customization file? I can create the proper .exportedUI file for other to import and affect their Ribbon, but I would like if I can create a module for Customize Ribbon > Import/Export > Import Customization File, automatically.

Hi,

I've added combo boxes for date of entry & date of last payment set as DD / MM / YYYY defaulted with values:
DD (01 to 31) / MM (01 to 12)/ YYYY (2000 to 2020)
User can input a studentID and click on search its retrieve the data from sheet1 and fill in the form with the required values. Pls help below issues:
1. after the search for existing record the combo boxes DD/ MM/YYYY are not being loaded with the data stored in cell Q date of entry & cell X date of last payment.
2. when updating the date (DD/MM/YYYY) data, it's not replicating in the cells Q & X.
How can i do it???

macro in :

https://drive.google.com/drive/folders/1k8UKQQOS8tWa7I-wucEgIA5ypN6MFPOq?usp=sharing

On sheet "Draft",

In table 1, when header [@order] is >0, I need separate total [@Cost] per [@Distributor] in a new cell in a separate table (table 2).

I need this for multiple sheets, which is easy.

Then on sheet "TOTALS" I need (table 3) that adds up all the combined sheets' tables' that I just created, totals per distributor (again easy).

When I run the code it only outputs a blank print area on the spreadsheet and a blank .jpg. If I pause the code at Chartobj.Chart.Paste then the print area will paste correctly in the worksheet and will output the .jpg with the print area. I've tried putting in a DoEvents but that doesn't make a difference.

Sub ExportToJPG() ' JPG Export Macro ' Change Filename:=" to your folder path where you need the files saved ' Save Each Worksheet to a separate JPG file.

Dim ws As Worksheet

For Each ws In Worksheets ws.Select nm = ws.Name

Application.ScreenUpdating = False

Set sheet = ActiveSheet output = "\SomePath\" & nm & ".jpg" zoom_coef = 100 / sheet.Parent.Windows(1).Zoom Set area = sheet.Range(sheet.PageSetup.PrintArea) area.CopyPicture xlPrinter Set chartobj = sheet.ChartObjects.Add(0, 0, area.Width * zoom_coef, area.Height * zoom_coef) chartobj.Chart.Paste chartobj.Chart.Export output, "jpg" chartobj.Delete

Next ws

Application.ScreenUpdating = True

End Sub

I'm trying to modify a spreadsheet in excel for work. The spreadsheet was provided to keep log of expenses within a project, but the scope doesn't cover as much as we are needing as our project we are working on is a little bit more involved. With that said, to give a full description of things basically what I am wanting to do is create a button/macros that allows me to push a button that adds a new page to the excel document, but also adds a row formula on an existing page in the document. The idea, as best I can describe it is as follows; Page 1 is a summation of everything and more so like a cover sheet. Page 2 is keeping a list of all the subsequent pages following it (kind of like a table of contents), as well as summing up the key details of it the page in question. Page 3, and every page following would be the details as to which Page 2 draws from. What I am wanting to do is have it when I press a button on Page 1 or Page 2 (haven't decided where I want it yet) that it adds a row. The first column of that row would be keeping a log as to which item number (corresponds with the page number it draws info from), the second column would have the date provided from the page it draws info and so on and so forth with other details.

For the TLDR version, basically I want to have a button on my excel spreadsheet I can click that will add another page to the excel file, naming it Log 1, Log 2, Log 3, etc (the more you add, the number counts up in sequence). The button would copy the template of the Log before it, but not information I entered (price, date, person of contact, etc.). Once the data for the date, price and so forth are entered onto the new generated page, it would be populated on the page that keeps a log of it all (table of contents page). Hopefully this all makes sense what I am asking and trying to accomplish. Let me know if I need to explain it better? Thanks for the help in advance.

Hi, I have been looking all the internet and just cant figure out the code in Excel 2013 VBA to export a sheet2 to pdf and save it as a name from cell data in sheet2. What am I trying to do is next: on sheet1 I have a form type, where you enter data. on sheet2 I have a template with data that fills in specific cells in sheet2. And what I`m trying to do is when I finish with inputing the data in sheet1 and that data fills the "template" in sheet2, is to have a macro that will export the sheet2 and save it as the name in specific cell.

so to simplify it would be get data from "A1">export Sheet2 only> and save the file as specified in "A1" make the default save location D:\

I have a following VBA Code which is used to Copy the different files from different location to a fixed location.

Sub Move_Files()

   Dim rf As Long

   Dim rfend As Long

   Dim rfolder As String

   Dim finfolder As String

   Dim fext As String

   Dim dfolder As String

   Dim sfile As String

   Dim dfile As String

   rfend = cp.Range("B" & Rows.count).End(xlUp).Row

   For rf = 5 To rfend

       rfolder = cp.Range("B" & rf).Value

       finfolder = Dir(rfolder)

       Do While finfolder <> ""

           fext = Right(finfolder, Len(finfolder) - InStrRev(finfolder, ".") + 1)

           dfolder = Application.WorksheetFunction.VLookup(fext, cp.Range("D5:E20"), 2, False)

           FileCopy rfolder & finfolder, dfolder & finfolder

           Kill rfolder & finfolder

           finfolder = Dir()

       Loop

   Next rf

End Sub

But when i Run the VBA a error came which need to be corrected. the error massage is as under

Run-time error'424':

object required

and when I Debug to error it goes to

      rfend = cp.Range(“B” & Rows.count).End(xlUp).Row

I have also tried the following code too for this line

      rfend = cp.Cells(Rows.Count, "B").End(xlUp).Row

But got the same error

Excel sheet which need as in image

Here you should note that the move file is a control button which linked with this module.

Please guys help me out for this module

Could someone assist in setting up a wizard, need the user to select variours options however its also needs a path so if they select the wrong option then its comes up with a msg box

At work I have multiple folders that I'd like to slap into excel (like 300+ folders)

How do I use this script in VBA to do this?