I am trying to create a macro in order to do a mass find and replace across multiple word documents. I have found this one on the net and altered it to also apply for graphics however I keep getting a run time error (5174) saying that the file could not be found (even though … Read more
I have this macro that is able to do a mass find and replace across multiple word documents. I am able to do a find and replace for pictures (within a header) but when I implemented it within my macro code it seems to just ignore it and not find and replace any pictures. I … Read more
Reference to this discussion about migrating images from URL in excel How can I display a URL as an image in an excel cell? The VBA code looks perfect and working, my question here is that how can i place each migrated image in the adjacent cell with specified size. for example if i have … Read more
So I wrote a macro. The scenario of use is: I open a fresh and new CSV file downloaded from somewhere My macro runs and does some magic with the data Since I don’t want to copy-paste my macro to each one of the new CSV files I found out that I can move this … Read more
I have a problem with file using VBA macros created in GER version of Excel. This macro is testing the pivot table item for “Alle”, but when someone opens the file in EN version, the pivot table item is obviously not “Alle” but “All” so the macro doesn’t work. Same issue is with “leer” – … Read more
I read this question: Can I split a spreadsheet into multiple files based on a column in Excel 2007? I have a question regarding the “Save in same format as original workbook” that I hope you can help me with. I’m using the macro with a CSV file but I want to have the final … Read more
After creating sub procedures, they are not considered part of the macro group. Why? How should a sub procedure be created so it is included in the list of macros? Answer The default place for macro subroutines is in a Module added to the VBA Project for the Book. But they should also be listed … Read more
I am configuring a server using its remote console (which is not SSH, as I haven’t installed the OS yet). Unfortunately after a long series of driver failures I end up repeating typing the following task from Rescue system mount /dev/sda3 /mnt mount /dev/sda1 /mnt/boot/efi mount –bind /dev /mnt/dev mount –bind /proc /mnt/proc mount –bind … Read more
In Row 4 I ask a question and D4 will contain the answer of either Yes or No. If the answer is Yes in D4, I want hidden rows 5 and 5 to appear with follow-up questions. This is working for me: If Range(“D4”).Value = “No” Then Rows(“5:6”).EntireRow.Hidden = True ElseIf Range(“D4”).Value = “Yes” Then … Read more
I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the workbooks are not corrupted but that it is an issue with the individual PCs. I have tried common … Read more
