Posted on

code for vish

 

Posted on

Copy Chart from Excel to Powerpoint PPT

‘Copy Charts from Excel to Powerpoint

 

Posted on

Insert Chart in Excel using VBA

Insert Chart into Excel using VBA and Add Source Data to it, There Position height and Width.

 

Posted on

Convert String to Number or Number to String

 

Posted on

Connection Excel to Excel

This is example of connection from Excel to Excel Where Excel File will be considered as Database and There Sheets will be considered as Table, Where you can put SQL Command and work. There are 2 Example Given

Reference : Click Here

 

Posted on

All Subfolders and File from Folder

Pick all file from folder  and get extension if needed and list out all folder from main folders.

 

Posted on

Excel to Access using VBA

This Piece of Code will help for Data Entry from Excel  to Access and Update  and Fetch data from  Access

 

 

Posted on

Folder Access Provider

This code will help you to provide and Remove folder access, For this you should have Admin Access to that Folder.
Declaration:-

Add this code to the Userform

Add this code to the Module

 

 

 

 

 

 

 

 

Posted on

Zip and Unzip

This code will help you to ZIP and UNZIP  folder from Excel VBA