1. S

    Formatting date question ....

    I have data in columns G & H which is 13/11/2019 (ie, 13th November 2019) I want this date to display as 2019/11/13 When I formal cells > custom and enter the format as yyyy/mm/dd, this looks good. I save (as csv) and reopen the file, but it reverts back to it's original formatting? How do I...
  2. A

    re-run the macro if command button is clicked

    Dear Learned people I have a macro that, when it has run through all the code saves the workbook with a different name using "Save As" . I added a command button "Save & New" on a user-form in a certain position in the code. I would like for the user to save the workbook (Save As) and then...
  3. S

    Pls help how to Add multiple rows with same value of combobox through userform

    I have created a userform Which have a combobox and a text box, save button. Now when i select a value say"ABCD" in combo box, i will mention say number as "5". Now when i click on save button, then 5 rows of value "ABCD" should be created in excel cells in the column i specify. And next time i...
  4. K

    Pop up message box

    Hello all, I have a workbook that uses multiple command buttons to get to the user forms and writes data to multiple sheets. I was wondering if there is a way to get a message box to pop up when I click on my midnight command button and "01" is displayed in cell "C4" on the main page where the...
  5. R

    automate save workbook as PDF and email to a fixed address.

    Has anyone written a script that would save the 4 sheets of a workbook as a 4 page PDF and then email that PDF to a specific address from my gmail address? Ideally I would like that PDF file to have today's date in the name.
  6. P

    Hyperlink icon or Hyperlink formula

    Hi, I am creating a summary sheet book with hyperlink icon or hyperlink formula to the another workbook “datasheet“ however i found the below issues. 1. For the right click and create hyperlink, it is easy to do but when I save as the summary sheet workbook and the another workbook "datasheet"...
  7. K

    yes/no pop up message box

    Hello everyone, I have a command button that opens up a user form, I would like to add a yes/no message box to the command button and when cell "A4" =01 (01 representing today's date). My message would read"do you want save the data and delete before entering new months data". If yes is...
  8. L

    undo read only excel file

    Hi I saved a file as read only (save-->tools-->others--> checked [] read only). Now even for me, it open as read only. If I want to save it, it will create a copy of it and save the copy but original one is still read only. How can I undo Read only or that is not possible? Thank you. Thanks
  9. N

    Message Box Pop up twice while closing workbook event

    Hi All, I am using below code to save the current file in another location and also want a pop up message if user want to save a copy of file or not ? but every time I am closing the workbook the message box pop up twice. Can anybody help me out what mistake I am doing ? Private Sub...
  10. S

    [VBA HELP] Save file prompt to overwrite, save as or cancel

    Hello, I need help on VBA for the following requirement. Pop up message with 3 button of choices 1. Overwrite file 2. Save as different file name 3. Cancel operation. Thank you so much for your help. Cheers..... Sasils
  11. S

    Copy worksheets to new workbook, delete connections, then save new workbook

    I am trying to copy two worksheets to a new workbook and rename/save that new workbook. When I copy the worksheets over - the queries are copying with it...which is causing issues when I try to save the new workbook. To get around this, I am having to delete the queries / connections...then...
  12. A

    determine username computer name and save worksheet to filename in a cell

    Hello brainiacks, (said with utmost respect). here is my problem: I have some code in a workbook named configureData.xlsm that creates a filename and stores to cell Q2 . I want to open a new workbook.xlsx and save it with the fileName created in Q2 The path would always be the same: UsersName...
  13. A

    Save Workbook with name generated from excel data

    Hello brainiacks, (said with utmost respect). Please help with my problem: I have some code in a workbook named configureData.xlsm that creates a filename in Q2 . I want to open a new workbook.xlsx and save it with the fileName created. The path would always be the same: UsersName =...
  14. P

    VBA - Saving a workbook in a SharePoint directory

    Hello, I want to save a workbook directly to SharePoint. If I know the URL of the SharePoint directory, I can enter it directly into the directory line of the "Save as" dialog window. But the question now is how I can specify the desired URL for the "Save As" dialog via VBA. Further I would...
  15. K

    Save and close an active workbook with VBA

    Hello everyone, I have a macro that opens another excel file, makeschanges in that file and should then save and close the document. Currently I am using this line of code for saving and closing the document: WB2.Close SaveChanges:=True By using this code it is doing save as meaning it opens...
  16. S

    How to take screenshot of certain range?

    Hi I want to take screenshot of a range and expect a prompt to save it. The range is not always same. The maximum range is same... means there wont be more than 11 rows and 10 columns. But, I only want to take screenshot of the range having data. That is less than or equal to 11 rows. Number of...
  17. S

    Saving Cell Data to a .txt file

    Good Morning, I've got some ideas but none seem to be working quite the way I want them to..... I'd like a string of code that, when run, will take the contents of cells A1, A2, and A3 and save them in a .txt file, with each set of cell data being a new line (so the info of cell A1 is the top...
  18. B

    macro save file with specific name

    Hi everyone, I am very new to Marco, it would be glad to get some help here :) Here is my trial: DD = Day(Date) MMM = Month(Date) YY = Year(Date) WBK = "S:\Project" & Format(Now, "DD MMM YY") & ".xlsx" Windows("Destination File.xlsx").Activate...
  19. J

    Save as Workbook

    Hi, I have macro excel Sheet and I would like to save as xlsx format with application.username along with ddmmyyhhmmss in a specific folder without closing excel macrowork excel sheet.. Please advise if we can copy clipboard on last saved xlsx worksheet. ActiveWorkbook.SaveAs filename:= _...
  20. G

    VBA to create new worksheet based on cell info and also save as a PDF file.

    Hi all< I have a vba which creates the new worksheet no problem. But I want to add to the VBA by having it also save as a pdf file in the following location: Ged\Disability\2019-2020\invoices. I also want the PDF file to be named the same as the worksheet that was created. This is what I...

Some videos you may like

This Week's Hot Topics