vbcrlf

I'm trying to use the code below to convert data in my worksheet to html. I tried pasting in visual basic, but when I highlight and run, I get an error (can't execute in break mode). Beginner, so please let me what I'm not doing here. Thank you! My objective is to be able to convert cell data...

Hi I have 2 bits of code which as individual codes work well however I have tried to join together with no success. I keep getting error 400. My first bit of code creates a new sheet for every vehicle in a list on sheet (To Hide) for the year in-putted via an InputBox it then renames the sheet...

Hi, i have the code below i was wondering if you can help me with it please, i have entered textbox18, textbox19, and textbox20 anfd this brings back the date into the email but it is in american format how can i change this please in the code? Also after each textbox i have entered a vbtab, but...

Hi all, I am trying to send multiple sections of my userform as email the current code I am using (below) works but if I try and add more code in to add say SYSTEM 2 DETAILS it would no longer show SYSTEM 1 DETAILS on the email and just the latter. Private Sub CommandButton1_Click() Dim...

Hi, I have a spreadsheet which I seek to list client email address details etc. Due to a shortfall in our finance system. I seek to email attachments based on this info. I am having difficulty getting code to attach the specified attachments to emails (attachments are specified in Columns...

Good morning, I've used code below with previous versions of excel with no problems, but now that we have changed to Office 2016, it doesn't seem to work. Here is the code that should create a .pdf and send it via email, without it being displayed: Sub Create_and_SendPDF_Sheet1() Dim...

Hi, I have this error message just popping everytime but I don't see wht , can you help me: If Application.Workbooks.Count = 0 Then MsgBox "No files open to process" Exit Sub End If If ActiveSheet.Type <> xlWorksheet Then MsgBox "You can only run...

Hello all Im ok at writing some simple code in vba but when it comes to looping the code I always screw it up! I have a code that is working and doing what I want it to do, except I have to re write this for 10000 cells! which is extremely time consuming, as you will see I have shown the exact...

Good afternoon, I've had a timed message box that we have been using for years in some of our excel files and all of a sudden the timer functionality has stopped working. The yes, no buttons are fine but the timer is not. Any ideas on why this would stop working and how to fix? Thank you...

Good Afternoon, With help from people on here and Google I have created VBA to issue an email based on a form that is completed. The VBA runs (stepped through) with no errors but doesnt send anything via Office. I am using Excel 2016 I think, but I am missing something but I am unsure what it...

Hello, I don't post frequently to this board and I have limited VBA knowledge. I have an Excel file I use to bill customers with. I am using some code I saw on these forums to automatically generate an email from Excel with a PDF of the invoice. I have that working now over the last day or so...

Hello, I am new to forum and also a beginner at VBA. I am trying to run the following code and I get a compile error "Sub or Function not defined. Any help would be appreciated. <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family: Consolas, "Bitstream...

So over the past two weeks, I have taught myself a decent amount of VBA in order to create a spreadsheet for my department. The basic idea of the excel is to take user entered information then with the check of a box have excel, through VBA, create or cancel a meeting on a shared outlook...

Hey I have a table in access called Log_Table Id like the user to press a button that checks if the value "KLAR" is in the column named "HRWEBB CHECK" How do i do this? Ive done it with Excel, but dont know how to make this code work in access (code from excel, how to make this work in...

I have this code and worked fine with all your help, the problem having now that i have table that i want it to be displayed in the body message and and have this line of code but when executed got run-time error 13, please help: but this is the line giving the problem: Email_body = "" & "Hi"...

i came across this code of another webpage and i keep getting an error saying object required, i have followed all the instructions for this "expert" but it will not work, any help?? That is fairly sophisticated code -- written by Wayne Phillips who is a certified Microsoft MVP. While it...

Hello all, I have a problem with my VBA, maybe you can help me. Everything is working fine, but even if XXX!D13 =0, i still recieve an empty message with "ok" button. How can i change the vba, so that in case XXX!D13 is zero, not to have any message. This is my VBA: Dim msg AsString If...

i Have this code and not error message when executed but it doesn't get the signature in the email, please help. here is the code: ' Create a PDF from the current sheet and email it as an attachment through Outlook Dim EmailSubject As String, EmailSignature As String Dim CurrentMonth As...

Hello All, I want to send the entry from a userform to an email box. I have everything set up correctly. But the code is only sending the "entries" and not the labels, etc. See below:[ CODE]Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application") Dim olmail As...

Hi all, So, I've got a message box that will pop up to tell the user what ingredient to add, and how long it will have to mix for. However, the time (which should be displayed as minutes, like 2:00) shows up as 8.333333333333E-2 (or something like that). I've checked the formatting of the...