Search results for query: *

Hi Folks This is just a small problem I hope. I have some code to save a workbook to a specfic location and the name of the file to be saved would be whats in cel A1. My code ChDir "Q:\salesupp\tss_data_in" 'set save path sub folder ActiveWorkbook.SaveAs Worksheets(1).Range("A1").Text the...

Hi again Oops my mistake it works fine any chance of it being able to find a valid end of amonth and delete whats above it as well. If not dont worry. cheers for all your help scottie1

Good Morning Folks Skipvoight No it wouldn't because I have figures adjacent to the dates. Jcrater This is lookin good but it doesn't seem to delete the rows above it. It does find the first of the month. do you know what is missing apart from the obvious. cheers

Hi there I have spreadsheet with dates in column B:B. The problem is I must have full months (example 01/04/2004 to 30/04/2004)in the column. what i want my code to do is find the first month in column B:B with a date that starts 01. then what ever is above it DELETED. is this easy cheers

Hi Folks i have a load of CSV files in my C:\drive but i want to run a macro in excel to change the file formats to XLS. Then put them in a folder called C:\adam

basicaly I just want a little bit of code just to select the first date on a spreadsheet ie 01/01/2003 and highlight down to the last date ie 03/01/2003 then highlight across to the last column, copy it and paste it into a new sheet. There is normally about a whole year to select (366 rows) and...

Hi Folks I've got a spreadsheet with dates in a column (they could be listed in any column). Where ever the dates start and end (rows) I want to be able to select all of the data adjacent to it and copy it into a new work sheet. The dates must run from a beginning of a month to an end of a...

When i try it on a different job it keeps trying to print what the last job was. Say I had to print 50 rows in first job thats fine but if the next job is 40 it will try to print of 50 rows

Morning folks I have a quick question I have a list in column A:A I want to be able to print ONLY it's content with borders round only the contents. The number of rows is different for eack job but I don't want to be printing out 65536 rows. Iwant to be able to put the code on a command...

Spot on

Hi Skipvought I will have a list of file names in a spreadsheet these files will all be saved as .csv files in a folder somewhere on a network drive. What i want to do is some how open these files aoutomatically from my list, save them as .XLS format instead of .CSV files in a new folder.

Hi Guys Is there a way to get a folder which has .CSV files in it, t be opened then saved as .XLS files in another folder. need help. Must be a common question

I dont think I explained it very well, really what I need to do is open up a folder with all the CSV files and be able to save them exactly the same but as XLS file. I dont really want to open them all up individually and go through the moves of saving to XLS.

Hi folks I'm trying to work out how to change the open CSV file to Excel and then save it as the same file name,

Oh yeh Doh that makes life a little easier

Hi There that does the trick cheers i dont suppose we can get it running of a command button and for the info to go in selected cell

Hi Peeps I have a spread sheet and say where column a has a date in it and column b has a date in column c will calculate the number of days between the two dates. Is there any way it can count the number of days not inculding saturdays and sundays

Hello There I've got my macro running and then saving the finished file at the end to a specific folder. I did this by putting the file path within my command button_click. Wahat I would like to do is for the macro to find the file path on the actual spreadsheet ie cells(18, 4).

Cheers Molby That was excellent

Hi All Can anybody tell me how to copy file names from a folder list in windows explorer into an excel spreadsheet all in one go. Thats if there is a way. It's so when I save sheets in a workbook I save them as the name of the worksheet but sometimes people writing sheet names put spaces at the...