Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pvong
-
Center web pages from Publisher 2010
I'm new to Publisher so be easy on the new guy. I created my first pub document and I like to make it a web page. I can save as to htm and everything looks good, but it's always on aligned to the left side of the web page. Is there anything you can do in Publisher that will let you save it as...- pvong
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Simple Excel - Delete rows above 9
WE ARE SOOO CLOSE. Any chance you know how I can make it save the CSV without asking me all those questions? I have to hit all those YES...etc. I'm trying to automate this process. Thanks in advance. P.S. This is my first time at this forum and it's great. You people are quick and good. -
Simple Excel - Delete rows above 9
Here my complete code: Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("D:\ServerFiles\CroftDB\DbImport\dbaum.xls") objExcel.ActiveSheet.Rows("1:7").Delete objExcel.ActiveSheet.Columns("B").Delete objExcel.ActiveWorkbook.Close True Const xlCSV = 6... -
Simple Excel - Delete rows above 9
OK, it's not perfect. Can someone show me how to save the file as a CSV after it takes out the rows? I would like to use the same filename. I would also like this done without human interaction. Thanks! -
-
Simple Excel - Delete rows above 9
PH - AWSOME THANKS!!! When the script runs, I get a pop-up asking if I want to save the changes. What do I add if I just want it to save over itself? -
Simple Excel - Delete rows above 9
I'm very very new at this. I'm trying to create a vbscript that will open an Excel 2003 file and delete all rows above 9. This is the code I came up with. Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("D:\ServerFiles\CroftDB\DbImport\dbaum.xls")...
