Summary: Basically, I need to create a way to take schedule data as a CSV, and make room schedules for individule rooms so they can be viewed and printed. So, ...
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: Hello, I have 'written' the following Excel macro. I have a .csv file that I want to import data from. The data within the .csv will change from time-...
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: 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: 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: Thanks for your quick reply, It is linked to Access. I just imported the result of the queries to Excel.I refresh the data manually but how can I reco...
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: 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 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'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: Hi, I want to create a macro in excel which will work as follows: 1. There will be a data file in excel like this Col1 Col2 Col3 Col4 Col5 Col6...
Summary: Hi there, I was just wondering if anyone else has had this problem: We create a CSV file with a whole bunch of stock codes. Many of these stock codes ...
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 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 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: Using Excel 2003 - I do not have any experience writing macros. Tried it on my own and now have a pop-up window everytime I open the excel file, even ...
Summary: We are writing a web application and have around 1500 excel sheets that all have macros that tie them together, we would like to be able to put them o...
Summary: Hello. Grateful for any help with the following task (I'm using Excel 2003). I have 1200+ individual workbooks each containing two worksheets. The w...
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: 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: HI Qbart I went to your side, and yes there are ways of doing this in a macro, or several macros, but this is almost better done in MS Access, a coupl...
![[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
