VB 6.0
1 Add DriveListBox
2.Add DirListBox
3.Add FileListBox
Resize your above tools on form according to your need.
'''
Dear Group,
Any update on this ?
Regards...Abhishek
On Tue, Mar 30, 2010 at 1:51 PM, Abhishek Jain wrote:
> Dear All,
>
> I am working on a project where I've prepared an userform for creating
> Purchase Orders (PO). PO are Vendor wise, one PO for each vendor, no matter
> how many items are in
Great Kudos and blessing to Ayush Jain. You will have a great legacy for
helping others and sharing your candlelight. Indeed, sharing your light
with others do not diminish its brightness but multiply it.
On Fri, Apr 2, 2010 at 11:26 PM, ayush jain wrote:
> Dear Members,
>
> Thanks for all you
Hi Harry,
Further to what is below;
If you want VBA to recognise a paticular pen drive to the exclusion of any
other pen drive that might be plugged in, put a unique folder or two on your
pendrive and ask VBA to look for that path. eg:
ChDir"G:\HarrysUniqueFolder\HUFSubFolder1"
If VBA doesn't fi
Hi Harry,
The following code line will raise a 'Run-time error 76' error message if Drive
G is not present:
ChDir "G:"
VBA can use this to make a decision.
Here is a sample code:
Sub changedir()
On Error GoTo ErrorHandler
ChDir "G:"
'Your normal code goes here
Exit Sub
ErrorHandler:
On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar wrote:
> Hi Friends
>
is there any vba code to break excel file which has a password to open
Thanks
Nishant
>
> Today i am going to show you how to crack excel sheets password.
>
> Vba code to break password.
>
> Sub PasswordBreaker()
> Dim i As
Hello Team
Sorry for asking things out *EXCEL, *can anyone share sites/groups for MS
OUTLOOK.
Much regards
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twi
Dear Paul,
The attached file has monthwise stock level for various products.
I need to identify the cases where excess purchase (Stock received) without
any consumption (stock Dispatched) in successive months.
Eg: A Material having opening stock of 100 units in August. Stock
dispatched in Septem
Hi Gurus,
*Would it be possible to have VBA code to detect, whether a drive is
attached to the computer or not?*
**
The idea is to achieve the following objectives:
1) To detect, removable Pen Drive/Hard drive has been attached
with the computer or not? Eg: When i attach a pen drive on m
you can filter data with filter function
Lets suppose you have this data in sheet1
nameagesex
ashish28m
vishal25F
and you want to filter all the m in it goto sheet2 and write
=filter(Sheet1!A1:C3,Sheet1!C1:C3="m")
same ways u can
=filter(Sheet1!A2:Z;isBlank(Sheet1!F2:
Hi JavaOnLine
This method works always and you can insert any specific criteria
without limit...
Good luck. Let me know if it was useful...
Paul Willekens
'===
Sub ESTSearch()
Dim cValue
Dim lDoneA
Dim lDoneB
Dim nNumberA
Dim
11 matches
Mail list logo
