Search results for query: *

office 2003 is installed

when i try to select the excel icon as my source i get the message "a dynamic link library initialization failed", also get it for access. how can i resolve this?

i have not, i've been assigned to yet another swamp full of aligators but thanks for the help, i will try asap

what i don't want to do is to activate each individual sheet - only the first sheet gets input, all the others are linked to the first and the last sheet contains the final calcs. with just the first sheet active the other sheets never get updated. i'll try the sendkeys and see that helps thanks

here's the situation, there's one primary sheet open to the user to do as they will (with restrictions) - there are 5 more sheets linked to the primary sheet. when the user is finished entering data i then do a .calculate. this updates the primary sheet but the other sheets that are linked to...

this works for the active sheet only, the other sheets never get updated.

is there a way to get excel to update all worksheets in a workbook from within vb - i can get the active worksheet to update but all of the other linked worksheets remain static. is there a solution to this?

i have had this type of error occur (many times) with dll's (that i've written) that either got bad parameters or generated an exception due to some incorrect assumption being made about the data being passed into the dll. so i would agree with cclint, call the supplier of the ocx

mid returns a string, why not just set Text2.Text = mid(sData12,3)?

this searches for a specific workbook but you can use the .Name property to get the names of all of the worksheets in your workbook Public Function FindSheet(ByRef xlWbk As Excel.Workbook, _ ByVal SheetName As String) As Boolean Dim i As Integer Dim...

you could try something like: Dim TestText As String Dim MyTextBoxes As TextBox For Each MyTextBoxes In frmMyForm TestText = MyTextBoxes.Text MsgBox "text: " & TestText, vbOKOnly Next

i've run into this before, my soln was to format the column to the data type i knew it had to be prior to accessing any of the data in the worksheet

when i did the pdw under winnt and win2k and distributed my product all went well. having upgraded to xp i now have problems with excel when i try to open an existing file e.g. Set xlCompareWorkbook = xlApp.Workbooks.Open(FileToReview). i can create a new workbook but when i try to do a saveas i...

i've not done this with visual fortran, i use lahey, and i've had no problem calling my dll and just passing the array name, no()'s, and getting 1, 2, and 3-d data back. you need to make sure that you've typed your data properly in that the fortran dll will simply fill the array ignoring what vb...

here's what i;ve found works for my users declare xlActive as a module level boolean, then once excel has been opened do: xlActive = True xlApp.Visible = True xlApp.EnableEvents = True Do While xlActive DoEvents Loop xlApp.EnableEvents = False in the BeforeClose...

I've done this with both DEC and Lahey compilers, it's not well written up in the DEC manual but Lahey has all you need. you basically need to replace your program statement with a subroutine statement and add an export line (or 2 for DEC). then just declare the dll in vb as you would any other...