Split Excel workbook into multiple file VBA Code: Sub splitbook() 'updateby educational revolution Dim xpath As String xpath = Application.ActiveWorkbook.Path Application.ScreenUpdating = False Application.DisplayAlerts = False For Each xws In ThisWorkbook.Sheets xws.Copy Application.ActiveWorkbook.SaveAs Filename:=xpath & "\" & xws.Name & ".xlsx" Application.ActiveWorkbook.Close False Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub
Posts
Showing posts from July, 2023
- Get link
- X
- Other Apps
ICAP QAT Questions | Number system 1. Which one of the following is not a prime number? a) 31 b) 61 c) 71 d) 91 Explanation: 91 is divisible by 7. So, it is not a prime number. 2. What least number must be added to 1056, so that the sum is completely divisible by 23 ? a) 2 b) 3 c) 18 d) 21 3. Every rational number is a - a) Whole number b) Real number c) Natural number d) None of the above Explanation: The numbers which can be found on the number line and include both rational and irrational numbers are known as real numbers, e.g., -1.5,√2,0,1,2,3,π.Almost any number which you can imagine is a real number. 4. How many of the following numbers are divisible by 132 ? 264, 396, 462, 792, 968, 2178, 5184, 6336 a) 4 b) 5 c) 6 d) 7 5. Between any two numbers, there are - a) Two rational numbers b) No rational number c) Infinite rational numbers d) None of the above Explanation: There are infinite rational numbers in between any two numbers. 6. What is the mean of first 10 Pr...
Oxford 3000 Word List Level A1 - B2 Cerf Part 4
- Get link
- X
- Other Apps
Part 1 , Part 2 , Part 3 , Part 4 Oxford 3000 Word List Level A1 to B2 Part 4 CERF Level (B2) Word List. abroad بیرون ملک acceptable قابل قبول accurate درست actual حقیقی additional اضافی advance پیشگی agency ایجنسی agenda ایجنڈا aid امداد angle زاویہ approve منظور کرنا artificial مصنوعی artistic فنکارانہ ashamed شرمندہ associate ایسوسی ایٹ associated منسلک association ایسوسی ایشن assume فرض کریں bacteria بیکٹیریا barrier رکاوٹ bear(deal with) ریچھ (کے ساتھ ڈیل) basically بنیادی طور پر blame الزام budget بجٹ bullet گولی cancel منسوخ cancer کینسر calculate حساب لگانا capacity صلاحیت chairman چیئرمین characteristic خصوصیت citizen شہری civil سول closely قریب سے combination مجموعہ comfort آرام commonly عام طور پر complicated پیچیدہ component جزو concept تصور confidence اعتماد construction تعمیراتی contract معاہدہ contribute شراکت contribution شراکت c...
Oxford 3000 Word List Level A1 - B2 Cerf Part 3
- Get link
- X
- Other Apps
Part 1 , Part 2 , Part 3 , Part 4 Oxford 3000 Word List Level A1 to B2 Part 3 CERF Level (B1) Word List. academic تعلیمی access رسائی account کھاتہ achievement کامیابی act عمل addition اضافہ administration انتظامیہ admit تسلیم advanced ترقی یافتہ advise مشورہ afford برداشت کرنا agent ایجنٹ agreement معاہدہ aim مقصد alarm الارم album البم alcohol شراب alcoholic شرابی analysis تجزیہ announce اعلان announcement اعلان apologize معذرت خواہ application درخواست appointment تقرری approximately تقریباً arrest گرفتاری atmosphere ماحول attach منسلک authority اقتدار automatic خودکار automatically خود بخود balance بقیہ bank(river) کنارے (دریا) base بنیاد basic بنیادی battery بیٹری battle جنگ beauty خوبصورتی bee شہد کی مکھی bell گھنٹی bomb بم border سرحد branch شاخ brave بہادر bubble بلبلا bury دفن cable کیبل candidate امیدوار cap ٹوپی captain کپتان...