open file

I have a lot of repetitive code and was trying to clean it up by creating a sub with a variable, I'm not sure whether I'm correct in my thinking but would love some help with the below, I've written the following code to navigate between worksheets: Sub MoveTo(Target As Worksheet)...

Excel 2002. Suddenly this no longer works; same for .doc files in Word. I've repeatedly tried to reassociate .XLS file extension to the program EXE thru Windows Explorer.Tools > Folder > File Types. The expected behavior is double-click opens the file in the same instance of Excel. What...

Recently changed machine, but still running XP with Office Professional 2003. I've recorded a couple of macros but now whenever i open a file, or try to run the macro in a brand new workbook, it automatically opens the PERSONAL.xls file. I've checked the VB script and there is nothing in...

I've looked through several posts and tried this several different ways, but I still can't get it to work. It keeps telling me that the file (Y5533.PRN) could not be found. Any help would be greatly appreciated. This is the situation: I have a "Main" tab and a "File Locations" tab. The user...

Hi, I am new to macros and having difficulty in creating my 1st macro. I am attempting to open 3 seperate files in the same directory and cut and paste data from them into a new file. The data is on specific tabs within each of the 3 files and I would like the information to be cut and paste...

At work we have about 10 different excel programs that we use regularly, and we're trying to create a control panel program to make things easier for the less technically inclined. The control panel program (currently named "Control Systems.xls" needs to be a shared workbook that has the...