Hi
I've tried this code which some experts suggested me but it's run the new file with specific path.
but new file is contain all sheet ("button" & "data")which actually, i want to split only "data" sheet and to save as new file name for "data" sheet.
Please suggest that i'm wrong for which code.
Please Login or Register to view this content.
create copy of worksheet into new workbook then SaveAs
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi
pls show me the code?
Hi
Anyone know about this please advised.
thanks.
actually i ran your file
adjusting the path so it works on my computer and it works as you want it to?
did you expect a different file format? or to have the same vba code in the saved file as well?
Yes i expect a difference format fow raw data . it was impact fir vba code?
So strange.
please advised.
[Code]ActiveWorkbook.SaveAs Filename:="D:\test\" & "NAME_" & LValue & ".xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
End Sub
[Code]
i can use ActiveWorksheet instead?
so when you run it
the file you saveas has both data and button sheet?
if so
highlight this row of code and press f9
now run the code and when it stops, is there a seperate file with data tab only?Please Login or Register to view this content.
yes. both of data and button sheet but i need to separate file and save as new file for data sheet only.
what happens with the debug method i pointed out in post #8?
do you get the "data" sheet on a new workbook?
Hi
Yes, i would like to separate data sheet in to new file only this sheet. how i can write the code?
please advised.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks