Excel / VB???:)) Question 2

[q4s72534]

below is the code i'm using to pull data from an open workbook in excel. is there a way to pull data from a closed workbook? THANKS SOOOO much.


Sub OpenWorkbook()
Dim wb As String
wb = "Workbook_You_Want_Tpen_With_Path_&_File_Extention"
Application.Workbooks.Open (wb)
End Sub

 

[Bowers74]

You could try this:

msgbox ExecuteExcel4macro("'Workbook_You_Want_To_Open_Path[File_Name_&_Extention]Sheet_Name'!R1C1")[code][/color][/b]

This will show you a Message Box that returns the value in cell A1 of the Workbook and the Sheet you specify!

Or you could try the ADO or DAO paths, or run a External Data Query.

I hope this helps!



Peace! [peace]

Mike

[COLOR=red][b]Never say Never!!!
Nothing is impossible!!![/b][/color]