Search results for query: *

Hi ALL, The FAQ is located at: faq68-4037 For those of you who haven't seen the FAQ, check it out! For those of you who have seen the FAQ, I updated it to include Geoff's (xlbo) EXCELLENT idea from Thread68-652238 . Please don't forget to rate the FAQ after reading it! ;-) Peace! [peace]...

WTG Ken!!! [rockband] [Cheers] You deserve it! [thumbsup2] Peace! [peace] Mike Never say Never!!! Nothing is impossible!!!

WTG Ken!!! [rockband] [Cheers] Peace! [peace] Mike Never say Never!!! Nothing is impossible!!!

And another FAQ: FAQ707-4116 This is a rather long FAQ that contains ways of checking for, copying, moving and deleting files and Folders using VBA. Don't forget to vote for the FAQ at the bottom of the page. I like to know if my FAQ's are useful or not. If you have any suggestions, then...

Check out my newest FAQ: faq707-4114 It shows you how you can open files using the GetOpenFilename dialog. I have seen numerous posts in here on how to do this, so I'm sure it will help someone. At least it's a good reference for the next time someone asks. ;-) Don't forget to vote for the...

See this thread: thread707-642389 Which I have created a FAQ for! faq707-4090 I hope this helps! Peace! [peace] Mike Never say Never!!! Nothing is impossible!!!

Something to do during downtime [morning] Follow these steps carefully! [thumbsup2] 1. Open Excel. 2. In a blank worksheet, select "Save as" and choose "Save as web page". 3. Click on Publish and Add interactivity. 4. Save as any name you like. 5. Load the page...

I have noticed that a lot of the procedures in this forum contain references to Worksheets like Sheets("Sheet1").Activate. This should never have to be done! You can change the Worksheet Reference Name or "(Name)" with parenthases in the VBE. The Worksheet Reference Name...

I would like to inform you about an Excel function not many know about that helps you to return smaller amounts of data from a database: The SQL.REQUEST() function gives you SQL Query functionality directly in Excel! The use of this Function is a little in depth, so I am not going to try to...

I would like to inform you about an Excel function not many know about that helps you to return smaller amounts of data from a database: The SQL.REQUEST() function gives you SQL Query functionality directly in Excel! The use of this Function is a little in depth, so I am not going to try to...

I would like to inform you about an Excel function not many know about that helps you to return smaller amounts of data from a database: The SQL.REQUEST() function gives you SQL Query functionality directly in Excel! The use of this Function is a little in depth, so I am not going to try to...

See my latest FAQ! faq707-4085 Enjoy!! ;-) I hope this helps!! Peace! [peace] Mike Never say Never!!! Nothing is impossible!!!

This file shows you how you can have the most fun with a UserForm in VBA (using Class Modules!): http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=FormFun.zip From Stephen Bullen (Excel Guru) http://www.bmsltd.co.uk/excel/ Check it out! Peace! [peace] Mike Never say Never!!! Nothing is...

Someone PLEASE prove me wrong! When I run the following procedure and set wb to a Workbook that contains macros, it opens just the Workbook just fine and I don't have to Enable Macros. The Macros run fine and do every thing they are supposed to do. My security settings are set to Medium (i.e...

Congratulations Skip, [medal] Boy . . . . That was a fast week! [bugeyed] I guess you deserved it more! [2thumbsup] [rockband] Peace! [peace] Mike Never say Never!!! Nothing is impossible!!!

For those of you who wish that Excel XP still had an AutoSave function: [wavey] I posted a FAQ that should start you out on creating your own AutoSave Add-In for Excel XP. FAQ68-4060 I hope this FAQ helps you out. Peace! [peace] Mike Never say Never!!! Nothing is impossible!!!

For those of you who wish that Excel XP still had an AutoSave function: [wavey] I posted a FAQ that should start you out on creating your own AutoSave Add-In for Excel XP. faq68-4060 I hope this FAQ helps you out. Peace! [peace] Mike Never say Never!!! Nothing is impossible!!!

I have noticed that these two (very helpful) functions are often overlooked when dealing with dates: The NETWORKDAYS() function returns the number of days in a period, it removes the weekends and even holidays! This is the syntax: =NETWORKDAYS(Start_Date, End_Date, [Holidays_Range]) The...

Another way to calculate dates in Excel, is a function that has absolutely no documentation in the Excel Help File (except Excel 2000). This function is the DATEDIF() function. It originates from Lotus 1-2-3. The DATEDIF() function uses the following syntax...