macro needed for saving

S

Steve

macro needed for saving multiple sheets into DBF format
I mean for specific areas, libe B5:z66 from sheet2, appendable after b5:f66
I have simulated, but I know how to save xls with one sheet, it works; but
is useless for me. also I have colected the whole sheets in one, specific
wich I want to convert into DBF. Any solution provided hope that will be
usefull; I use office 2003.
 
J

Joel

Becuase you want to save only specific areas of the workbook and not the
whole workbook, you need to create a new workbook, then copy the data
specific areas of the workbook to the new workbook, and finally do a SAVEAS
to the new workbook in DBF format.
 
S

Steve

In this point is more usefull a macro to save one specific sheet to another
workbook, with a single sheet, and that to dbf. any sugestion?
"
ActiveWorkbook.Save
ActiveWorkbook.SaveCopyAs ("C:\...... " can't use with more than
1sheet

I mean for a single macro run to do all the work
 
D

Dave Peterson

dim wks as worksheet
set wks = worksheets("somesheetnamehere")
wks.copy 'copies to a new workbook--single sheet
'save the newly created single sheet workbook.
with activeworkbook
.saveas filename:="C:\..."
.close savechanges:=false
end with
 
S

Steve

I was wandering when DAVE pick on this post..
thank you Dave, I got to try you solution, at the first look it was under my
nose...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top