Search:
Type: Posts; User: mail2tradesmart
Search:
Search took 0.03 seconds.
-
Thnx Alot westconn1 Sir for helping me in solving this Problem Sir
Have a Awesome Day Sir
-
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...
-
Thnx Alot Both of u For ur Great Tips
-
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
...
-
Public Declare PtrSafe Function ShellExecute _
Lib "shell32.dll" _
Alias "ShellExecuteA" ( _
ByVal hwnd As Long, _
ByVal lpOperation As String, _
ByVal lpFile As String, _
ByVal...
-
-
-
-
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...
-
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...
-
Thnx Alot Westconn1 Sir for helping me in solving this problem
Problem Solved
Have a Awesome Day
-
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,...
-
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...
-
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...
-
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...
-
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
-
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
-
I used a line
If ActiveSheet.IsBlank Then Exit Sub Got error
If WorksheetFunction.CountA(ActiveSheet.UsedRange) = 0 Then Exit SubGot error
-
jdc2000 Sir i tried to modify the code but i am unable to make it perfect sir
Plz have a look Sir
-
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...
-
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...
-
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 =...
-
Hi Experts,
Sub STEP11CORRECTIONPENDING()
Dim arrWbs() As Variant
Let arrWbs() = Array("C:\Users\WolfieeeStyle\Desktop\Files\BasketOrder.xlsx",...
|
Click Here to Expand Forum to Full Width
|