Hi, Need some help on how to manipulate an excel report that has sales monthly sum totals and would like to export each cell to a new worksheet. The original report is to busy with many part numbers that get converted during the month and sales is only interested with the Total cumulative sales amou...

Marcus, I appreciate your help, seems more study is required of me when it comes to this, my first time with this vbscript, I have pasted, highlighted and then pressed code, hope your can see the entire script I have done. Thanks again for the help. VBSTART Dim xlApp Dim xlBook Sub OpenBook(workbook...

Yes, this is the entire script: VBSTART Dim xlApp Dim xlBook Sub OpenBook(workbook) Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open(workbook) xlApp.visible = True End Sub Sub SortRange(Sheet,Range,Key) xlBook.Worksheets(Sheet).Range(Range).Sort xlBook.Worksheets(Sheet...

Hello, No this is running in my Macro scheduler where the Excel file is opened and then the sort function is working, but at line 21 in the Macro Scheduler is where it goes into error.

Hello, I have examined the data and is sorting properly, but also getting an error message of the following: Line 21 - Missing Parameters in Function Call (Min of 2 Expected) // COMPILE_OPTS|J:\MO\Excel Data\MO Macro.exe|C:\MY HOME\Icons\CLON.ico|CONSOLE=0|INCLUDES=1| //Set IGNORESPACES to 1 to forc...

Hi, Marcus & hagchr, I have now been able to start this project with commands to open excel and sort my column G, use the following: //Set IGNORESPACES to 1 to force script interpreter to ignore spaces. //If using IGNORESPACES quote strings in {" ... "} //Let>IGNORESPACES=1 VBSTART Dim xlApp Dim xlB...

Hi Marcus, Thanks for this code, I did try the keystrokes with the excel file and can do this, but as you mention in the options, I need to refresh this data each time a new report is generated. This report is exported into a new data worksheet and the will need an external macro to run this each ti...

Hi,

Thanks for the reply, I will give this a try today and see how we go.
Will let you know how I do, thanks again.

Regards

Bill

Hi hagchr, Thanks for reply, using Excel 2007 and have now tried that keystroke and it works. My problem I am still trying to figure out is how to select the column without using the mouse and only keystroke. Do you know how that is done with keystrokes only? For example need to select Column F and ...

Looking for help for working in an excel spreadsheet. Need to learn how to automate this excel file to modify the layout each time the file is opened, so the file is sorted properly. I am new to all this and just joined recently and now have Macro Sched Pro 12. If I can get a start on what commands ...