Open Excel Spreadsheet VBA code .......

[Mikey C]

Hi folks

Can anybody tell me where I'm going wrong with this? I have used the
following code (as part of a larger expression) to open an excel
document:

CreateObject ("Excel.Application")
Set objectVarName = GetObject("P:\Competitor Analysis\Competitor
Analysis Database\Financial Data Import.xls")
GetObject ("P:\Competitor Analysis\Competitor Analysis
Database\Financial Data Import.xls")
Visible = True

I have already made the code to transfer the details I need to a
spreadsheet, I just can't figure the code to then open that sheet
afterwards!

Thanks

Mike

 

[Tom Dierickx]

Mike,

If I understand you correctly, you want something like this:

Set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks.Open ("P:\PATH_TO_YOUR_FILE.xls")
objExcel.Visible = True
Set objExcel = Nothing

Hope it helps,
Tom

 

[Mikey C]

Works like a charm - thanks Tom, much appreciated!