Summary: Hi all, I need help with an excel macro problem. I am creating what I thought was a simple scheduling macro. Basically I need to take batch residence ...
Summary: I'm looking for some help running an excel macro as an automated task. The macro is supposed to create a data connection, import some data from a par...
Summary: Hi, I've got a horrible problem with my Excel macro. When I my macro reads a value from a cell containing e.g. 1.33, he reads 1.38! The type of variab...
Summary: Well see, the CSV is from the university database. It's the info on all the classes for the semester. Currently the university has no was to make post...
Summary: I have a number of tables with different titles, with all the same number of cells in length. If one line of information has to be moved to a differen...
Summary: I am new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 i...
Summary: I have written an excel macro to do some formatting. Can i save the macro on the server and make it available for other users to use it. Thanks ...
Summary: I am attempting to perform a data analysis using data collected through a parallel port. I have a macro written that does not do what it is supposed...
Summary: Excel macro A friend has a spread sheet he receives every week. He has to copy info from that sheet and past it into a new Excel sheet in a different ...
Summary: I have a spreadsheet with a number of column headings. One of the headings has a formula which calculates a number, and I want to create a Macro which...
Summary: This sounds more like a job for a scheduled Windows batch file as opposed to an Excel macro. As per your last post, it sounds like you want to make a ...
Summary: First let me say I am not very familiar with Excel. Your problem is interesting. I did do a little research to create a script that will (for a given...
Summary: I have a 100 different catagories in one collumn and I want an Excel macro to generate a abbreviation for each different catagorie in another collumn ...
Summary: I have an excel programming problem I can't seem to get. I have a spreadsheet with the following cell formula that works fine: =IF(C20="","No Quote",...
Summary: I am having a problem with a macro executing the ActiveSheet.PageSetup function. It works when used in a macro triggered within Excel. However, I am ...
Summary: I have a problem with a Macro i am writing... I will explain what it does to give you an understanding of my problem. First of all it opens two text f...
Summary: I'm working on a Macro, and have 2 problems that I can't solve with my limited knowledge of DBA. 1) Is there anyway to have a macro open all files in ...
Summary: Hello everybody :) Have a strange problem occuring on Excel. There is a macro we use to salt out some datas. It was working fine for a while, and now ...
Summary: I use Excel (various versions) on several different systems (PC & MAC). I believe this problem applies to them all. I need to use the summation sign...
Summary: Hello, I am very new to this and was wondering if anyone knew how to do the following: In my excel Sheet1 I have a button that when clicked I want ...
Summary: Yes it can, you create it like a formula using IF THEN ELSE statements, checking for the current MONTH, not the day. Read up your Excel Help documenta...
Summary: I have an Excel spreadsheet that I need help with a macro. I don't know much about VB scripting but I'm sure there must be a way to do what I want. ...
Summary: I have a very strange problem with my computer, some time ago I started with a problem when trying to use the "/" symbol in excel 2000, quattro pro 7 ...
Summary: There are loads of ways of doing this - you don't need to code the algorithm yourself (but if you want to, then post back and we can sort that out too...
![[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
