Recent content by Fherrera

Hi, I've used VBA for Excel in the past, and I'm going to be working on it in Word now. Current version here is 2003. Now I did a search and found all the "unzip" threads that dealt with using the winzip command line program. In my scenario this is not as feasible, as everyone has word and...

Hi, I have a similar problem. I'm adding a new module with an UDF..user defined function thats used from within the Excel spreadsheet (like =Sum()) In any case, i'm adding the function to a different sheet, and I want to compile that sheet or else the function will not work. I cannot use...

Hey ktchan741, For limiting the number of characters in the textbox. I found this site after a quick google: http://www.vbcodesource.com/text2.html#limit Function LimitTextInput(source) As String 'put the next line in the Textbox_KeyPress event 'KeyAscii = LimitTextInput(KeyAscii)...

Hi everyone, (does this apply to this forum??) I'm starting to use VB.NET i figured it wouldn't be such a bad transition after all the VBA in Excel and a some in Access i've been doing. But i'm getting stuck with all these components available. Two questions: 1) To display a simple table...

Hi everyone, I'm starting to use VB.NET i figured it wouldn't be such a bad transition after all the VBA in Excel and a some in Access i've been doing. But i'm getting stuck with all these components available. Two questions: 1) To display a simple table in excel, one where there is a...

Hrm.. nevermind I can't believe I didn't think about sub queries but i'm going to try: SELECT * FROM FRANK WHERE DATE IN ( SELECT max(date) FROM Frank WHERE DATE < #03/09/1993#); Which gets the job done in my 10 row sample database, now to try it on the 13million row actualy database...

Hi, I have a database that has entries, Date and Tag and Value. It is from a Historian and it only recorded values at certain intervals if they where a certain distance away from the previous value, ie. deadband. In any case, I'm gathering information on a particular tag for a particular...

Here are just a few places that offer some ideas on how to use Excel in VBA, lots of good examples as well. My searches usually ended up leading me to these places and then I stuck around and read about other solutions I may have required later. http://www.exceltip.com/...

Hi Sharon, How's this work? You say by macro... I assume you mean you have to run this macro, ie. either through a command button or what not. It isn't the prettiest piece of code... I couldn't find any firstdayofmonth type functions so I had to hack something up... Give it a try. Sub...

Hi, I think i'm a little lost. I was hoping to be able to save information once the Excel sheet is open... I have a userform that display's a set of default values in the text boxes and list boxes. I'd like to be able to save the previously selected choices so that they appear instead of the...

I'm not sure how to do it for multiple worksheets? Like say if i wanted to SUM A1:A5 in Sheet1 as well as SUM A1:A5 in Sheet2... (this is a simple example the formula I will need to use is more complicated).. I'd like to do this all with just one function call? Possibly using the Sum keyword...

Sorry for the quick question. It seems Outlook 2000 is where VBA is first allowed... unless you access outlook objects from other VBA-able applications like Excel. This, I would guess means you can't get events/actions working in Outlook 97. Oh well.

Hi, i'm used VBA in both access and excel. It seems by far easier to "access" the VB environment in Excel than any other MS App. I'm assuming you can use VBA in other apps from MS Office 97. But, how do I access it in Outlook. I managed to look at the drawing of a received message code. Ie...

Thanks for the reply PHV, but &Z doesn't seem to do anything for me (just stays as &Z) the &F turns into &[File] and gives the filename. Maybe it's because i'm using Excel 97? Frank

I forgot to mention I was referring to Excel 97. I can't find the Field selection in the Insert menu? Also, I noticed I can get the filename from the buttons in the Page Setup->Custom Footer dialog box, but I'd like the whole path. (current path) THanks Frank