Search results for query: *

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

Hi, i've found a way to change the footer values, and I run this at the 'on_open' event of the workbook. The only problem is that this is a bit slow... The code is here: With Unit1.PageSetup .LeftFooter = "&12" + ThisWorkbook.Path + "\" + ThisWorkbook.name End With My...

I'm using recordsets and the openrecordset() function.. Are these two things similar?

Hi Skip, Sub testDAODatabaseFrank() Dim ws As DAO.Workspace Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim rs As DAO.Recordset Dim curCol As Integer, curRow As Integer curCol = 1 curRow = 2 'create workspace, name is anything, admin is to log in...

Hi, i'm making a script in vba to automate the data gathering of quite a bit of information and putting it into respective excel sheets. Vba in Excel, using Office 97. The script connects to Access 97 to run some SQL and then return values. It seems (from what I've seen and other than the...

Hi, i currently am working on some excel code that connects to a database and returns some values. Problem is it is a huge database (Access) and it takes some time. If I run the queries from within Access I can still do some stuff in the background (highly reduced in speed, but still somewhat...