$$Excel-Macros$$ Update / Insert SQL Table from Excel Sheet

Dear Friends, I'm New to excel VBA, I'm trying to update/insert Sql Table from Excel. That is whenever i insert or update Excel Table it should automatically update/insert to SQL. Thanks, 7092063444 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Excluding holidays from a UDF

Hi, I have the following code that calculates the number of days (excluding Sundays) between two dates, and ideally I'd like to add another parameter to my function to allow me to exclude non-working days (in a similar way to the in-built NETWORKDAYS function - - NETWORKDAYS(start_date,end_date

$$Excel-Macros$$ Upper Left Coner Icon Backcolor of the Msgbox

Hello All, I have 2 Question... Please provide me some solution for those Question I: How to add an Icon at the upper Left Corner of the UserForm? I have tried using .ico File Question 2: How to Change the backcolor of the MessageBox? I tried as -- MsgBox.Backcolor = RGB(10,10,10