Search:

Type: Posts; User: mail2tradesmart

Search: Search took 0.04 seconds.

  1. Re: clear the data by vba macro

    Thnx Alot westconn1 Sir for helping me in solving this Problem Sir
    Have a Awesome Day Sir
  2. [RESOLVED] clear the data by vba macro

    Hi,
    Macro will be placed in macro.xlsm & book1.xlsx & Book2.xlsx are located at different place so the path of of both the files should be hardcoded in the macro

    If cells in column A of sheet1 of...
  3. Re: Looking to make this macro Faster

    Thnx Alot Both of u For ur Great Tips
  4. [RESOLVED] Looking to make this macro Faster

    Sub STEP16()
    Dim wb1 As Workbook
    Dim ws1 As Worksheet
    Set wb1 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\HotStocks\1.xls")
    Set ws1 = wb1.Worksheets.Item(1)
    With ws1

    ...
  5. Conditionally Run & move the .bat file shortcut(i.e .lnk file) by vba macro

    Public Declare PtrSafe Function ShellExecute _
    Lib "shell32.dll" _
    Alias "ShellExecuteA" ( _
    ByVal hwnd As Long, _
    ByVal lpOperation As String, _
    ByVal lpFile As String, _
    ByVal...
  6. Re: [RESOLVED] Copy & Paste if condition met with add & subtract

    Problem Solved
  7. Re: [RESOLVED] Cut & paste the data to new sheet if condition matches

    Problem Solved
  8. Re: [RESOLVED] If column C has blank cell then delete that entire row in two files(ma

    Problem Solved
  9. [RESOLVED] Copy & Paste if condition met with add & subtract

    Hi Experts,
    I am looking for a macro that will do the things mentioned below

    there are 3 files 1.xls & BasketOrder.xlsx & macro.xlsm (macro will be placed in macro.xlsm),both files are loacted in...
  10. Re: If column C has blank cell then delete that entire row in two files(macro correct

    If there is any blank cell in column C then it will delete that entire row
    this macro checks both the file one by one & if condition met it should delete that entire row & if condition not met then...
  11. Replies
    2
    Views
    2,467

    Re: Close.xls file by a macro

    Thnx Alot Westconn1 Sir for helping me in solving this problem
    Problem Solved
    Have a Awesome Day
  12. Re: Cut & paste the data to new sheet if condition matches

    Sub PART1()
    Dim wb As Workbook, output As Worksheet, rng As Range, rw As Long
    Set wb = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\1.xls")
    rw = 2
    With wb.Worksheets.Item(1)
    .Cells(1,...
  13. [RESOLVED] Cut & paste the data to new sheet if condition matches

    Hi Experts,

    I am looking for a macro that will do the things mentioned below
    macro will be placed in macro.xlsm,both files are located in different places so the path will be hardcoded in the...
  14. Replies
    2
    Views
    2,467

    [RESOLVED] Close.xls file by a macro

    Hi Experts,

    I have a problem & looking for a macro that will do the below things

    I downloaded an .xls file, as soon as file is downloaded it opens up automatically & I have file name...
  15. Re: If column C has blank cell then delete that entire row in two files(macro correct

    If in any of the file if sheet1 is blank then close that file
    sheet name can be anything
    this will be the perfect solution for this problem & this modification i need
    Thnx Westconn1 Sir for...
  16. Re: [RESOLVED] (Different Macro) if sheet is blank then do nothing(macro modification

    No Problem Jdc2000 Sir this problem I will manage it & it's manageble
    I saw the link given by you
    Plz have a look to other post
    Leave this problem for me, i will take care of this
  17. Re: (Different Macro) if sheet is blank then do nothing(macro modification)

    Skip this problem
    I have another idea
    I will make the data be present in the sheet
    Problem Solved
    Thnx Alot Jdc2000 Sir for helping me in solving this problem
    Have a Awesome Day
  18. Re: (Different Macro) if sheet is blank then do nothing(macro modification)

    I used a line

    If ActiveSheet.IsBlank Then Exit Sub Got error

    If WorksheetFunction.CountA(ActiveSheet.UsedRange) = 0 Then Exit SubGot error
  19. Re: (Different Macro) if sheet is blank then do nothing(macro modification)

    jdc2000 Sir i tried to modify the code but i am unable to make it perfect sir
    Plz have a look Sir
  20. Re: (Different Macro) if sheet is blank then do nothing(macro modification)

    Jdc2000 Thnx Alot Sir for ur Great Help
    But Do not consider cell A to check wheather it has blank sheet or not (there may be data in the sheet, So if complete sheet is blank then only it shoud exit...
  21. Re: If column C has blank cell then delete that entire row in two files(macro correct

    Sub STEP11CORRECTIONPENDING()
    Dim arrWbs() As Variant
    Let arrWbs() = Array("C:\Users\WolfieeeStyle\Desktop\Files\BasketOrder.xlsx", "C:\Users\WolfieeeStyle\Desktop\Files\Error.xlsx")

    Dim Wb As...
  22. [RESOLVED] (Different Macro) if sheet is blank then do nothing(macro modification)

    Sub STEP6CORRECTIONPENDING()
    Dim Wb1 As Workbook, Wb2 As Workbook
    Dim Ws1 As Worksheet, Ws2 As Worksheet
    Dim Lr1 As Long, Lr2 As Long: Let Lr1 = 5000: Lr2 = 5000
    Set Wb1 =...
  23. [RESOLVED] If column C has blank cell then delete that entire row in two files(macro correction)

    Hi Experts,


    Sub STEP11CORRECTIONPENDING()
    Dim arrWbs() As Variant
    Let arrWbs() = Array("C:\Users\WolfieeeStyle\Desktop\Files\BasketOrder.xlsx",...
Results 1 to 23 of 27



Click Here to Expand Forum to Full Width