Search results for query: *

Use the FileSystemObject - check out its properties Cheers Nikki [bat] Look, mommy, I'm flying!

Hi What controls do you have on your form? Or is it just the combobox? Cheers Nikki [bat] Look, mommy, I'm flying!

Hiya, shot in the dark - but do you perhaps have another instance of Excel running on the machines where you get the error (check all active threads) I've had this happen to me as well & it turned out to be due to me not properly releasing my Excel objects. Went through the code & made sure I...

Hiya, You can use the DataObject to write to and read from the Windows clipboard. You'll need to set a reference to MS Forms 2.0 in your project (use Tools > references in the VBA editor), then use code like this: Public Sub EmptyClipBoard() Dim myClipboard As New DataObject Dim...

MrsTFB, be specific when you refer to a range object - i.e. use the X.Worksheets("name") object in front of your range HTH Cheers Nikki [bat] Look, mommy, I'm flying!

Andrew, you can use the Worksheet_SelectionChange event to pick up the old value. Store it somewhere on a hidden sheet & use it when needed HTH Cheers Nikki [bat] Look, mommy, I'm flying!

of course that *should* read: "Chip Pearson's useful site" D'oh (Not that Chip isn't useful himself) Cheers Nikki [bat] Look, mommy, I'm flying!

Hiya, have a look at useful Chip Pearson's site on Worksheet events: http://www.cpearson.com/excel/events.htm Cheers Nikki [bat] Look, mommy, I'm flying!

Andy have a look at this site: http://www.outlookcode.com/d/newdefaultform.htm It explains the 2 steps necessary to make a new form the default for both new & existing items. There's code samples available as well HTH Cheers Nikki [bat] Look, mommy, I'm flying!

and here *IS* the following link ... http://www.avdf.com/apr98/art_ot003.html (sorry - long hard day yesterday ;-)) Cheers Nikki [bat] Look, mommy, I'm flying!

Hi innov, Looking at your code I think your main problem is the use of the WorkSheetFunction. You've gort a few alternatives to the Match approach: since you use MatchType = 0, you could simply use FIND instead of match to get you the same result Change ent_col =...

thom just specify the index of the slide you want to insert: ActivePresentation.Slides.InsertFromFile "YourFileName.ppt", ActiveWindow.View.Slide.SlideIndex, 5, 5 [/code will insert slide5 [code]ActivePresentation.Slides.InsertFromFile "YourFileName.ppt", ActiveWindow.View.Slide.SlideIndex, 5...

thom, use ActiveWindow.View.Slide.SlideIndex to return the slide index number (long) of the slide currently visible in the active presentation. ActivePresentation.Slides.InsertFromFile "<FileName.ppt>", ActiveWindow.View.Slide.SlideIndex HTH Cheers Nikki [bat] Look, mommy, I'm flying!

Walter349 Try using the Find method: this returns a range object if the value yoou search for is found. e.g. searching for the contents of Sheet1 Cell A1 on Sheet2: Dim l_wksFindValue As WorkSheet Dim l_wksSearchIn As WorkSheet Dim l_rngRangeFound As Range 'Set the worksheet objects Set...

[rofl] Thanks, Tony, I guess M$ could stand to learn a lot about the use of proper English - shall we point the Making an Impression forum out to them? Cheers Nikki [bat] [b]Look, mommy, I'm flying![b]

Jens, if your aim is to freeze the screen whilst the macro is running why not use Application.ScreenUpdating = False at the start of your macro, and Application.ScreenUpdating = True at the end of your macro The macro will run without updating the screen; if you want users to view macro...

Hiya docjohn, Tony, This from Excel 97 Help function: Even if the Help function is incorrect here, you're right that it's best practice to switch it back on anyway. I know of at least one occasion where I closed a newly-debugged tool without getting the "Do you want to save changes ... "...

docjohn, not quite sure which of the following you need: ActiveWorkbook.SaveAs <Path&FileNameHere> will save the active workbook using Path&FileNameHere Alternatively, use Application.DisplayAlerts = False to switch off all Excel message boxes to the user. Then run your code, and use...

Hiya should the contents of the cell be numeric, use =INT(<CellAddress> to get the date, and =<CellAddress> - INT(<CellAddress>) to get the time HTH Cheers Nikki [bat] [b]Look, mommy, I'm flying![b]

Hiya, apologies for not answering earlier: it's silly season with Bank Holidays over here ... I've adapted your Sub slightly & tested it on out LoNo PCs. Using LoNo R5.0.8 but dunno whether any patches or whatnots have been installed (I'm just a programmer & not very admin-minded) The code...