Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question on formula
I have an Access DB with VBA coding that transfers the data to Excel. With
it is a formula: xlObj.Application.ActiveCell.FormulaR1C1 = "='" & pubXLFolder & "[file.xls]sheet1'!R4C3" pubXLFolder = "\\sales\reports\ The above code is referencing the value from another spreadsheet on the network. But I noticed when copying the file to my local drive, instead of seeing the cell reference as: \\sales\reports\[file.xls]sheet1'$C$4 it shows as c:\db\[file.xls]sheet1'$C$4 This will cause a problem, since the excel file will eventually be posted on the company intranet website. So, when users open the file and asks for update, the network reference should kick in. Do i need to incorporate a refresh link on my code? Pls help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula question | Excel Worksheet Functions | |||
Repeating Formula Question | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |