vbcrlf

  1. B

    Convert cell data to html

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

    Create New sheet and add VBA code

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

    Tab spacing and border around textbox.value for email and change date to english format not american?

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

    sending email of user form details

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

    VBA - Send email with attachments to range (row by row)

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

    create pdf and email

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

    Compile Error For without Next

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

    Looping a worksheet change event

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

    Times Message Box - Timer stopped working

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

    VBA working to send an email, doesnt error but doesnt send

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

    VBA Code Update Help

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

    Save as PDF and send email

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

    Need help converting early binding to late binding with excel to outlook vba

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

    check if value exist in table, if not then....

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

    Body Message

    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"...
  16. J

    Excel VBA open folder and get GPS info (Exif) of each files in it

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

    MsgBox problem

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

    Outlook Signature

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

    VBA - Send Excel Userform Data to Outlook Email

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

    Formatting of Time in message box

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top