WO It would be better if you attached your file in which you put the formulas .
Anyway.. did you try indirect() Function to take reference from your data source file? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Tony Wu Sent: 08 May 2012 1:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path? Hello, I have a file which will grab lots data from another file called data-source file, the data-source will change name depends on date and comments, e.g. DS-0507.xls or DS-0507 with comments.xls ..., since the file name is not consistent, I will have to change my formula every time. Therefore, I want to get a macro which will allow a pop-up window to open the data-source file and macro will remember the file name, all the formulas will be re-built based on the file name which means the macro ill update the formula using the new data-source file name. Let me know if it's clear to you. Thanks, Tony On Saturday, May 5, 2012 9:04:18 AM UTC-4, bé trần văn wrote: 2012/5/4 Tony Wu <wumu...@gmail.com> Hello, I have a file needs to import data from another spreadsheet, that sheet will have different file name everyday, I want to a macro to populate a window to open the file and use the full path of the file in further macro, example: ChDir "C:\Users\twu\Documents\Database\Item Master" Workbooks.Open Filename:= _ "C:\Users\twu\Documents\Database\Item Master\Item Master 2012-04-12.xlsx" How can I keep "C:\Users\twu\Documents\Database\Item Master\Item Master 2012-04-12.xlsx" as a string? Thanks, Tony -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com I do not understand, maybe you want to make as Attachments? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
