but i cant share a document to you. if using dos is this possible.
Thanks
Manoj
On 12/6/12, Paul Schreiner wrote:
> There IS a way to get to the data in an excel file without opening it,
> but I've not worked with that much.
> Mainly because it's very convenient to simply have Excel disable disp
There IS a way to get to the data in an excel file without opening it,
but I've not worked with that much.
Mainly because it's very convenient to simply have Excel disable display
updating.
In which case a macro can open hundreds of excel files and file/save them as
text files
in a relatively sho