Att. [EMAIL PROTECTED]
Can you please send the files for example?
Regarding the file name change issue you can modify following code to variable
FileName whereever your want.
Sub GetFileName()
Dim FileName As String
Dim Msg As String
FileName = Application.GetOpenFilename
Msg = "You selected: " & vbNewLine & FileName
MsgBox Msg
End Sub
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
--- On Tue, 2/9/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Importing data in one spreadsheet into a certain area
on another spreadsheet
To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com>
Date: Tuesday, 2 September, 2008, 4:39 AM
Hi,
I am trying to create a macro to import data from one spreadsheet into
an area of another spreadsheet. I have formulas in the adjacent cells
to the import area that update with the new data. When I create a
macro and do Import External Data it just pulls in the same file
everytime. The problem is the name of the file changes daily.
I need the macro prompt we me for which file I would like to open
everytime I run the macro, and then continue to run the rest of the
macro.
Thanks for your help.
Unlimited freedom, unlimited storage. Get it now, on
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
