Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. john24

    dts and excel

    office 2003 is installed
  2. john24

    dts and excel

    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?
  3. john24

    vb6 and excel

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

    vb6 and excel

    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
  5. john24

    vb6 and excel

    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...
  6. john24

    vb6 and excel

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

    vb6 and excel

    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?
  8. john24

    Application Error

    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
  9. john24

    Any ideas when I open a sequential

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

    Inserting text into worksheets

    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...
  11. john24

    Looping Question

    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
  12. john24

    VB6 export to & import from Excel (text vs. numeric format cells)

    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
  13. john24

    VB, excel and XP

    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...
  14. john24

    passing arrays by reference to dll

    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...
  15. john24

    Process not quitting

    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...
  16. john24

    fortran dll to be called from Visual basic

    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...

Part and Inventory Search

Back
Top