Hello,
I have macro which creates a folder on my C drive and savesascopy a spreadsheet into that folder.
I want the spreadsheets that have been generated in my C drive, when i come to open them open in a certain screen size and position so fits the the screen correctly. How do i get code into that saved spreadsheet so opens correct size and position height and width. I have found code that resizes the Activeworkwook but that just changes the height and width of the spreadsheet im running the macro from..
How do i get that code into the other spreadsheet stored and saved on the C drive.
I have macro which creates a folder on my C drive and savesascopy a spreadsheet into that folder.
I want the spreadsheets that have been generated in my C drive, when i come to open them open in a certain screen size and position so fits the the screen correctly. How do i get code into that saved spreadsheet so opens correct size and position height and width. I have found code that resizes the Activeworkwook but that just changes the height and width of the spreadsheet im running the macro from..
How do i get that code into the other spreadsheet stored and saved on the C drive.