saved

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

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...

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...

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...

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...

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...

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. https://drive.google.com/file/d/1FYh4lIrxGrvTeLdB7bP52DI4xinyhZv9/view tnx alot for your precious time and valuable feedback...

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...

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...

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 ...

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...

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...

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...

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...

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)...

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...

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...

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...

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

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...