warning messge

[braven]

is it possible before run macro can i give any warning massge like make sure is it in c:\test.xls
if so, plese how to do it,
Set wbExcel = appExcel.Workbooks.Open("c:\test.xls

 

[braven]

could you help,
open excel book save as differnet name and run the macro
this line has cannot access error
wbExcel.SaveAs file_name
the macro : file_name = "c:\test.xls"
Set appexcel = CreateObject("excel.application")
' Set wbExcel = appExcel.Workbooks.Open ("file_name")
' 'appExcel.Visible = True

Set wbExcel = appExcel.Workbooks.Add

wbExcel.SaveAs file_name

 

[tchad]

Like a message box warning?

Use the code below.

MsgBox ("Make sure macro is in c:\test.xls")