Nassim am
asked on
Vba/vb6 Save as specefic sheet after edit
As-Salam Alaikom.
I'am using excell 2007 .
I have userform to open specefic workbook and entry data on it. I want after entry data in specefic sheet then Save a that sheet in (C:\file) and manuel name..
Saved file only data without format. ( formulaire)
:)
Any Idea?
ASKER
Hi again.. I already fill data in tablr only i want the save as buttom should open thz dialog file on (C:\file) where to to save it and user write the name of file...
opening the save as dialog is the easy part...
Application.GetSaveAsFilen ame
this instruction will do that...the question is, how/when do you want this to happen ?
Application.GetSaveAsFilen
this instruction will do that...the question is, how/when do you want this to happen ?
ASKER
Thx Koen.
My userform is simple
1 buttom to fill data in specifi cells
.Range("a1").value = textbox1.value
2- buttom to print the sheet
Sheets("test").PrintOut
3- buttom to save as the sheet As an archive in c:\file
( save as specefic sheet (test) with saveas dialog wich give me the permessn to choose where to save and file name)
My userform is simple
1 buttom to fill data in specifi cells
.Range("a1").value = textbox1.value
2- buttom to print the sheet
Sheets("test").PrintOut
3- buttom to save as the sheet As an archive in c:\file
( save as specefic sheet (test) with saveas dialog wich give me the permessn to choose where to save and file name)
so, when you create the button it prompts you for a macro, click new and the developer window will open on a macro Sub ButtonX_Click() where X is a number dependent of the number of buttons you have.
In the macro write
Application.GetSaveAsFilen ame
done !
In the macro write
Application.GetSaveAsFilen
done !
Sub Button1_Click()
Application.GetSaveAsFilename
End Sub
ASKER
#Koen
It open the saveas dialog but when i save the file.. It doesn't apper in the distination
Can i declare wish sheet to save as??
For excamplr.. Sheeet1 . Sheet2 . Sheet3
Can i make the button saveas only the sheet3 ??
It open the saveas dialog but when i save the file.. It doesn't apper in the distination
Can i declare wish sheet to save as??
For excamplr.. Sheeet1 . Sheet2 . Sheet3
Can i make the button saveas only the sheet3 ??
ASKER
The first command is
Sheets("test").Printout
I want after printing this sheet.. Saving it :)
automaticly after printung or in auther button.. The both is accepted
Sheets("test").Printout
I want after printing this sheet.. Saving it :)
automaticly after printung or in auther button.. The both is accepted
calling the save dialog from code is the same as when you hit the button... If you select a folder and save it there, it should show up afterwards...
then, next, you have to decide... either we call the save dialog box (giving the user the possibility to save however and where ever he wants) or we save it through code, where you decide what will be save and where it will be saved.
you can save only one sheet (or a selection of sheets), you can also move it to a new book (to get rid of the macro's) and save that one...
let me know what exactly you want...
then, next, you have to decide... either we call the save dialog box (giving the user the possibility to save however and where ever he wants) or we save it through code, where you decide what will be save and where it will be saved.
you can save only one sheet (or a selection of sheets), you can also move it to a new book (to get rid of the macro's) and save that one...
let me know what exactly you want...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think it's fair tot say that I answered the question...
ASKER
Sorry i lost connection for lo'g time brother.. Thank you very mush :) Allah bless you :)
Open in new window