Search results for query: *

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")

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)

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?

...in the SQL string itself?

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

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

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

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

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"

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

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

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

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

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

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

Private Sub CommandButton1_Click() Dim DBAddress As String Dim ExcelAddress As String Dim a As String Dim ExcelRange As String Dim SheetName As String Dim NumOfRows As Double Sheets("Sheet1").Activate DBAddress = ActiveSheet.Range("C5") ExcelAddress = ActiveSheet.Range("C2") SheetName =...

i suspect the error is somewhere here .....= Range(ExcelRange)

Thanks, but it still gives the same error message

I'm doing something stupid, but i can't figure out where i'm going wrong... Dim RangeA as Excel.Range Set RangeA = Range(ExcelRange) (I’m getting an error here- “method range of object global failed”) ExcelRange here is a String in the form of “’Sheet1’!A2:D4”

Sorry guys, am new to programming in that i only rarely use VBA. Whenever i come to use VBA, i forget even the basics, cos i didn't use vba for a long time. When a user enters an excel range (Example "Sheet1!C5:G13" ) in a specified excel cell ,the program should re-name this range as "RangeA"...