@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hidden Columns and Save Location
your example should save the file as:
"\\server8\cpd\CompReserve\kents
folder\TEST FOLDER.xls"
if you're wanting to save it with the current name in the folder called:
"\\server8\cpd\CompReserve\kents
folder\TE
,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: "Boucher, Kent C"
To: "excel-macros@googlegroups.com"
Sent: Wed, September 28, 2011 2:31:59 PM
Subject: RE: $$Excel-Macros$$ Hidden Columns and Save Location
Hi Ashish,
Thank you for getti
: September 28, 2011 12:22 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hidden Columns and Save Location
add
For Each wk In wkb.Sheets
wk.select
Cells.EntireRow.Hidden = False
Cells.EntireColumn.Hidden = False
and
replace wkb.Path & "/"
in wkb.SaveAs w
add
For Each wk In wkb.Sheets
wk.select
Cells.EntireRow.Hidden = False
Cells.EntireColumn.Hidden = False
and
replace wkb.Path & "/"
in wkb.SaveAs wkb.Path & "/" & Left(wkb.Name, InStrRev(wkb.Name, "")) &
".xls"
with ur path "c:\" etc
On Wed, Sep 28, 2011 at 9:11 PM, HarryP Knuckles w
