Posts by Dovrox

Re: Starting path for open dialog

Thanks Badger

Is it possible to set the starting path for the open dialog - using expression.GetOpenFilename so that the contents of the correct folder are visible immediately??

Just want to know how to send an email message from vba without having to specify outlook or express etc.
Have tried Ron De Bruin's CDO but all I get is an automation error.
Any Ideas greatly appreciated.

Re: UserForms - message box - tests

What happens if you use = "" in place of =null.

Re: Listbox to choose a file to process.

Many Thanks - pretty or not pretty - your code is excellent.
I was coming short counting the files and re-dim the array.
Many Thanks from South Africa. :thanx:

Re: Data Sort with Protected Worksheet

When you are protecting a sheet you state what a user will be allowed to do. One of the options is "sort".
Try unprotecting the sheet and protecting it again allowing sort by clicking on the sort checkbox that is a little bit further down on the list.

I am looking for a solution to a simple problem. There are 2 folders on my c drive containing jpg files. Approx 150 files in each folder. The files in folder1 have been modified and compressed by one group of students. The files in folder 2 have the same names as the ones in folder 1 and have been saved by a second group of students attempting to show their artistic talent.
What I am looking for is the code that would fill a multi column list box with the following data.
Col 1 = Filename
Col 2 = Filesize from folder 1
Col 3 = Date modified (that file)
Col 4 = Filesize (same name file from folder 2)
Col5 = date modified (file from folder 2).
Any Ideas greatly appreciated - have been getting not far.

How can additem be used to add lines to a multi column list box - assume col1 = age and col2 = surname.

Re: Close modified sheet without "wish to save" dialog.

Thanks Dave Hawley on worksheet before close.

I have a sheet that modifies itself with data from a database.
On closing it always offers the dialog re save changes??
Any ideas on how to close after changes without the dialog..

Re: Date Functions on Userform

Roy - exactly what I was looking for - Many thanks from South Africa.

Please can anyone give ideas on a userform with simple date functions like having a button to add a day to a date on the userform and calculating qty of days between dates on a userform.
Many Thanks.

Unable to get the vba right to use range and cells together.
ex :
for X = 1 to 10
activeworkbook.worksheets("a1").range(cells(x,3),cells(x,5)).copy
do something else
next X

-it must be something like this but can't get the vba right.

Re: move data from a text box on a user form to a text box on a worksheet in another open

Think I have found solution - VBA search on the word TEXTBOXES comes up blank but the textboxes collection is the answer instead of the OLEobjects that I was trying to use. Many Thanks for your time - Cheers from South Africa

Re: VBA to import saved Userform

Andy - You are a star - I can see where I was going wrong......
MANY THANKS :thanx:

Re: VBA to import saved Userform

Thanks Andy - how would vba remove it ????????

Re: move data from a text box on a user form to a text box on a worksheet in another open

looking for the code - ---

Have done much searching - even Chip Pearson's page - any ideas what VBA is used to import a saved user form ??????

Re: move data from a text box on a user form to a text box on a worksheet in another open

Have one open workbook with user forms - user forms have check boxes and text boxes and a button to process the data - when button pushed vba opens relevant workbook at correct worksheet but unable to transfer the text from the userform textbox to a textbox on the now opened relevant worksheet. am using oleobjects but keep getting error cant find oleobjects method of workbooks class.

Using one worksheet with user forms to open other worksheets and update info in their sheets - but struggling to use text box this way.