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?

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

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

I have a question. The answer may be in Excel, if not, I need create VB function to do this. When I type in a excel range (eg, A2:E34) in an Excel cell it should count the number of rows and columns in this range and write the results in another excel cell(s). Is it possible...

Hi, I'm trying to link an access Table to another table. The problem is that the other table is something that is stored in an Application called Geographix - whose underlying databse is sybase. I'm trying to contact the providers of Geographix, but I'm not very technical when it comes to these...

I'm thinking of moving a project from VB to VB.NET. My VB project has some help files as .chm files. what I'm trying to find out is: 1) Can I still use the .chm files as help files 2) Does .NET provide some other way of creating help files. At present I don't have the Visual Studio.NET...

I have an array of about 50 names in Excel column A. I want a program/ macro that shuffles these names in a completely random way and puts them in column B. 1) the names shouldn't be repeated. 2) one person shouldn't have favour compared to the other- i.e, the shuffling should be RANDOM. Any...

In Excel (XP), I'm trying to create a drop down menu for some cells where the menu should be filled by a list of data from a different spreadsheet. Obviously I can't use data validation, because it doesn't won't allow list from other spreadsheets. Do I need VBA for this? The second spread sheet...

In Excel (XP), I'm trying to create a drop down menu for some cells where the menu should be filled by a list of data from a different spreadsheet. Obviously I can't use data validation, because it doesn't won't allow list from other spreadsheets. any idea? ---------------------------------...

I need to programatically count he number of ROWS that has any data in column A,C or D. (NOT no. of non-empty cells, but "non-empty" rows) --------------------------------- Your help is much appreciated, R. ---------------------------------

Does anyone know whether there is a way in VBA to check, if a file with a given name exists? (File name given as a string) --------------------------------- Your help is much appreciated, R. ---------------------------------

The following function works in one computer with XP. But it doesn’t work with windows 2000. Public Function FormatDateForSQL(ByVal DateToBeFormatted As Date) As String FormatDateForSQL = "#" & Format(DateToBeFormatted, "mm-dd-yyyy Hh:Nn") & "#" End Function It says: “Compile error ...

Trying to connect to DB from Excel using VBA. The following SQL command has some errors. I'm quite sure it's got to do with " ' " etc....but I couldn't figure out. Can someone help? DeleteSQL = "DELETE * FROM TimeSheet WHERE " _ & "Name = '" & CStr(wb.Sheets("TimeSheet").Cells(3...

Hi everyone, I have a rather tricky task to accomplish using VBA. Any suggestions will be welcome. I have the folder (G;\Timesheets) that contains sub folders/ fileslike this: G:\Timesheets\George Smith\Timesheets_2005.xls G:\Timesheets\Lesley Grant\Timesheets_2005.xls G:\Timesheets\Pat...

To count occupied cells in column D j = wb.Sheets("Job codes").WorksheetFunction.CountA(D:D) doesn't work. What correction is needed here? --------------------------------- Your help is much appreciated, R. ---------------------------------

Hi everyone, hope you’re having a great day. The following code exports an Excel table with Job codes to a database table. The code works and I’ve tested it. However, I still have a problem, and I’m not sure how to proceed from here. The problem is: I don’t want the program to write an entry...