How to Refresh Data Import?

[hce]

Dear All

I have a file which contains data exported from external sources. Henc
whenever I open the file, a dialog box will appear and prompt whether
want automatic refresh or not.. Once I clicked yes, all data in th
workbook would be refreshed and updated with the latest data...

As I always use this file, it's a chore to go find the file and open i
hence i recorded a macro to open this... but if I use the macro to ope
the file, the refresh dialog box will not appear... hence i would hav
to unhide all the hidden worksheets to refresh all of them manually...

could anyone kindly show me how to create a macro either to refresh al
hidden worksheets all at once or how to create a macro which opens th
file but yet still display the refresh dialog..?

would really appreciate any help given...

cheer

 

[Frank Kabel]

Hi
try something like
workbooks.open(filename:="your_filename", Updatelinks:=3)

or add a line in your code like
activeworkbook.refreshall
after openening the workbook

 

[Frank Kabel]

Hi
try something like
workbooks.open(filename:="your_filename", Updatelinks:=3)

or add a line in your code like
activeworkbook.refreshall
after openening the workbook