Answer Questions

• James_Z automating new folder creation within excel

  Hey all, New to this forum and also relatively new to VBA. I apologise if this is a bit long, but I want to make my problem as clear as I can. I’ve created a file tracking system for work with information on customers, projects and who’s working on them etc. What I wish to achieve is to create a macro that will create folders in our shared drive based on the input in a specific row. This will help reduce the time taken on admin. So for a new file entry (e.g. filename; customer; project;…) I would want to create folders for C:\customer\project\filename\ It would need an input box so that the user can input the row or file name that they wish to create the folder for. I will then map this mac ...Show All

• FahimatMicrosoftForum Need direction on using code instead of VLOOKUP

  Hi, all. I've been looking through the forum, and there's a lot of great info here. I'm learning VBA, but I'm running out of time on a project that I'm working on, and would like help if anyone can offer it. I use a spreadsheet that contains a lot of VLOOKUP functions as well is the Excel IF function. Currently I paste two reports into two separate blank worksheet tabs, and the first worksheet uses the VLOOKUP to import the data needed. It's cumbersome and I run into errors once in a while because some yahoo has added a column to one of the reports. I would like to be able to add a macro that searches for a column by header name on a worksheet, then copies the data from that column into a specifed column on another worksheet. Can anyone gi ...Show All

• Honza N Custom Format Data inside a Cell

  I have a column of numbers in the following format: (###) ###-#### and I would like to write a macro that changes the previous format to the following: [fax: (###) ###-###] where the text "[fax:" is added at the beginning and a closing bracket "]" at the end. Could you offer help on creating this macro, or other suggestions on how to fix this in Excel Thank you! If what you specied for the format is a custom format, change it to: "[fax: "(###) ###-####"]" (including all double-quotes) If the non-numeric formating elements are data in the cell use this macro: Sub AddFax() Selection.Value = "[fax: " & Selection.Value & "]" End ...Show All

• Sweed iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this From what I have read it is because of add ons that you have or spyware. One IE add on that I had was yahoo toolbar. I removed it and the problem stopped. Perhaps you have google toolbar or some sort of spyware. Not sure if this is related, but I get a cannot read memory at location 0xXXXXXXX (varies) after I have 8-10 browser pages open, no matter what site I am at. I've learned to live with ...Show All

• BIG S Confused by "Null"

  Hello~ It seems to me that the value NULL has some strange and inconsistent behavior in VBA. I would appreciate if anybody could help me out with the NULL - I guess there is something special about NULL that I haven't realized. Here is a recent example: The codes below is expected to calculate [TwoEstDate] according to the updated value in textbox [Text_OneReturnDate]: if it is null then the [TwoEstDate] is null, otherwise [TwoEstDate] is the 10th Monday after the [Text_OneReturnDate]. To debug, I added a watch for the value of [Text_OneReturnDate]. When I clear the contents in [Text_OneReturnDate], in the watch window, it shows Me!Text_OneReturnDate.Value is Null. So it should be line 1 that is executed. But what actually happened was, th ...Show All

• AdelioStevanato How to get printer names?

  Hello guys, How do I get all the printer names from user machine using VBA-Excel Thank you. Hi, Please refer to my posting at thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=828879&SiteID=1 ...Show All

• softwarejaeger Delete Unwanted rows based on value in cell

  Hi all, I have to loop through a range of rows with an excel sheet and delete unwanted data. To identify the rows to be deleted I have to do the following: Firstly I must start at A1 and check if it contains the value "Product", if not i go to the next row but if it does i must then delete this row and go to the next. I must then check that the next cell contains the value "Total", if not i go to the next row but if it does i must then delete this row and go to the next. I then need to delete each of the next rows until i find the next cell that contains the value "Product", delete this cell and then go through each of the next rows until i find the next cell that contains the value "Total&quo ...Show All

• Indinfer Reversing a lists order in excel for my macro

  Hi there. I have a macro that im building within excel, but am stuck on an excel function. Does anyone know how to reverse the order of a list ini excel. I have a column set up of names. How can i select this list and have it reverse the list in a separate column. I dont want it reversed alphabetically, or numerically... my example would be this... Cell A1 - A5 Paul Barry John Steve Jim i would like to either select the 5 cells and have click a button to reverse this order, or have it return the reversed order in column B1 - B5... giving me the result of Jim Steve John Barry Paul The only way ive seen how to do it is with the offset function but ive had alot of trouble with that for some reason and hoped someone had anot ...Show All

• Muhsin Zahid Uğur How to copy pivot table RESULT from Access to Excel

  I need to produce a highly formated pivot table report in Access and can only achieve so much. However, if I could programatically select the pivot table (equivalent of keys [Ctrl]+ ) then copy and paste into Excel, I can use VBA to format the report in Excel. My problem is that I cannot find a way to programatically select the pivot table in Access. I have tried Sendkeys "^A" as a last resort but this doesn't work. Exporting to Excel doesn't work either as it exports the pivot table, not the result . I'm having a similar problem with a large dataset. I can export smaller result sets, but the query I'm using has over 150,000 rows: too many for Excel. However, the actual pivot table result ...Show All

• Cammyr MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. 1. Go to Control panel – Printer and fax 2. Add Printer – select local printer attached then manual 3. In the port option select Document image printer writer port 4. Install a generic text only printer. 5. Right-click on the generic text/only printer driver and select pro ...Show All

• syhzaidi Recommend a book please

  I am in the very early stages of trying to teach myself VBA for MS Word. I have some knowledge of programming in Java and C++. I need a good book to get me started. I have found it is not the code itself that I am having trouble with, it is how the environment works that has me confused. I need to see how to implement solutions to some basic real world problems. Seeing code examples in isolation is not proving to be of much use, I can work that out. I need to see examples of how you implement the code and incorporate it into documents for use, and then how you use it. For example I need to know the whats, hows and whys of projects, modules, class modules, objects, user forms, references, MS Word objects and templates etc. All these term ...Show All

• AlanKohl Newbie in VBA Drag and Drop..

  Hi, Do not know if this is possible drag and drop effect of items in dropdown control inside a word application The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done Thanks in advanced. den2005 Hi Derek,     database I guess is SQL Server 2005, OS is XP with multi-language support, office 2003 (not sure if sp1 or sp2), ordinary non-programmer will use it, so they will modify the word document and upload it and data modified will be written on the database, first they would e ...Show All

• Dave Dustin Regarding Conditional Formatting.

  Hi All, I am using Excel in my VBA application. Is there a ristriction of using the Conditional Formatting If yes how many conditions I can use in a WorkBook Thanks, Basav Hi Basav, Your limited to 3 conditional formats in a work book using Excel's front screen. If your using VBA then you can program unlimited conditional formats by handling the Workbook_SheetChanged event and putting the logic and formatting in there. Hi Derek, Thank you very much for the reply. It is very helpful for me as of now. Thanks Again, Basav ...Show All

• mihe Can't open regedit

  Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks Thanks for the quick response. I have tried this with no luck. Should i now try deleting the cmd.exe file contained within the System32 folder (i have another cmd.exe in windows\software distribution\download\<a folder name with letters and number>) What will this potentially do, and is there a way to 'reinstall' cmd.exe if it messes things up thanks I was able to find some detailed info about the Windows registry on http://support.micr ...Show All

• arcoant Dynamicaly enter Data in Microsoft Access

  I need to be able to enter data in a form feild dynamically in vba. I allready know the value that I want the feild to have. I just need an example of how to do it. I tried changing the default value in a form but thAT did not seem to work. Wait a minute I need more details.!!!!!!!! Hi Try attaching your code to an event on the form such as the change event on one of the other fields that are keyed and are required Thanks for the answer. What form are you refering to A user form OR a datasheet ...Show All