on a computer running windows xp, I'm trying to do the following:
have Excel open workbook1 and run a macro in the personal workbook. workbook1 will be a different file each time (the macro only formats it). I can use a batch file to rename the workbook to have a generic name, and to open it in excel, but I can't get it to run the macro. I tried using sendkeys in access and again could open the file but not run the macro. I really don't know VB, but I had found a code for VB which would open the excel file and run a macro, but I could only get it to work if the macro was inside the workbook, it would say it couldn't find it if i had it in the personal workbook). I'm open to trying any combination now in order to automate a process of formatting the new workbooks each week (only one worksheet in the workbook).
p.s. I hope I have the right forum, as I wasn't sure whether applications, or dos, or programming would be the right forum and knew better than to post it in all of the forums.
Thanks.