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 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

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...

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...

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

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,

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).

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...

Mornin Everybody Just a quick question, How do you split worksheets within a workbook all in one click of a macro and then save them as individual file's with the sheet name as the file names? cheers Adam

Hi All I was give some code from Tony Jollans and it works perfect but when I try to put the code into a Command Button I've drawn on to the spreadsheet it doesn't work properly. The original question ws how to open spreadsheets and place a value in column A:A to whatever value I have on my...

Hi I have hundreds of spreadsheets saved but i need to open them and put in 1 copied cell of information then auto fill (I already have column A:A empty. The information to be inserted differs for each spreadsheet but information will always go in cell A1, then auto fill down the list. The...

Hi There I've got a bit of a nightmare, I've been sent in a CSV file thats got way to much data on it for Excel to handle ie it's got about 200,000 rows on it. I've imported it into access ok thts fine BUT I need to transfer this information into Excel to create seperate files for each customer...

Hi there I've got a cloumn with data in it that has duplicate data in it. What I'm trying to do is cut the original data from the duplicates and put them in a list on another spreadsheet. ie cell A1:A10 = 1234 then from cell A11:A:20 = 98765 which means i have column A with 20 rows filled in...

Hi there I'm picking up a database that someone else had control of and they split the table from the forms, queries etc. Now I cant get hold off the old user and need to find the original tables database .mdb I've got access to the Forms Queries etc .mdb file but obviuosly i need the tables...

Hello there and a happy new year to everyone I would like to know how to format all sheets in a workbook the same, For example I've designed a spreadsheet to work for me now and duplicated it to last for a year but say during that year I want to upgrade it. ie new rows, columns, colours, fonts...

When I link a macro to a new toolbar then click on the toolbar ti runs the macro but if I want to undo the procedure I cant. There must be a way because Excel has it's own built in UNDO button.

I've made a combo box with the dates in it but when I select a date it changes it to a different format ie 18-dec-03 = 37973. All help greatly appreciated.

I'm trying to save a spreadsheet with the same name as cell A1. The macro needs to be attached to a toolbar though as constantly using new workbooks.