formatnow

How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help. Application.DisplayAlerts = False ThisWorkbook.Save txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")...

Hi, I have this code for file path for the Invoice PDF. Private Sub CommandButton1_Click() Dim NxtRw As Long, CurrentPath As String, wFile As String On Error GoTo EnEvents If Range("J3").Value = "" Then NxtRw = 3 Else NxtRw = Range("J2").End(xlDown).Offset(1).Row End If...

hi guys having problem i trying create a code so depend on what day it is the code change prefix is L and the next two number is YY year and the 3 last numbers is DDD (001 - 366) but in number format not words like Sun or Mon so in the case than 366 would be Feb 29 or 206 would be...

Hello Everyone, I am having a slight issue with some code I am trying to run. Some backstory: This VBA is from a spreadsheet that creates some tabs when executing the macro/clicking on macro button with the ultimate goal of pulling text from a .txt that is updated daily. This code is part of a...

Hello, I did formatted the textboxes values likeTextBox9.Value = Format(Now(), "h:mm") TextBox10.Value = Format(Now(), "h:mm") And i'm trying to find the total minutes between eachother by manually changing the values... My question is after 24:00 calculation gives me wrong figures with the...

Hi, I would like that when i open the userform the dat would automatically be shown in textbox 1 I thought the below code was correct but upon opening the form textbox 1 is still empty. ThisWorkbook.Worksheets("POSTAGE").Cells(LastRow + 1, 1).Value = TextBox1.Text = Format(Now(), "MM/DD/YY")

TextBox9.Value = Format(Now(), "h:mm")TextBox10.Value = Format(Now(), "h:mm") Hello, I like to put another textbox and when I change the times manually that textbox will show me total minutes.Is it possible to make it with a code? If TextBox9 = 13:14 If TextBox10 = 14:24 TextBox11 =70 Many...

Hi, My week 1 starts from August 27th 2017 which would be classed as AW17 (Autumn/Winter). My week 27 starts from February 25th 2018 which would be classed as SS18 (Spring/Summer). I need a piece of code that would pull the 17 or 18 from current work calendar.. if I use Format(Now(), "yy")...

Hi all, I'm quite new(bie) on writing XML files, so i'm hearing here to see if anyone can help (teach) me some tricks. I have following code to write a "basic file". It is to transfer vehicle data to the authorities in Germany, therefore there is some German in it. Point is, I do NOT want to...

Using VBA, I want a timestamp to show as 7/6/18 15:09 but when I use this code Range("BD3").Value = Format(Now(), "m/d/yy hh:mm") it comes out as 7/6/2018 15:09. But if I change it to: Range("BD3").Value = Format(Now(), "m.d.yy hh:mm") it comes out as 7.6.18 15:09 What is it about...

I am a beginner at VBA and am trying to create a button that will open a message box notifying the user he is about to save a pdf copy of the workbook. If Yes, it proceeds to verifying whether the dynamic directory exists (creates if not), then saves the file there. If No, simply does nothing...

I'm using VBA for EXCEL. I'm also new to using it and this board. All I'm trying to accomplish is that when a user inputs his/her initials in cell D5 the current time plus 1 hour will be inputted in C5. I do this repetitively until cells o62 and P62. I have repeated my code below to do...

Hello, Why doesn't this work? The error is in the line that starts with ChDir abc & ""... abc = "C:\a\b\c" f = Range("A1") Sheets("1").Select ChDir abc & "\" & f & "\" & "\g" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "a" & "_" & f & "_" &...

Hello excel friends, I have an issue trying to make a button to send an email containing a PDF of a certain range on a certain sheet. The purpose is to send the worksheet to others, so that they can then fill in the sheet and send the information that i want from them back to me by simply...

Hello. I am trying to create a macro that every time I close the file the macro makes a copy of that file. So far I have this but it still does not work well. Someone can help me? Thank you, Isabel Sub auto_close() If ThisWorkbook.Path = "\\Servidor\servidor\ORÇAMENTOS\orç - A Fazer"...