Question Access to Excel

C

casey

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on formula 0
Saving Excel from Access 1
export to and open excel without specifying directory 2
export excel data to access table using ADO 0
How to do it in excel? 6
Export data to Excel Column 1
I have this error. how do I fix this? 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3

Top