var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Opening an excel file from access
I am trying to open an excel file from Access, using vba using:
On Error GoTo Err_cmdDatLevelRpt_Click
Dim oApp As Object
Set oApp = CreateObject("Excel.Application")
oApp.Visible = True
oApp.Workbooks.Open FileName:="\FILE PATH etc...."
The excel file is linked to a data source and is set to refresh on open. The problem I have is that when I open the excel file via access, excel does not refresh the data. However when I open the excel file via excel it does refresh!!. Im a bit stumped..any thoughts?
have you tried the "application.followhyperlink" method?
Access XP & WinXP Pro
ive just ried it with :
Application.FollowHyperlink "\\Plympdc\data\Positive Response\Data\Responses\PRDaily.txt", True
The same happened, it did not refresh the data
opps correction.....It did work! thanks very much..