Summary: HI, Having this problem. Does anyone knows how to read latest updated file from excel macro. eg. File1 reads formula from FM03 and if I add FM04(whic...
Summary: Hello all, long time since ive posted, need some help from you guys again please. i have made an excel macro, on the excel page you have a drop down m...
Summary: Hello there, ok, i have made an excel macro which when someone selects a option from a drop down menu, output is generated accordingly.. problem is t...
Summary: How can one make Excel macros run without echo. It is so annoying to have all this "flickering" while the macro runs. I also imagine that the macro wo...
Summary: Hi, I need help writing this excel macro, that will look at a piece of data (usually numbers with B,K,M signs) and convert it into thousands. So, ...
Summary: Hi, I was wondering, if i write some code in excel (macro), using a 'UserForm' and modules. Can i then compile this somehow into a dll or similar to u...
Summary: I wrote a macro to transport data from a .dif file (created from running a report) to an .xls file. When I get to the end it asks me if I want to kee...
Summary: Hi Im no expert with Excel, but will this help Just select all the cells and run the macro. Try it on a dummy spreadsheet first, so as not to upset ...
Summary: hello, i am writting a macro in Excel, i have a merged cell C43 and C44, now in my code i want to unlock this merged cell but i get an error, how do i...
Summary: Hey, im writting a macro in excel, i want it to display a number in range A1 in this format 0001 and then some condition will cause it to increment by...
Summary: Hi, I'm not too familiar with creating macros in Excel, the usual "record macro" normally works for me and since I'm sure I won't understand the. unde...
Summary: I don't think a macro in Excel will do the job. What you need is a simple program to iteratively go through the list of numbers and add them until you...
Summary: Hello! I am a mechanical engineer by trade and am working in Excel to manipulate data. I have written macros in the past, but have come to a stumblin...
Summary: I have the VB code below (that runs as a macro in Excel) It separates each sheet and saves each sheet of the workbook by it's tab name as an Excel fil...
Summary: hello, i have an excel spreadsheet on which in column D i have dropdown validation list with Yes/No in it. i need a macro that will check to see which...
Summary: I scanned 500 photos each to its own file (CPhotoCD\0001.jpg to 0500.jpg). I then created a QuattroPro spreadsheet listing the filename (the 0001 to 0...
Summary: Hi, I have to create a macro in Excel which will calculate the average of the value of 5 cells in a column. The problem I have is that a new line is i...
Summary: Hi, I'm trying to write an "AssembleReport" macro, in Excel, that will open a .dot template file - based on the selection of a report "type". There i...
Summary: Hi, i have written a macro in Excel but i do not want the users to be able to view it, is there a way i can prevent people from opening the macro edit...
Summary: I have been using a macro (run within powerpoint) to build a chart report using multiple chart templates. This used to work fine, but now the charts n...
Summary: I'm an engineering intern who has had a couple projects dumped on him. I need to write a macro to take excel data and move it to specific locations in...
Summary: Hi, I have a spreadsheet that is set to refresh/update with external web data every 2 minutes and what I want to do is to store a history of data in a...
Summary: My problem is that I would like to make charts in 'do loop' command but I don't know how to insert do-parameter in sheet series. Exactly how to insert...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
