excel vba 2007

  1. C

    How to execute the ".bat" files using excel VBA !?

    Dear all, I was created a macro VBA to run ".BAT" files so I can copy some documents with different formats into excel. When I try on my ".BAT" files created by execute it manually was running fine without any problems. However, I was failed to get my results when I tried to execute the ".BAT"...
  2. S

    Multiple file export options

    Hello everyone, I am trying to find a way to simplify generating multiple "individual profiles" in excel. I have been made aware that we are doing this manually at the moment and I would like to automate the process a bit. The individual profile has 3 excel tables and currently the profile is...
  3. R

    How to send email from excel using VBA with Cell Range (Including Images) as Email Body

    I want to send email from excel using VBA with Cell Range (Including Images) as Email Body, I have below code to send email as HTML body every this is coming to email body (formats & fonts) but Images are not displayed in email body. getting error "The image cannot be displayed. Your computer...
  4. N

    Creating labels

    Hi everyone, I am trying write VBA code in excel 2007. I am not able to define my problem. I am illustrating it as, I am trying to create a different set of codes to be executed when i give reference of it, like Dim Alpha as long Alpha = Range("A1").value 'now here i want to give the reference...
  5. S

    Copy data from multiple sheets in a workbook to one sheet in the master workbook- VBA

    Hi, This is my problem and i hope I can get help with this. I have about 10-15 files in a Folder, here is the link to the folder "C:\Users\Gloria\Documents\Trade Data Capture". This folder also includes the Master workbook. Each workbook has 3 tabs "Inter-member Trades", "Client Trades" and...
  6. K

    EXCEL VBA - Problem to search an email in Outlook folder

    Hi All, I have a code for EXCEL VBA that searches for email messages in certain folder of Outlook ( both 2007 version). However, the comparison starts from the lastest email in the folder and not from the first email. ( in Outlook, I prefer to keep the email messages sorted as Newest first and...
  7. J

    1 text row to single column

    I have problem in making this. format in a text file Note: The text is only on A1, separated by a delimiter indicator which is "^" https://docs.google.com/file/d/0B_eArBbGfxv4OTJ2YTlDaFBnZDA/edit?usp=sharing To this . . . after text file multiple import to excel As you can see in the image...
  8. N

    How to take care of empty cells in Excell

    Hello, I want to send email to list of users which are stored in Excel from A1 to A10. But if suppose if any of the cells from A1 to A10 is empty then it gives error.. how to take care of empty cells?? Function SendMail() Dim y As String y = Sheets(1).Range("A1:A10").Value ' Copy the...
  9. M

    VBA Code to pass through Oracle Credentials

    Hello, I have read permission on two or three oracle tables that I've lined to in MS Access plus a 8 - 10 tables that are maintained in the same MS Access Dbase. I'm using Excel's table query function to open and run 12 separate queries as part of a daily reporting process - it queries the...
  10. S

    Excel VBA Help. Assigning Alternating Names to Alternating Rows in Range

    Hello, Very new to VBA writing but am catching on fast. Below is the link to a macro enabled spreadsheet that I have been working on. So far all that I have written works but now I am down to the last part where I essentially would like to take the names from a list and assign them to the rows...
  11. D

    Run time error 1004:A table cannot overlap a range...

    <TABLE><TBODY><TR><TD class=votecell></TD><TD class=postcell>I used the macro recorder in Excel 2010 to record the code below. The code is supposed to use a .iqy to pull data from a SharePoint 2010 site. When I run the macro, I receive the following error: A table cannot overlap a range that...
  12. R

    Copy a string of email addresses from Excel into Outlook TO: box

    The macro I'm using to copy a worksheet to the body of an Outlook email is working fine. Now I want to go to the worksheet ("volunteer list") and copy the email addresses in column D if the value of column A has an X in it then place that group of addresses in the TO: box of Outlook. Could you...
  13. J

    Changing existing macro to create and fill sheets based off a template

    This is what I'm using now: Sub DepartmentName() Dim LCopyToRow As Long Dim LCopyToCol As Long Dim arrColsToCopy Dim c As Range, x As Integer On Error GoTo Err_Execute arrColsToCopy = Array(1, 3, 4, 8, 25, 16, 17, 15) 'which columns to copy ? Set c =...
  14. L

    Finding row adress and passing it to countif function

    I have the following code which basically runs through an excel sheet and gives me the number of zeros in each column . I want to modify the code I also want to get the number of non-zeros in the first column and zeros in the second column. In other words, I have to filter zeros for column...
  15. N

    Code remains in VBA editor and does not return to datasheet view

    Hi there, I needed to add events to the Worksheet_change event. I was helped out with the following code: Sub CreateEventProcedure() Dim VBProj As VBIDE.VBProject Dim VBComp As VBIDE.VBComponent Dim CodeMod As VBIDE.CodeModule Dim LineNum As Long Const DQUOTE = """" ' one " character Set...
  16. G

    Write a sub procedure for a timetable

    I need help with this one, I am new to VBA and cannot figure out how to do this. I am using Excel 2007. What I need to do is take data from this table and have it generate a timetable. <table border="0" cellpadding="0" cellspacing="0" width="507"><col style="width: 107pt;" width="142">...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top