How to save file to particular location in VB
-
I am not a VB programmer. But have to create a macro in excel sheet which uses VB code. Actually on closing of Excel sheet i have a message box which asks to save the file. In that i am not able to make VB code to save the file to particular location. Can anybody provide me VB code so that i can save excel file to desired or predefined location. I have tried some codes from net but they are not working. Please help me out as whole module on which i am being working from one week is stuck because of this. Thanks in advance.
-
I am not a VB programmer. But have to create a macro in excel sheet which uses VB code. Actually on closing of Excel sheet i have a message box which asks to save the file. In that i am not able to make VB code to save the file to particular location. Can anybody provide me VB code so that i can save excel file to desired or predefined location. I have tried some codes from net but they are not working. Please help me out as whole module on which i am being working from one week is stuck because of this. Thanks in advance.
The workbook object has a close method that has save changes parameter and a filename paramater. Suspect you need to use that somehow.
Dave Who am I?: http://www.bebo.com/daveauld/