Anybody can help? Urgent....Please help.... thanks!

[imported_unknown]

Hi,

I am a new beginner in visual basic and I need to finish a project on time.

I have been trying to search for information as to how to use macro to open,copy paste and rename files.

The problem that I have for the files is how to set macro to compare the dates on files received (as each file name has different name but same date) and save all the files under one workbook with the name of the workbook set only to that particular date.

Could someone help me on this?

Thanks

Mic

 

[VoG]

Hi!

I think that we all have to finish projects on time...

Perhaps if you posted your code so far it would help us to understand what you are trying to do.

This will take you to the top of the board anyway.

 

[imported_unknown]

hi,

the code that I have using macro recorder as below:

Sub Macro1()
Workbooks.Open
ActiveWorkbook.SaveAs Filename:=" ", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
ActiveWorkbook.Save
Workbooks.Open Filename:=" "
Columns(":").Select
Selection.Copy
Windows(" ").Activate
Columns(":").Select
ActiveSheet.Paste
Windows(" ").Activate
ActiveWindow.Close
Workbooks.Open Filename:=" "
Application.CutCopyMode = False
ActiveWorkbook.Save

Windows("").Activate
ActiveWindow.Close
ActiveWindow.Close
End Sub

I leave the "" blank as I would like to have it checked on the date automatically. How should I:
1. set the program to check date
2. add all the worksheets into one workbook
3. rename the workbook under the same name?

Bearing in mind that the file name is in dates and it changes everyday.

Thanks

 

[imported_unknown]

Maybe I forgot to mention.

I need to copy selected range of cells from worksheets to a workbook. The worksheet I want to copy the whole file, rename it as the worksheet name (it's in date form).

For the subsequent worksheets, I want to copy from the second range onwards, paste to the centralised workbook and save as the same name.

The next day when the date change the same macro will automatically triggers and run the same function.

Can anyone help me with this? Thanks very much for your help! :wink: