Hi,
I have approximately 80 HMTL files that I need to convert to excel files. I can come up with code to open the HTML and save it again but ending in .xls instead of .html (see below) but I would have to input this code for every HTML file. Is there a way to do this for all 80 files in one go...
Hi,
I want to open a html file that I have created in excel (i.e. so it is now in Excel format and not html). I can use 'open with' and select excel as the application to open it, and this works. However, I want to be able to do this in VBA so it automatically opens the html file in excel (I...
Hi,
I've created several summary tables in SAS Enterprise Guide 4.2 and want to export all of the tables to Excel 2003. Is there a way to do this? I can export to HTML and open it with Excel, but I was hoping to simply run the process flow and automatically export into Excel. The only export...
Hi,
I want to divide the sum of column A by the sum of column B. Is this possible using the various standard tasks within SAS or does it require coding? Any ideas how to do this?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.