Search results

For the last 4 or 5 days I have been tracking emails from a support group. I would select the emails from the email list, right click the selection and copy the emails in the main list. Then I would select an Excel cell an Paste the values that would look something like this Yesterday, when...

I am using VLOOKUP to find a value in a named range(Range-A). I am using IFNA to trap values the Return "N/A" when no match is found. I then create a VLOOKUP to look in a different table (Range-B) for a match. =IF(ISNA(VLOOKUP(E2,Range-A,5,FALSE)), "", VLOOKUP(E2,Range-A,5,FALSE)) and...

Is it possible to return the data type for a range? In this case the range is a column. If possible, what would be the code to do so? I can see this would be problematic if there was more than one data type in the range. Thanks,

I have run across this a couple of times recently. I am copying a value from a single cell in a table generated in SQL or in another worksheet. When I paste the value to the destination cell, the value separates to multiple cells. Like I had selected "Text to Column" and used the "space...

I have inherited several Access DBs that were on the personal hard drive of a developer who has left this company. We need to move the data bases to a secure server environment. There are several Macros associated with each of these DBs. I need to review the Macros to resolve any mapping issues...

I am trying to automate some pivot tables. there are 5 Pivot Tables on 5 different worksheets that use a table on worksheet "Data". The column count will always be 7 (A-G) but the rows will change. How would I define the range of the data source? This is what I was trying [Code Starts] Dim...

I need to verify all the values in several columns are Long Integers. It would seem like this would be a fairly easy thing to do, but I haven't found anything after repeted attempts. I have tried using "Text to columns". but the example below works part of the time and doesn't other times...

I have inherited an Access 2007 database with two tables called “Incidents” and “CorrectiveActions”. tblIncidents IncidentID (Auto Numbered Primary Key) IncidentNumber Etc. tblCorrectiveActions IncidentNumber(Primary Key) CorrectiveAction(PrimaryKey) Etc. There...

I really like using the "Application.GetOpenFilename " method to allow users to navigate to files, but there are times when I would like to help out the users and have the browser start in a specific location. Is there a way, using Application.GetOpenFilename or something else, to open a...

I have a worksheet and column "C" is "Sales". Because people may add/delete additional columns or otherwise move this column around in the worksheet I want to define the "Sales" column as a range. Hopefully I won't have to adjust the code if the column position changes. Once I do this how would...

I can import data from a table on one file into another using ADO Using the following lines of code without any issues xRow = Cells(Rows.Count, 1).End(xlUp).Row + 1 tArray = ReadDataFromWorkbook("H:\InvoiceFolder\Invoice 123.xls", "InvoiceData") For r = LBound(tArray, 1) To...

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

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.