wkbk

Need macro, not formula. Workbook A. Sheet 1 Column B starting in Row 7 has a variable number of names with spaces between the rows of names. Each name in the cells has been truncated to 11 spaces by a DB3 program. Workbook B Sheet 4 has those same names in Column A sheet 4 starting in Row 4...

Our IT department just migrated all of our data to a SPS and then I have a mapped local drive that references that location. Every Client Wkbk I open has a user authentication dialogue that's called on opening the workbook. Every time I go to open a Wkbk, I get a run time error. At first I...

Hi all, I want to vlookup from an closed workbook. i have the below code which pulls up the particular column data from an closed book. When i apply the formula(=VLOOKUP(B18,'C:\My Documents\Temp\[Demo.xls]Sheet1'!$A$1:$B$10,2,FALSE). the file size gets heavy. Is there an better way around...

All, I am in need of some help. I have two workbooks - A acts as a database of all our quotes, whilst B is a local file with just the quote info for that particular job. I am trying to write some VBA to loop through all the quotes in B (unique id in col F) and update the main database. I am...

Good afternoon all! What I am trying to achieve is this: - User opens Workbook A - User clicks a button to open Workbook B so they can edit it (B is password protected, it can only be opened in write mode from book A; this is supposed to 'force' users to only use book A (and its userforms) to...