Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Problem
I have a Marco that runs a series of VLookups from a button in the excel
sheet. The Macro is stored in the personal worksheet which is always hidden. The workbook is used as a template that is stored on the server where it is access by multiple users. My problem is that some how the macro is €ślosing€ť the path to the €śtable array€ť sheet that is stored in a separate worksheet on the server. When you hit the button for the Vlookup; a window for u to navigate to the file that contains the sheet for the €śtable array€ť values appears. This is very frustrating and perplexing to me. If anyone has any ides as to how I can solve this issue I would be very grateful. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Problem
Hi DP7:
It would be useful to see your code so that we could see if there is something we could point out. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "DP7" wrote: I have a Marco that runs a series of VLookups from a button in the excel sheet. The Macro is stored in the personal worksheet which is always hidden. The workbook is used as a template that is stored on the server where it is access by multiple users. My problem is that some how the macro is €ślosing€ť the path to the €śtable array€ť sheet that is stored in a separate worksheet on the server. When you hit the button for the Vlookup; a window for u to navigate to the file that contains the sheet for the €śtable array€ť values appears. This is very frustrating and perplexing to me. If anyone has any ides as to how I can solve this issue I would be very grateful. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Problem
See my macro code below
Sub Fdrivetrim2() ' ' Fdrivetrim2 Macro ' Macro recorded 03/4/2008 by Dwayne ' ' Range("J15").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-7],[TRIMPRICES.xls]FUSING!R1C1:R8C3,3,FALSE)" Range("J17").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-8],[TRIMPRICES.xls]ZIPPERS!R1C1:R37C2,2,FALSE)" Range("J19").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-8],[TRIMPRICES.xls]ELASTIC!R1C1:R11C4,4,FALSE)" ActiveWindow.SmallScroll Down:=42 Range("M55").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-5],[TRIMPRICES.xls]POLYBAGS!R1C1:R16C2,2,FALSE)" Range("M56").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-5],[TRIMPRICES.xls]HANGERS!R1C1:R35C5,5,FALSE)" Range("M56").Select Range("J20").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-7],[TRIMPRICES.xls]BUTTONS!R1C5:R53C6,2,FALSE)" End Sub "Martin Fishlock" wrote: Hi DP7: It would be useful to see your code so that we could see if there is something we could point out. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "DP7" wrote: I have a Marco that runs a series of VLookups from a button in the excel sheet. The Macro is stored in the personal worksheet which is always hidden. The workbook is used as a template that is stored on the server where it is access by multiple users. My problem is that some how the macro is €ślosing€ť the path to the €śtable array€ť sheet that is stored in a separate worksheet on the server. When you hit the button for the Vlookup; a window for u to navigate to the file that contains the sheet for the €śtable array€ť values appears. This is very frustrating and perplexing to me. If anyone has any ides as to how I can solve this issue I would be very grateful. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Problem
Hi DP7:
Try puting the full path to the workbook in the vlookup statement as in: VLOOKUP("b",'C:\Documents and Settings\Dad\Desktop\[Book2.xlsx]Sheet1'!$B$3:$C$5,2,FALSE) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "DP7" wrote: See my macro code below Sub Fdrivetrim2() ' ' Fdrivetrim2 Macro ' Macro recorded 03/4/2008 by Dwayne ' ' Range("J15").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-7],[TRIMPRICES.xls]FUSING!R1C1:R8C3,3,FALSE)" Range("J17").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-8],[TRIMPRICES.xls]ZIPPERS!R1C1:R37C2,2,FALSE)" Range("J19").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-8],[TRIMPRICES.xls]ELASTIC!R1C1:R11C4,4,FALSE)" ActiveWindow.SmallScroll Down:=42 Range("M55").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-5],[TRIMPRICES.xls]POLYBAGS!R1C1:R16C2,2,FALSE)" Range("M56").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-5],[TRIMPRICES.xls]HANGERS!R1C1:R35C5,5,FALSE)" Range("M56").Select Range("J20").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-7],[TRIMPRICES.xls]BUTTONS!R1C5:R53C6,2,FALSE)" End Sub "Martin Fishlock" wrote: Hi DP7: It would be useful to see your code so that we could see if there is something we could point out. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "DP7" wrote: I have a Marco that runs a series of VLookups from a button in the excel sheet. The Macro is stored in the personal worksheet which is always hidden. The workbook is used as a template that is stored on the server where it is access by multiple users. My problem is that some how the macro is €ślosing€ť the path to the €śtable array€ť sheet that is stored in a separate worksheet on the server. When you hit the button for the Vlookup; a window for u to navigate to the file that contains the sheet for the €śtable array€ť values appears. This is very frustrating and perplexing to me. If anyone has any ides as to how I can solve this issue I would be very grateful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro problem | Excel Discussion (Misc queries) | |||
Macro problem | Excel Discussion (Misc queries) | |||
Problem in macro | Excel Discussion (Misc queries) | |||
macro problem | Excel Worksheet Functions | |||
Macro problem | Excel Discussion (Misc queries) |