2021年12月13日 · As the excel product is already shipped and the VBA is password protected. I do not want to give the password to the users to uncheck the missing reference. It wont work where autocad is not installed. If i could install or put the reference somehow in the client machine, the problem will be solved.

2010年5月19日 · Thanks for the response! I am looking for a solution using Excel VBA, not Visio. I apologize if my post was confusing. Any chance there is a way to check this using Excel VBA? I am also trying to find out if there is a need to ungroup. So I want to do a check that will tell me if there are any shape groups in the worksheet.

2024年3月7日 · One System to rule them all, One Code to find them, One IDE to bring them all, and to the Framework bind them, in the Land of Redmond, where the Windows lie-----People call me crazy because i'm jumping out of perfectly fine airplanes.

2020年10月22日 · Hello: VBA Excel (very old school insanity). I have this very simple line: If (Format(rs.Fields("ShipDate"), "yyyy-mm-dd") > Format(Now(), "yyyy-mm-dd")) = True Then ...

2016年2月2日 · I have a problem with VBA for Excel . I want to search for a specific value(for a specific ID) in a column of a sheet and pass the value in another table row (of that ID). What happens If the value in the What:="value" parameter of the Find() method doesn't exists for all the IDs in the column?

2020年2月27日 · I'm attempting to make a VBA macro to help me clean up part descriptions in a bill of materials. It deletes excess spaces with Trim and shortens several long words. However, I can't seem to figure out how to properly find / replace for a Greek symbol like Omega, or Mu. The ASCII character numbers don't seem to work.

2011年7月1日 · Re: Cannot Find Library (StrConv, UCase, Chr, etc.) I fixed it, and LaVolpe's suggestion seemed to have solved the problem. Quick Navigation Visual Basic 6 and Earlier Top

2011年3月5日 · I have a VBA application to be used in AutoCAD. The application has several data files that must be opened and read by the VBA application. I propose to have users install the files in the folder with the VBA project file. How can I obtain the path to the VBA project executable file?

2008年8月11日 · Find the first empty cell in a row 2. Paste a formula in 3. fill down the same formula for 5 cells in that column 5. start over again for 6 more columns. Excel VBA - Find a vacant cell in a row and then fill down-VBForums

2007年5月8日 · Using Office 2007, but writing code for excel 2003 in work. I am trying to replace any cell with the #N/A error, with a unique number so i will find the first N/A then replace it with 001, then the next would be 002 the problem i am having is when i attempt to find and replace, it isnt allowing me to replace values...