I have the following code in a userform to delete "Module 2" and it works - sometimes. (I "borrowed" this code from a website, I don't remember which one)
DeleteVBComponent ThisWorkbook, "Module2"
Sub DeleteVBComponent(ByVal wb As Workbook, ByVal CompName As String)
' deletes the vbcomponent...
Hello,
I apologize if this has already been answered, I could not find the answer anywhere.
I have a large database (almost 400,000 records) each with a customer's name, address etc, year & month, and sales. I have found many records with the same zip code but somehow have a different...
I am trying to format a cell as text using a macro.
I have a macro that runs based off a combo (drop-down) box. If a user selects a customer ID number from the combo box, the macro then populates certain locked cells with vlookup formulas that retrieve name and addresses (scenario 1). For...
In MS Office (whether it's Access, Excel, PowerPoint...) when opening or saving a file (using the Save As feature) we can sort by date modified if using the "Details" view. In Office 2003, this is still the case, however now there are groupings (Today, This Week, Last Week, Last Month, etc.)...
Before asking my question, I would like to apologogize if this question has been answered before. I have searched in this and other forums and have not found anything. A few were close, but none really "Hit the spot". Anyway, here goes... Is there a way to pull records based upon...
Whenever I click on a link in Internet Explorer to open a sound file, I get an error message stating: "C:\Pathname\File.mp3" The specified path does not exist. Check path then try again. My problem is I know the path is correct because I tried it on a different computer, not to mention...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.