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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Ramy27

  1. Ramy27

    Macro with goalseek function

    I recorded a macro in Excel while doing a goal seek. When I run the macro it's not repeating the goal seek. Could anyone tell me why? Here's the part of the macro that was recorded. Range("B9").GoalSeek Goal:=0, ChangingCell:=Range("B4")
  2. Ramy27

    Using VB to lock a JET database table

    I'm creating a VB application. The application writes to and reads from a JET database (this database itself is 'created' by this VB-based application) I would like to be able to lock some tables in this DB using VB code. Is it possible? How do i go about this? (When i say lock- I mean read only)
  3. Ramy27

    Storing pdf files

    I'm looking to store some pdf files in JET databases using a VB6 based program that I'm trying to create. I have no clue...how to begin...is there a webpage you would recommond?
  4. Ramy27

    VB: Excel to database dealing with empty cells

    ...in the SQL string itself?
  5. Ramy27

    VB: Excel to database dealing with empty cells

    1) sorry INSER was just a mistake when I copied. 2) where do I use vbNullString ?
  6. Ramy27

    VB: Excel to database dealing with empty cells

    I’m copying some tables from Excel to DB using VB code. There is a particular column in the Excel sheet that is supposed to be numbers. But on some occasions there isn’t a number (empty field). But this doesn’t mean that it’s zero. My SQL statement created in VB looks something like this: INSER...
  7. Ramy27

    VB project ICON problem

    I’m trying to create a new VB application. I’m doing so, by modifying an existing project that one of our colleagues created. There is an icon in the project folder called SINEWAVE.ICO I doubled clicked that and it opened in Microsoft Developer Environment. I modified the appearance of the...
  8. Ramy27

    Where's the mistake?

    Thanks very much, I'm going to try that and will let you know. Much appreciated.
  9. Ramy27

    Where's the mistake?

    Okay, let me re-state the problem for those who just joined :) THE ERROR IS IN THE WAY WE DEFINE: Set RangeA = Worksheets(ExcelSheet).Range(ExcelRange) ExcelSheet="Sheet1" ExcelRaneg="B12:D14"
  10. Ramy27

    Where's the mistake?

    I'm using Excel 2002 SP2- perhaps that's where the problem is.
  11. Ramy27

    Where's the mistake?

    THE ERROR IS IN THE WAY WE DEFINE: Set RangeA = Worksheets(ExcelSheet).Range(ExcelRange)
  12. Ramy27

    Where's the mistake?

    Should that code you posted go in the Function or Coomandbutton_click?
  13. Ramy27

    Where's the mistake?

    the error is still in Set RangeA = Worksheets(ExcelSheet).Range(ExcelRange) Help!!!!!!
  14. Ramy27

    Where's the mistake?

    no, it does not work...i'm totally messed up
  15. Ramy27

    Where's the mistake?

    no, that's not the problem ActiveSheet.Range("C3")= "Sheet1" ActiveSheet.Range("C4") ="C2:D12"
See more

Part and Inventory Search

Back
Top