Thursday, January 9, 2020
Thursday, January 2, 2020
List of Domains
Vikram Shankar Mathur
RESIDENCE:
B-404, Shashwat Apartments
Atithi Dining Hall Lane
B/h GNFC Infotower, Bodakdev
AHMEDABAD-380054
LIST OF DOMAINS
- www.vsmathurcoin.com
- www.vsmathur.co.in
- www.vsmathur.in
- www.ahmedabadfca.org
- www.cavsmathur.net
- www.cavsmathurin.com
- www.cavsmathur.co.in
- www.ktvayedaco.com
- www.cavsmathur.co.in
- www.exceltrainerahmedabad.com
- www.vsmathur.org
- www.deadlyvbaprogrammer.com
- www.vsm1962.com
- www.vbacoder1962.com
- www.vbabeginner.com
- blog.vsmathurcoin.com
- shop.vsmathurcoin.com
- blog.exceltrainerahmedabad.com
- vsm.exceltrainerahmedabad.com
- vsmathur.exceltrainerahmedabad.com
- disa.exceltrainerahmedabad.com
- blog.cavsmathurin.com
Friday, December 27, 2019
20191226-Have you filed your GST Returns?
Sunday, September 8, 2019
Extreme Markup Editor for Blogger™: Syntax and Features
Extreme Markup Editor for Blogger™: Syntax and Features: If you are familiar with other markup languages like Markdown , understanding Extreme Markup is fairly easy. Like other text markup lang...
==========================================================================
Wow, this is really something that I could use, as a programmer myself !! :-) :-)
CA Vikram S Mathur
vsmathur380052@gmail.com
Created : 08-Sep-2019 | 23:15 Hours IST | vsmathur380052@gmail.com
Modified: 18-Oct-2019 | 09:10 Hours IST | vikramsmathur@gmail.com
==========================================================================
Wow, this is really something that I could use, as a programmer myself !! :-) :-)
CA Vikram S Mathur
vsmathur380052@gmail.com
Created : 08-Sep-2019 | 23:15 Hours IST | vsmathur380052@gmail.com
Modified: 18-Oct-2019 | 09:10 Hours IST | vikramsmathur@gmail.com
Saturday, September 7, 2019
vsmathur380052
========================================================================
CA Vikram S Mathur
(vsmathur380052)
========================================================================
CA Vikram S. Mathur
... We are basically into the practice of Accounting, Auditing, Income-Tax Return ... In May 1995, he began his practice as an Associate Chartered Accountant and upgraded to Fellow Chartered Accountant in 2002. in March'2006 he also
https://about.me/vsmathur
CAclubindia : Experts : Expert Profile
... DISA), a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi. The sole proprietorship firm is registered with the Institute of Chartered Accountants of India. Full Name:----- CA
http://www.caclubindia.com/experts/experts_profile.asp?member_id=28059
CA Vikram S. Mathur Profile - CA club india
... a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi. The sole proprietorship firm is registered with the Institute of Chartered Accountants of India
\http://www.caclubindia.com/profile.asp?member_id=28059
Accounting & Bookkeeping - Hotfrog INDIA
... Website of an Indian Chartered Accountant residing in Ahmedabad, Gujarat, India. ... Basically into the practice of Accounting, Auditing, Income-Tax Return Filing,
http://www.hotfrog.in/find/Accounting-Bookkeeping
Accounting Services in Ahmedabad
... Website of an Indian Chartered Accountant residing in Ahmedabad, Gujarat, India. ... Basically into the practice of Accounting, Auditing, Income-Tax Return Filing,
http://www.hotfrog.in/find/Accounting-Services/Gujarat/Ahmedabad
... We are basically into the practice of Accounting, Auditing, Income-Tax Return ... In May 1995, he began his practice as an Associate Chartered Accountant and upgraded to Fellow Chartered Accountant in 2002. in March'2006 he also
https://about.me/vsmathur
CAclubindia : Experts : Expert Profile
... DISA), a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi. The sole proprietorship firm is registered with the Institute of Chartered Accountants of India. Full Name:----- CA
http://www.caclubindia.com/experts/experts_profile.asp?member_id=28059
CA Vikram S. Mathur Profile - CA club india
... a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi. The sole proprietorship firm is registered with the Institute of Chartered Accountants of India
\http://www.caclubindia.com/profile.asp?member_id=28059
Accounting & Bookkeeping - Hotfrog INDIA
... Website of an Indian Chartered Accountant residing in Ahmedabad, Gujarat, India. ... Basically into the practice of Accounting, Auditing, Income-Tax Return Filing,
http://www.hotfrog.in/find/Accounting-Bookkeeping
Accounting Services in Ahmedabad
... Website of an Indian Chartered Accountant residing in Ahmedabad, Gujarat, India. ... Basically into the practice of Accounting, Auditing, Income-Tax Return Filing,
http://www.hotfrog.in/find/Accounting-Services/Gujarat/Ahmedabad
Sunday, August 18, 2019
VBA Macros: Create Hyperlink for filenames or folder names fro...
Source URL:VBA Macros: Create Hyperlink for filenames or folder names fro...:
Here is a easy way to solve my problem.
I create a hyper link in excel to only the specific sub folders which i have to check and open them by clicking the hyperlink.
Note: Please take care that the the list of folder names you want to create hyperlink is present in "Sheet1" and in Column "A" or else you can modify the code according to your need.
Provide the Main folder path in the Input Box when it pop ups.
For any assistance please post me.
Here is the code for hyperlinking.
****************************************************************
Code:
****************************************************************
Sub Create_Hyperlink()
Dim Path As String
Dim lastRow As Long
Dim rOffset As Long
Dim partialPath As String
Dim linkPath As String
Path = InputBox("Please paste the path to which the list should be hyperlinked")
Const SheetToPutLinksOn = "Sheet1"
Const ColumnWithFileNames = "A"
Const firstFilenameRow = 1
ThisWorkbook.Worksheets(SheetToPutLinksOn).Activate
Application.ScreenUpdating = True
partialPath = Path & "\"
lastRow = Range(ColumnWithFileNames & Rows.Count).End(xlUp).Row - _
firstFilenameRow
Range(ColumnWithFileNames & firstFilenameRow).Select
Application.ScreenUpdating = True
For rOffset = 0 To lastRow
If Not IsEmpty(ActiveCell.Offset(rOffset, 0)) Then
linkPath = partialPath & ActiveCell.Offset(rOffset, 0).Text
ActiveSheet.Hyperlinks.Add anchor:=ActiveCell.Offset(rOffset, 0), _
Address:=linkPath
End If
Next
ThisWorkbook.Saved = True
Application.ScreenUpdating = True
End Sub
****************************************************************
Here is a easy way to solve my problem.
I create a hyper link in excel to only the specific sub folders which i have to check and open them by clicking the hyperlink.
Note: Please take care that the the list of folder names you want to create hyperlink is present in "Sheet1" and in Column "A" or else you can modify the code according to your need.
Provide the Main folder path in the Input Box when it pop ups.
For any assistance please post me.
****************************************************************
Code:
****************************************************************
Sub Create_Hyperlink()
Dim Path As String
Dim lastRow As Long
Dim rOffset As Long
Dim partialPath As String
Dim linkPath As String
Path = InputBox("Please paste the path to which the list should be hyperlinked")
Const SheetToPutLinksOn = "Sheet1"
Const ColumnWithFileNames = "A"
Const firstFilenameRow = 1
ThisWorkbook.Worksheets(SheetToPutLinksOn).Activate
Application.ScreenUpdating = True
partialPath = Path & "\"
lastRow = Range(ColumnWithFileNames & Rows.Count).End(xlUp).Row - _
firstFilenameRow
Range(ColumnWithFileNames & firstFilenameRow).Select
Application.ScreenUpdating = True
For rOffset = 0 To lastRow
If Not IsEmpty(ActiveCell.Offset(rOffset, 0)) Then
linkPath = partialPath & ActiveCell.Offset(rOffset, 0).Text
ActiveSheet.Hyperlinks.Add anchor:=ActiveCell.Offset(rOffset, 0), _
Address:=linkPath
End If
Next
ThisWorkbook.Saved = True
Application.ScreenUpdating = True
End Sub
****************************************************************
Saturday, December 20, 2014
My First Post
Vikram S. Mathur & Co. |
Windows 8 / 8.1 Compatible |
Subscribe to:
Posts (Atom)
Featured Post
Best-Brief-Resume
BEST BRIEF RESUME
-
======================================================================== CA Vikram S Mathur (vsmathur380052) =======================...
-
Extreme Markup Editor for Blogger™: Syntax and Features : If you are familiar with other markup languages like Markdown , understanding Ext...
-
Vikram Shankar Mathur RESIDENCE: B-404, Shashwat Apartments Atithi Dining Hall Lane B/h GNFC Infotower, Bodakdev AHMED...