iently”.
> BTW, my name is not D. Is yours S?
>
> From: Sam Mathai Chacko
> Sent: Sunday, September 11, 2011 4:12 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Open file using criteria from input box
>
> D, to be honest, that was certainly not to offend yo
: $$Excel-Macros$$ Open file using criteria from input box
D, to be honest, that was certainly not to offend you. If you felt so, my
sincere apologies. I thought it was strange to have a solution posted when one
was already posted.
Once again, please accept my apologies. You are a valuable
t:* Sunday, September 11, 2011 3:55 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Open file using criteria from input box
>
> Solution already posted D. Could you confirm this was not visible in the
> forum? If so, then I'd like the moderators to please
& InputBox("Vnesi nalog") & ".xlsx"
End Sub
From: Sam Mathai Chacko
Sent: Sunday, September 11, 2011 3:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Open file using criteria from input box
Solution already posted D. Could you confirm this was not
> > On Sun, Sep 11, 2011 at 11:51 PM, dguillett1 wrote:
> > > try
>
> > > Sub OpenFile()
> > > Workbooks.Open Filename:= _
> > > "C:\Users\user\Desktop\2011_" InputBox("Vnesi nalog")&".xlsx"
> > > End Sub
>
>
s not exists!"
> End If
> End Sub
>
>
>
>
>
>
>
>
>
> On Sun, Sep 11, 2011 at 11:51 PM, dguillett1 wrote:
> > try
>
> > Sub OpenFile()
> > Workbooks.Open Filename:= _
> > "C:\Users\user\Desktop\2011_" InputBox("Vnesi
.xlsx"
> End Sub
>
> -----Original Message----- From: Seba
> Sent: Sunday, September 11, 2011 3:31 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Open file using criteria from input box
>
>
> Hi all,
>
> I need help tweaking one of my simple macro
try
Sub OpenFile()
Workbooks.Open Filename:= _
"C:\Users\user\Desktop\2011_" InputBox("Vnesi nalog")&".xlsx"
End Sub
-Original Message-
From: Seba
Sent: Sunday, September 11, 2011 3:31 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Open file
Hi all,
I need help tweaking one of my simple macros. I would like to open a
file after I enter a value into a input box. I have files stored in a
specific folder and each one is named like "year_sequence_number", ie:
2011_001. I need a macro which would open a file based on a value I
enter. For e
