activate window

Hi team, I have a Macro that runs like a dream on a PC, but on the Mac (which is the computer I use) it does not. I've traced it to the two lines highlighted in red. The macro runs when I remove them, but that means I have to manually close hundreds of files. Is there a workaround or fix for...

Hi Guys, I have a macro-add in where it will attached the files on another already open workbook. However, whenever I run the codes, the files are being attached to the macro add-in and not on the open workbook. I have this section that I think I need to tweak the codes. Otherwise, feel free to...

I need codes to check both MS Word and MS Excel files separately. I don't know if same code will work in both situations. for example files are as follows, >Ticker Graveyard.docx >Ticker Graveyard.xlsx I want to check two conditions for either of files. 1. If the file is open or close 2. If...

Hi. Here is the code I've created: Windows("Banana Republic (99316).xls").Activate Sheets("My Favorite Store").Move After:=Workbooks( _ "My Favorite Store Macro.xlsm").Sheets(1) Sheets("Controls").Select The goal is to be able to manually download the Banana Republic...

I am making a macro that will export data from an excel sheet to a powerpoint presentation to skip repetitive copy and pasting. Some of the data I'm grabbing is of variable size. I want to use the input box to allow the user to select the needed ranges. However, upon opening the powerpoint...

I have a script that makes the user choice which xls file to use. The script saves the file with a unique name by using todays date. That works, it's when I try to use Windows(xxxxxxxxxxx).Activate that I have problems. Here's how I save the file. ActiveWorkbook.SaveAs Filename:= _...

Hi, If I have multiple workbooks open and I want to copy data from only workbook based on the sheet name to another workbook again based on the sheet name, is that possible? The workbook names are variable. For example, if I had 5 workbooks open with file names A,B,C,D,E. In workbook B, there...