Open Files with Macro or switch windows with macro
 

How can I open a file with macros if the date change every day, i try to do
the macro to open the files i need but it give me an error every time the
date change.
Its the same if i open the file and try to go back by window its give in me
an error
Windows(" REPORT 09262009.xls").Activate I just want to the macro reconize
every time its change the date. can some one help me with this problem i have

Open Files with Macro or switch windows with macro
 

How about

Dim todaysDate As String
todaysDate = Format(Now, "mmddyyyy")

Windows(" REPORT " & todaysDate & ".xls").Activate

That will always open the spreadsheet for today. "REPORT 09292009.xls"
today, "REPORT 09302009.xls" tomorrow, and so on.

Does that work for you?

--JP

On Sep 29, 2:41*pm, Noe wrote:
How can I open a file with macros if the date change every day, i try to do
the macro to open the files i need but it give me an error every time the
date change.
Its the same if i open the file and try to go back by window its give in me
an error
Windows(" REPORT 09262009.xls").Activate I just want to the macro reconize
every time its change the date. can some one help me with this problem i have

Open Files with Macro or switch windows with macro
 

Jp this is great, I just have another question can i put with a number how
many dates the formula can go, like if i want the date of yestarday will be
-1
or one day before yestarday -2 something like that.

"JP" wrote:

How about

Dim todaysDate As String
todaysDate = Format(Now, "mmddyyyy")

Windows(" REPORT " & todaysDate & ".xls").Activate

That will always open the spreadsheet for today. "REPORT 09292009.xls"
today, "REPORT 09302009.xls" tomorrow, and so on.

Does that work for you?

--JP

On Sep 29, 2:41 pm, Noe wrote:
How can I open a file with macros if the date change every day, i try to do
the macro to open the files i need but it give me an error every time the
date change.
Its the same if i open the file and try to go back by window its give in me
an error
Windows(" REPORT 09262009.xls").Activate I just want to the macro reconize
every time its change the date. can some one help me with this problem i have

Open Files with Macro or switch windows with macro
 

Windows(" REPORT 09262009.xls").Activate The formula you sent me was only
read from todays date and if i need to open that file 09262009 its give in me
an error.

"Noe" wrote:

Jp this is great, I just have another question can i put with a number how
many dates the formula can go, like if i want the date of yestarday will be
-1
or one day before yestarday -2 something like that.

"JP" wrote:

How about

Dim todaysDate As String
todaysDate = Format(Now, "mmddyyyy")

Windows(" REPORT " & todaysDate & ".xls").Activate

That will always open the spreadsheet for today. "REPORT 09292009.xls"
today, "REPORT 09302009.xls" tomorrow, and so on.

Does that work for you?

--JP

On Sep 29, 2:41 pm, Noe wrote:
How can I open a file with macros if the date change every day, i try to do
the macro to open the files i need but it give me an error every time the
date change.
Its the same if i open the file and try to go back by window its give in me
an error
Windows(" REPORT 09262009.xls").Activate I just want to the macro reconize
every time its change the date. can some one help me with this problem i have

Open Files with Macro or switch windows with macro
 

JP
I did this but its not working but i belive its correct.
Dim yestardate As String
todaysdate = Format((Now) - 3, "mmddyyyy")

Windows(" REPORT " & todaysdate & " .xls").Activate

Noe" wrote:

Windows(" REPORT 09262009.xls").Activate The formula you sent me was only
read from todays date and if i need to open that file 09262009 its give in me
an error.

"Noe" wrote:

Jp this is great, I just have another question can i put with a number how
many dates the formula can go, like if i want the date of yestarday will be
-1
or one day before yestarday -2 something like that.

"JP" wrote:

How about

Dim todaysDate As String
todaysDate = Format(Now, "mmddyyyy")

Windows(" REPORT " & todaysDate & ".xls").Activate

That will always open the spreadsheet for today. "REPORT 09292009.xls"
today, "REPORT 09302009.xls" tomorrow, and so on.

Does that work for you?

--JP

On Sep 29, 2:41 pm, Noe wrote:
How can I open a file with macros if the date change every day, i try to do
the macro to open the files i need but it give me an error every time the
date change.
Its the same if i open the file and try to go back by window its give in me
an error
Windows(" REPORT 09262009.xls").Activate I just want to the macro reconize
every time its change the date. can some one help me with this problem i have

Open Files with Macro or switch windows with macro
 

JP

Thank you so much for your help this is done, Thank you and have a great day.

"Noe" wrote:

Windows(" REPORT 09262009.xls").Activate The formula you sent me was only
read from todays date and if i need to open that file 09262009 its give in me
an error.

"Noe" wrote:

Jp this is great, I just have another question can i put with a number how
many dates the formula can go, like if i want the date of yestarday will be
-1
or one day before yestarday -2 something like that.

"JP" wrote:

How about

Dim todaysDate As String
todaysDate = Format(Now, "mmddyyyy")

Windows(" REPORT " & todaysDate & ".xls").Activate

That will always open the spreadsheet for today. "REPORT 09292009.xls"
today, "REPORT 09302009.xls" tomorrow, and so on.

Does that work for you?

--JP

On Sep 29, 2:41 pm, Noe wrote:
How can I open a file with macros if the date change every day, i try to do
the macro to open the files i need but it give me an error every time the
date change.
Its the same if i open the file and try to go back by window its give in me
an error
Windows(" REPORT 09262009.xls").Activate I just want to the macro reconize
every time its change the date. can some one help me with this problem i have

Open Files with Macro or switch windows with macro
 

Looks like you figured it out, congrats and good luck!

--JP

On Sep 29, 4:08*pm, Noe wrote:
JP

Thank you so much for your help this is done, Thank you and have a great day.



"Noe" wrote:
Windows(" REPORT 09262009.xls").Activate *The formula you sent me was only
read from todays date and if i need to open that file 09262009 its give in me
an error.

"Noe" wrote:

Jp this is great, I just have another question can i put with a number how
many dates the formula can go, like if i want the date of yestarday will be
-1
or one day before yestarday -2 something like that.

"JP" wrote:

How about

Dim todaysDate As String
todaysDate = Format(Now, "mmddyyyy")

Windows(" REPORT " & todaysDate & ".xls").Activate

That will always open the spreadsheet for today. "REPORT 09292009.xls"
today, "REPORT 09302009.xls" tomorrow, and so on.