Search results

I have a named range in workbook "Workbook-A.xls" called "TableA" I would like to add the contents of "TableA" to the end of "TableB" on "Workbook-B.xls". These tables could be pretty big ( 25 col x 1000 rows). What is the fastest way to do this while ensuring data integrity? If possible could...

I agree a database would be a better fit. The thinking behind the ADO is that if the 12 users complie their data into one big table, then have the program check to see if the destination file is available before executing the ADO / SQL statement colllisions would be unlikely. also that the ADO...

Thanks for the prompt reply. While the scenario I gave is scaled down, I am really trying to move 20 col x 200 rows at a time. To make things worse, there are 12-15 people all trying to write to the "destinationtable" pretty much all at the same time. I also have a manager that is convinced...

I am usually pretty good at figuring things out by googling the problem, but I ahve tried for days to understand moving data back and forth between Excel files using ADO. Lets sat I have a source file G:\Source _folder\sourcefile.xls whith a range of 4 colums x 20 rows named"SourceTable" I...

I have a sub that reads a cell value and stores it as a variable with a data type "String" everything runs well until I hit a range with "#N/A" as the cell value. This causes a type mismatch error If I modify the cel value to "Number N/A" everything works just fine. Is there some way to Trap...

As part of an error check, if a field on an excel spreadsheet is black, I would like to open a form and select one of two option (Radio) buttons on the form. This would place the user in the correct place to add the missing information. I have been unable to programically "Click" the button. in...

By "workbook variables" I assume you mean declaring them as "Dim wbA as Workbook" I was having trouble setting the variable as the active workbook. The examples I found declared them using something like "Set wbA = WorkBook(name of fileas a string) which also returned an error Using Office...

I should have mentioned that I am using Oxxice 2003 with XP Pro

I want to start in Workbook "BookA" Save the name of " BookA" as variable "wbA" Activate Workbook "BookB" and return to Workbook "BookA" I am using the following code in workbook '( from Workbook "BookA" ) Sub AtoBtoA () Dim wbA as String ' Set variable to Active workbook name minus the file...

I would like to have many different versions of the same work book use a single central source of code. This would really simplify keeping everybody using the most current release and updates. Could any of you SuperUsers out there get me pointed in the right direction?

I have a form where the user selects 1 of 4 options. ( A through D) Depending on the Users selection, a value is stored that is a literal match to the name of one of four forms ( frmA, frmB, etc) Right now the variable is declared as a string (FormName) What I want to do is "Show" the...

Does anyone out there work with Excel Spreadsheets in conjunction with Winshuttle? (an application that interfaces with SAP) We are trying to launch some Macros using the On Change Event after Winshuttle finishes processing and returns an event log back to the Excel worksheet. I know the On...

I have an animated gif file my manager wants included on a form. I placed it on the form, but it doesn’t animate. Could somebody tell me if there is a control I need to activate or something special I need to do to get the animation to run.

I have a userform that I want to display like a splash screen while a long subroutine is running. In a test environment it displays just fine. When I execute the subroutine the form Shows and Hides on queue, but the form is entirely blank. Thanks for your help

This is actually an Excel question. I appologize for the confusion

Running Excel 2003 on XP Pro I want automate a timesheet on Excel to copy data to a "master time list" at the end of the week. This will be activated when the time keeper selects a control to "copy weekly time". Once the data is copied, the master time list will be closed for the next user I am...

Error persists Unfortunately, I get the same error. Any other suggestions I am using Excel 2003 /Win XP

I have a report generated in Excel. I would like to Save the report as "Employee Name-Date", using the following code: ActiveWorkbook.SaveAs Filename:= _ "\\[Path]\" & CName & "-" & WEDate & ".xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:=""...

Data Type Inquiry-revisited Once I have determined what data type a cell value is, How can I re-define the data type of the cell value?

Thank you for the help