-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
nxtrw.value
-
L
File Path By Year and Month
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...- Legacy 436357
- Thread
- folders formatnow nxtrw nxtrw.value wfile
- Replies: 3
- Forum: Excel Questions
-
L
Name of PDF From Cell Value
Hello, I have a cell value that I would like as the PDF file name plus today's date included in the name. For instance: HAN6597 8/12/2019 Is this possible to do? Also what if the same customer code (in cell H2) and same date are sent to PDF more than once? Does the PDF get replaced or...- Legacy 436357
- Thread
- cell code nxtrw nxtrw.value pdf
- Replies: 14
- Forum: Excel Questions
-
L
Add PDF to Button
Could print to PDF be added to this button? My print area is B2:H53 Private Sub CommandButton1_Click() Dim NxtRw As Long Application.EnableEvents = False If Range("J3").Value = "" Then NxtRw = 3 Else NxtRw = Range("J2").End(xlDown).Offset(1).Row End If Range("J"...- Legacy 436357
- Thread
- application.enableevents nxtrw nxtrw.value print
- Replies: 17
- Forum: Excel Questions
