formatdate

Using the Below CODE: Sub Copy_Unprotect_SCHEDULE()Dim NewName As String NewName = InputBox("ENTER THE DAY OF MONTH THE NEW BID STARTS?") MsgBox "Importing data will take a few moments we will notify you once completed", vbOKOnly Sheets("SCHEDULE").Select Sheets("SCHEDULE").Copy...

Good Day Ma'am/Sir. I am making a code for which i have a worksheet 2columns Dates,Sales. I want to make a userform which i can choose years in combobox and display and sum all the sales within each month in the list box. I manage to find a tutorial but it has some minor issue. it display only...

help pls. i cant move on my project. kept on encountering this error, " Unable to get the EDate property of the WorksheetFunction class" Here's the code. Thank you!

Hi, I have 2 workbooks ("Invoice1" and "Invoice2") which are identical In Workbook "Invoice1" sheets (CHIT1&2,CHIT3&4 and CHIT5&6) have cell J8 updates by double click cell K8 by a code, so if I double click cell K8 in one of the sheets, cell J8 will update in all 3 sheets. So cell J8 in these...

I have this code (below) that works for worksheet "CHIT". I want to modify this code so that it works for another worksheet "CHIT2". So if I double click on worksheet "CHIT", it also works on worksheet "CHIT2". Any help is appreciated CODE: Private Sub Worksheet_BeforeDoubleClick(ByVal Target...

Hello, I have a code that runs with a Command button. Is it possible to modify the code so that it runs when I click a particular cell? This is my code: Private Sub CommandButton1_Click() Dim c As Range, a Set c = Worksheets("Sheet1").Range("A1") c.NumberFormat = "@" If InStr(c, "/") = 0...

Hi, Could anybody explain why this macro is not working when I try to save to Sharepoint, but it works perfect when I save on local disc. The error message I get is: Run-time error 1004: Sorry we couldn´t find "https://......." Is it possible it was moved, renamed or deleted? <code...

I have two pieces of working code that I was able to get working based on some things I've found online and some modifications I made myself (I'm new so I'm sure this code looks gross to most of you lol). I'm getting a Complie error that says "Next without For". I'm not sure how I properly...

Hi All I have a number of worksheets produced each day which need saving. The worksheet name is formatted as "yyyy mm dd" I need it saved in the relevant month's folder and, if not available, set that folder up. The month folder is set as, for example, "08 August" and "09 September". This...

I have a call to macro that creates a folder by date: Dim sPath As StringsPath = "M:\Lvl3-5Mgrs\"If Len(Dir(sPath & Format(Date, "yyyy_mm_dd"), vbDirectory)) = 0 Then MkDir (sPath & Format(Date, "yyyy_mm_dd"))End If and then I want to create folders in that by Executive manager (not working...

I am running a Macro that takes todays date, alters and formats it as such 07 04 18. Goes into an object, enters the date this way, scrapes data and enters into onto my spreadsheet. this is the code: Dim lDate As String Dim lMonth As String Dim lDay As String Dim lYear As String lDate = Date...

Hello, I read through the forum questions, but cannot find something specific enough to my issue. I am trying, from a template file, to have a vba button that will save a new shared copy with today's date and have a timer start for deadlines. My codes work up to the "ActiveWorkbook.SaveAs...

Hi, I have a workbook that has sheets called week 1 through to 52 and a sheet called dump. I need to automatically hide from a workbook_open, every sheet BUT the "Dump" and "Week " & X where X is current week number and then the next 3 weeks. For some reason, the code I've created doesn't...

In the below code, I am trying to append the data in the file destinationpath & CRT_File_Backlog to the bottom of the access database table, strAccPath & tbl_backlog destinationpath & CRT_File_Backlog(excel 2013 .xlsx) >>>>>>>> strAccPath & tbl_backlog(Access 2003 dbo) The VBA editor is...

So the code below is supposed to create a folder (Which is does) and then save these 4 files to the folder. The problem is that it won't save them. The code does not error, but it won't save them. What am I missing here? Thanks guys. I know one of you smarties can help me. If...

Hey there, Apologies, this seems very stupid. I am fully aware of the issue with the American date when using VBA find and replace function. I have read about it and took onboard that others suggested, but it still doesn't work for me. I might be doing something very silly here, but any chance...

Hello, This code code comes at the end of a macro and is supposed to save the workbook in the correct folder. cmbEndMonth is selected by the user in a userform and the workbook should be saved in the corresponding Quarter folder for that year. The codes works but it always saves the workbook in...