Search results

If you want to save a range as HTML table on HTML webpage. Here is the code Download Working File https://www.box.com/s/7h58p020dasqcp01ayov Sub send_range_as_html_table() ‘ used to insert a line ( press enter) ‘ create a table using html ‘ check the link below to know more about html...

If you want to find Latitude and Longitude of any address . Download Working File https://www.box.com/s/h733p8zufxkkum8nsi2d Here is the UDF Function lat_lon(a_t As String, c_t As String, s_t As String, co_t As String, z_t As String) Dim sURL As String Dim BodyTxt As String Dim apan As...

Try this Free Excel Add -in http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html Hope you will like it

Try this Free Excel Add -in http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html Hope you will like it

If you want to get the names of all the folders in a directory/folder ( Excluding Sub folders).Try below code- Sub folder_names_in_a_directory_excluding_subfolder() Application.ScreenUpdating = False Dim fldpath Dim fso As Object, j As Long, folder, SubFolders, SubFolder With...

If you want to get the names of all the folders stored/created in a directory/folder ( Including Sub folders).Try below code- Sub folder_names_including_subfolder() Application.ScreenUpdating = False Dim fldpath Dim fso As Object, j As Long, folder1 As Object With...

Hello Everyone, My name is Ashish and I am from New Delhi India. This site is a great resource for learning charts.

If you want to add a new menu on mouse right click showing you the list of all open workbooks and worksheets in each of these workbooks. So that you can navigate easily. Add this to workbook Module Private Sub Workbook_Open() 'http://www.excelvbamacros.com/2012/04/blog-post.html On Error...