1. B

    How to convert Now() to Eastern Standard Time

    Hi, I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database. Thanks
  2. L

    time saved as text

    Hi I am reading some articles and they say importing data from database/.csv files to excel the time usually converted to text and therefore I need to use timevalue() and other functions or formula to convert the time to a value. I tried to google to find such files/examples but could not find...
  3. S

    Save a selected range as script

    it is obvious I do not know what I am doing. What I am trying to accomplish is by pressing the button, Range A1:A12 on sheet called DATA_1 which I set it to be as "ssheet2" be saved on desktop as DATA_1.scr but executing this macro will change my workbook name to DATA_1. Could anyone please...
  4. L

    saveas workbook in vba - default location

    Hi I have saved a file in usb key. I opened the file from usb key. I ran the code below. I entered a new name, hello. The file was saved in C: drive under Documents, not in the usb key where the file originally was opened from! Why is that? Thank you very much Sub saveas_wb() Dim x As...
  5. L

    Remove file ownership properties when saving

    Hi I work at a company with a "Shared" drive, however, any files saved on to this drive by a user are owned by that user and it means nobody else (with their own respective logins) can then open the file in NON Read-Only mode. It always opens the file in Read Only. Is there any way within VBA...
  6. A

    Looking for a tutorial for data entry

    I want to create a data entry form on sheet1, and then have the information saved to sheet2. I do not want to use the built in Excel forms. The data entry needs to have vlookups that pull in a description, which then needs to be modified and the modification saved off (not the original...
  7. J

    Highlight cell based on values

    Hello, i have multiple tabs in file and have to Highlight column from N to AL if values are matching in row AU to BF below is link i have saved file on google drive. tnx alot for your precious time and valuable feedback...
  8. S

    unable to open file

    Good Morning I have an end user that can't open a 5 meg file. The pertinents are excel 2013, 32 bit, windows 10 64bit it is a macro enabled sheet came in email the file has references to external data. a very small cluster of users can't open it, but a large majority of user CAN. it's not...
  9. K

    Excel VBA - Mail Hyperlink

    Hi, I'm trying to ask VBA to prepare a new email in outlook using the following code: strbody = "<font size=""3"" face=""Calibri"">" & _ "Colleagues,<br><br>" & _ "New Request Saved in the following location: <br><B>" & _ ActiveWorkbook.Path & "</B>\<br>" & _ "Click on this link to open the...
  10. M

    Prompt User for Save Location

    Hi The code below takes several sheets in a Workbook and saves each sheets as its own Workbook. It saves the workbooks in the same directory that the source wookbook is saved. But Id like to prompt the user once to select a folder where all the workbooks will be saved. How do I do this ...
  11. A

    Data Entry with Row Increment

    Dear Friends, I have a sheet having data in Sheet 1. I want to copy the data in Sheet 3 BUT with the incremental row. For eg Data is in Sheet 1 - A3 : F3 will be stored in Sheet 3 - A3 : F3, Now The next data AGAIN will be written in Sheet 1 - A3 : F3, But it should be copied & saved in...
  12. I

    Save print range to pdf file using command button

    Morning, I wish to save a range from my worksheet in the pdf file type. The code below works fine with no errors etc but when i view the saved pdf i can see my command buttons which on the worksheet are in columns D & E When i press the command button i only wish to save what i can see in the...
  13. J

    Trying to make an add-in to copy and paste values for every sheet

    Hi everyone, I need to make an add-in that copies and pastes the values of very sheet in the workbook. I tried running this code and it worked: Sub Saveasvalue() Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets wsh.Cells.Copy wsh.Cells.PasteSpecial...
  14. tlc53

    Save worksheet as new macro-enabled Workbook

    Hi, I nearly have this working. I want sheet 12 (called Journal) to be copied and saved into a new macro-enabled workbook. It's getting stuck at the save part, saying "The following features cannot be saved in macro-free workbooks: VB project" Sub New_Journal() Dim wb As Workbook Set...
  15. I

    Save files in accordance of month etc

    Evening. I have supplied the code below that is in use & works as it should. Private Sub GrassSummarySheet_Click() Dim strFileName As String strFileName = "C:\Users\Ian\Desktop\GRASS CUTTING\CURRENT GRASS SHEETS\" & Range("A3") & " " & Range("D3") & ".pdf" If Dir(strFileName)...
  16. I

    Looking for advice / recommendations

    Hi, I have a worksheet that I enter data into each month. At the end of the month I would like to make a copy of the page or the values entered into it then clear the cells & start over again for the next month. The required advice is how should I go about creating a copy / saving a copy etc...
  17. S

    Upon Saving Workbook, Reset Filters in Shared Workbook

    I have the below code which will automatically reset filters when saved. However, I need this to operate in a Shared Workbook. How can I get the filters to reset when the workbook is saved, in a shared workbook please? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...
  18. J


    Hi all, Need your help here. I know how to create a form. Control T and such. But how can I customize the form. Make it bigger and color it. The form would be use to input data. Only completed data will be saved. But before saving, there will be a requirement to enter the next set of...
  19. B

    Looking for a formula to include a date formatted specifically

    Hi, I'm looking for a formula that will provide the following result in a single cell every time I open the file: GMR-07-03-2019 Date needs to be in this format (MM-DD-YYYY) as this result will also be saved as the file title. I appreciate any feedback. Thanks, Brian
  20. M

    Excel Timer, save the file and disable it.

    Hi, I hope you're doing well. I was looking if you could help me to create a macro with the below condition; 1) Start Timer (for 5 minutes) & the Stop Timer(seems to be not working, need help to make it work), 2) If the Stop Timer button is clicked, then the Start Timer button should be...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back