Excel-VB Macro Variables
I have not worked with macros but I think I could use one to really speed
things up. How do I assign a variable in VB to pick up the name of an Excel file that changes each time I open a new file? I have to open many files, and copy various cells to another spreadsheet. Any ideas? |
Excel-VB Macro Variables
Hi Eunice,
See Ron de Bruin at: http://www.rondebruin.nl/copy3.htm for sample code and techniques. --- Regards, Norman "Eunice W" wrote in message ... I have not worked with macros but I think I could use one to really speed things up. How do I assign a variable in VB to pick up the name of an Excel file that changes each time I open a new file? I have to open many files, and copy various cells to another spreadsheet. Any ideas? |
Excel-VB Macro Variables
Thank you Norman, looks like just the ticket. How ever did you locate this!
"Norman Jones" wrote: Hi Eunice, See Ron de Bruin at: http://www.rondebruin.nl/copy3.htm for sample code and techniques. --- Regards, Norman "Eunice W" wrote in message ... I have not worked with macros but I think I could use one to really speed things up. How do I assign a variable in VB to pick up the name of an Excel file that changes each time I open a new file? I have to open many files, and copy various cells to another spreadsheet. Any ideas? |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com