VBA Connecting to Closed Workbook

[craig80]

Hi All,

I have a Data Workbook holding all data for my reports, I would like Query my this closed "Data Cube" (which is table format). But rather than build a connection through the DATA tab, I would like to use VBA?

(reasons for this is i am querying a data set which is on a intranet document storage, and cannot network this as a drive)

i.e. //internal/176/222/225/Reports/Data_Cube.xlbs

I need to get to a stage somewhere like this. ( can do the open, close, paste additional formula, its the middle bit)

VB

• Open connection (As above)
• refresh data connection
• filter specific criteria out
• refresh all pivot and forumlas on destination
• close connection
• save AS destination file twice
• end

Thanks again to all those who have helped over the last year.

Craig