excel macro coding

  1. M

    Saving in a new working book VBA

    Sub Saving(ws As Worksheet) Dim dt As String Dim wbNam As String Dim sFileSaveName As Variant wbNam = "Salesforecast_" dt = Format(CStr(Now), "dd_mm_yyy_hh_mm_ss") sFileSaveName = Application.GetSaveAsFilename(InitialFileName:=wbNam & dt, fileFilter:="Excel Files (*.xlsm), *.xlsm") If...
  2. A

    VBA - Set Object within If Statement

    So, I created a series of formula on a sheet called Extractor in a workbook called "Processor*". The filename of the workbook "Processor*" will usually vary, having other characters to the right of it. My intention is to copy the range covering all formula I created in a sheet named "Extractor"...
  3. S

    Excel formula to Automatically put series on Patterns

    Hi, I'd like to ask help with excel. Is it possible to detect which comes first? example: John smith took his break 3 times a day, how can i identify the first break and the other 2, like is it possible that a formula can Make it like Break 1, Break 2, Break 3?
  4. CKinTX

    Excel VBA Script to Access Files on an SFTP Site

    Good morning, all - I download files from an SFTP site, but the files don't always have a unique name. Files on the site have a naming convention of File_Name.xls for the first file in the group and File_Name_X for each subsequent file in the set where X is an incrementing value from 1 to the...
  5. A

    Please help with Macro

    Hi all, I have a CSV file I need to open using notepad then import into exce when importing I need to convert Column X to text. The specific steps must be followed because if you do not open the CSV file with the notepad column X ends up with scientific notation due tot he long string of...
  6. U

    Table of Content: Count all pages per TAB, continue on next TAB with page number

    I have a workbook with 40 sheets, I have created query that should provide a Table of Content. What I need is the query to provide the page in sequence with the next TAB providing the next PAGE number, "not the total amount of pages". In other words, if my Executive summary has 3 pages in...
  7. T

    Sending emails to multiple recipients with multiple PDF files via VBA & Excel

    I'm very new to VBA and found a code online that sends emails to multiple recipients but can only attach 1 file per email. I cannot find a code that works wherein it goes to a specific folder and attaches all PDF files that are stored in the folder and goes to a different folder and does the...
  8. D

    Is it possible to extract strings from a Multi-Line TextBox?

    Hi, I have an Multi-Line ActiveX TextBox1 that has the below strings as separate lines: 'Cat' 'Dog' 'Snake' 'Bear' 'Dragon' I have TextBox1 linked to a single cell, so that it will output these lines to one cell. I'm trying to figure out a way (if indeed it's even possible) to output each...
  9. S

    Unable to use Macros when worksheet is locked

    Good day, I'd like to ask for your kind assistance please, I couldnt use the macros on this sheet when i lock the worksheet is there a work around on it?, even if I sent the macros unlocked. can anyone help me please thank you so much. below are the Macros i use in a sheet. Sub Resolved() '...
  10. S

    Currency Converter to Different excel

    I have two excel first excel output file and second excel Exchange rate excel, first check in second excel date column and pick every month 1 date exchange rate and convert in Main file currency in (INR,USD,EUR) convert in GBP format. 1: Main Output file : Empno Ename...
  11. S

    Currency Converter to Different excel

    I have two excel first excel output file and second excel Exchange rate excel, first check in second excel date column and pick every month 1 date exchange rate and convert in Main file currency in (INR,USD,EUR) convert in GBP format. 1: Main Output file : Empno Ename...
  12. V

    Excel Macro Asking for credentials constantly

    Hello, Below is my code which I am working on. It is running but keeps prompting for user windows credentials. Can anyone tell me how to stop that.? Do I need to any line of code to stop asking for credentials or pass credentials through code. Sub testit() Set shFirstQtr =...
  13. P

    Start autofill based on non-defined cell

    Hello friends, After searching all over the internet, I have a VBA code here which copies cell AG2 and pastes the data into the first empty cell in column AG. The same process repeats for cell AB2 for the second line. Range("AG2").Copy Range("AG" & Rows.Count).End(xlUp).Offset(1, 0)...
  14. F

    Macro to compare

    Hi I have a excel sheet in which i have to compare a UID and qty in one sheet to another sheet. I do this every morning however it is very tedious and i thought a macro would be best so i could just run it as i could get 100s of records. Record Sheet UID QTY Shipped 1...
  15. H

    Editing VBA that uses tables to generate email

    Hello all, I believe long ago I found on this forum a very helpful VBA code for sending an automatic email from data that was contain in a table structure in excel. I would like to use the same characteristics (i.e: referencing data from certain rows and based off expiring dates) but I no...
  16. B

    Multiple Autofileter in Excel macro

    Hi Team, I use to run a report daily of my clients. Hence i am trying to create a Macro for the same. While creating i face some difficulty. My data includes Name of clients in 1 coloumn and there comments in 2 coloumn and so on... I want macro to search a specific word for example "Good"...
  17. J

    Create individual Text file from each Excel 2003 row using Macro

    Hello !! I am completely new to VBA. Can someone from community help me achieve following. I have an excel 2003 worksheet with three columns data as follows: <tbody> SYMBOL LISTING_DATE FV 20MICRONS 06-Oct-08 5 3IINFOTECH 22-Apr-05 10 3MINDIA 13-Aug-04 1 8KMILES 29-Jan-14 10...
  18. S

    removing duplicate rows in excel using vba based on constraints

    Hi I have a requirement where the duplicate rows has to be removed from a range of columns. Example input: RowNo emplid firstname phonetype phonenum rownumber deptid deptname joindate rownumber 1 1001 abc home 88888 1...
  19. S

    How to compare two coloumns and restrict it values to be entered

    Dear experts please help I have two column submit date and recived date in excel 2010, I want to put restriction on recivd date coloum. <tbody> submit date recived date <tbody> 16-Feb-13 </tbody> <tbody> 8-May-13 </tbody> <tbody> 6-Nov-13 </tbody> <tbody> 20-Jun-13...
  20. A

    VBA Hide Text

    =

This Week's Hot Topics

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
Top