Open & update another file (through macro) while running macro

I am using MS Excel 2003 and I need help to solve my problem.

One excel file (suppose A.xls) in which I’ll update my graph and the data is 
available in another file (suppose B.xls). What I am doing (through macro) is 
that I have created one button (in A.xls) and when I pressed it; its open the 
file B.xls (the data file) and at their I select month from drop down from 
which its update the pivot table based on the selection month and then same I 
was doing with another data excel file (suppose C.xls).

Query :

Is there any solution that when I pressed button from file A.xls its open 
B.xls and I select month from drop down update the Pivot table and its shows 
the message “B.xls has been updated”, then it is open another excel file 
C.xls and same I’ll do and then again its popup the message “C.xls has been 
updated” and came back to my main file A.xls.

I’m sorry if I placed wrong title of my query.

Please suggest.
Thanks in advance.



5/21/2010 12:59:01 PM
excel.programming 6508 articles. 2 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 49

dear nitesh,
 This is very simple do u know Hyperlink Suppose You are work in A
file Please Right click & Hyperlink
Or  Better option is call me my No. is 9637666242 ok
5/22/2010 3:40:54 AM

Similar Artilces:

Auto-update Fill Series in column that has randomly spaced blank c
Hi, I have a worksheet of projects listed by quarter. A cell (say A6) contains QTR 1, followed by cells in column A filled with a series (1,2,3...say up to 12). Then comes a blank row followed by a row containing words "QTR 2" and then the fill series continues from where it left under QTR 1 i.e. 13,14,15...say up to 18. And so on for QTR 3 and QTR 4. When a new project is added, I want to be able to add a row and with minimal steps, want the fill series below this added new project, to update. When I delete a row (project), I want the fill series to automatically ...

Macro to add a connection point to the center of every circle in a dwg
Hello, I'm trying to figure out how to add a connection point that is relative to a shape, such as the center of a circle. I'm used to doing this in Autocad, but not in visio. Can someone show me how to make a macro or know if one already esists that can find all the circle shapes in a drawing, and insert a connection point at the center of each one. (Usiing visio2003) Thanks in advance.. You might try something like this, Al ' this is called by the following routine to add a standard set of ' connections to the rectangles used Public Function funcAddConnectionPointToS...

How do I remove ~WRL0000.tmp files?
Two days ago one of my MS Word folders I was working in started to accumulate a lot of ~WRL1234.tmp files. Usually these disappear after I leave the folder, but today they're still there. How can I delete them? And how can I reset things so they don't start accumulating again? Many Thanks. See -- Regards, Jay Freedman Microsoft Word MVP FAQ: Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Tim wrote: > Two days ago one of my...

Excel 2000 tries to open unrecognizable file on startup
Hi, For the last couple of weeks, when I first open Excel I get a Microsoft Excel Error pop-up window that says "This file is not in a recognizable format....". I am uncertain what file it is trying to open, but when I click "cancel" it opens books1.xls. Which I usually ignore and go into "open file" and pick my excel file. Any idea what is going on? Win98 Excel 2000 -- Thanks - Jeff Jeff I suspect one of two things 1) Excel opens all files in it xlStart folder. Search for this and remove anything without an .xls, xlt extension 2) If you go to Tools&g...

Exchange Crash -- all we have is the ispriv.edb file
Hello all -- A client of mine never did any exchange 2003 backups, but did copy over the ispriv.edb file over to an external USB harddrive. All we want to do is pull the email out of that directory (8GB file) and put it into .pst files. Then, Ill reinstall Exchange, and open each person's mail box and copy the contents of each .PST file back to the server. My question is: If I only have the ISPRIV.EDB file, how do I get mail out of it ? Is there some super cool easy to use tool for this? ;-) Any help appreciated!! Sincerely, Blake

.pst file is maxed out - HELP
Apparently I have reached the maximum size of my outlook.pst file (see attached error message). I have tried deleting items but nothing I do seems to have any effect and I continue to get the attached error message. Therefore the eMail part of Outlook is disabled. Anyone got any pointers? XP Pro SP-2/Outlook 2003. Already using .pst format for database. Thanks, No image attached. Post a link, rather than an attachment. See --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003

combine multiple excel file in to one excel file and multiple worksheet
I am wanting to use the following code to combine worksheets from multiple files. However I would like to be able to select folder which contains files in a more automated way that having to change the code every time, and also copy all worksheets with links and formulas removed. Any help on this is greatly appreciated as I have limited code knowledge. Sub Copy_them() > Dim TargetWkbk As Workbook > Dim mrgWkbk As Workbook > Dim i As Long > Dim Wks As Worksheet > Dim fName As String > Application.ScreenUpdating = False > Set TargetWkbk ...

how i can change default file format Outlook uses to save message
I my saving message in my inbox using "File->Save As" menu. "Save As.." dialog by default shows "Save As Type:" as "HTML". How I can change default file format Outlook uses to save messages to as "Outlook Message Format - Unicode" ?????? Rajkumar <> wrote: > I my saving message in my inbox using "File->Save As" menu. > "Save As.." dialog by default shows "Save As Type:" as "HTML". > How I can change default file format Outlook uses to save messages...

Macro Question
I am familiar with the Macro tool. Where I fall down is when I attempt to have it go to a cell that changes from sheet to sheet. As an example, I want it to highlight all of the cells on a sheet with data and format the font size and color. The first two rows are always in bold, but everything else is not. Each month the data changes so the list varies, thus the problem. My recorder picks up the first and last cell I went to the last time I used it, so I need it to seek the last cell with data (whatever that may be each month) without having to rewrite the macro. Any ideas for a "one-siz...

outlook macro security issue
Hi All, In my Outlook I have set security level Low. Even though I am unable to run macros in my outlook but I am able to run word and excel. When tryied to run a macro I am getting following message. I set secrurity level low using the menu Tools>Macros>security. "The macro in this project are disabled. Please refer to the online help or documentaion of host application to determine how to enable macros." Please help me with the solution. Thanks & Regards Ramesh -- ramserp After changin the security level you need to restart Outl...

Microsoft Office 2003 Updates
I am able to download but not install the following updates - Update for Microsoft Office Outlook 2003 Junk Email Filter (KB975958), Office 2003 Service Pack 3 (SP3), and Update for Office 2003 (KB907417). For each failure I receive the same error code - 0x80070643. I have tried to download the Genuine Microsoft Tool to validate my Office 2003 Software but it won't download. I have tried to use logs to find the specific error but it does not work. Can anyone help me? I am no longer able to open Outlook 2003. -- Thank you. Lucy Description of the update for Office ...

Forwarding e-mail with rules from another e-mail address.
Hi, I have two e-mail accounts. Once I manually forward my mail from the other account to my other e-mail account, I would like Company X's mail to go in the Company X's folder. Any ideas as to how to set up a rule for this? Thanks in advance. Just edit the Rule to add a move action. <> wrote in message > Hi, > > I have two e-mail accounts. > > Once I manually forward my mail from the other account to my other > e-mail account, I would like Company X's mail to go in the C...

Missing file still....
I tried running detect and repair and reinstall. Outlook still looks for file .... Someone please HELP. -Kyle did you have different versions or suites of office installed? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Outlook Tips: Outlook & Exchange Solutions Center: "Kyle" <> wrote in message news:1b9fc01c420fa$8a7ce410$a401280a@phx.gbl... >I tried running detec...

Mpeg Video file
Please help. When I copy and paste an Mpeg movie file / AVI file into my Publisher 2000 system i can then right click and "Change Object", "Media Clip" and "Edit" this allows me to seardch through the video to find the still frame i want and have this then inserted into the document. This works fine on my computer but on my friends computer does not work, the publisher version is the same and the imported video is the same, when he attempts to do the same it comes up with Change package and does not allow him to edit the video at all, I think there must be ...

Another oddball WLM error message
When I left WLM running while I went to breakfast this morning, I got another oddball error message. Just the frame for showing the error message, with all the space inside the frame still transparent. Robert Miles ...

My excel file is too large (5 mb) when it shouldn't be, why?
I have an excel file has ballooned in size for some reason. I have tried to copy all the cells and then used "paste special" to paste just the values and the file size doesn't reduce. I am copying numbers from an investment website into my spreadsheet and there don't appear to be any issues with the pasted cells but I suspect it is causing the file size expansion and very slow performance. I then deleted all the cells around by spreadsheet and it didn't help at all. All suggestions as to how I can fix this problem appreciated. Kenview If you do a Ctl-End, does...

how do i create a macro to export a chart to powerpoint?
Can anyone give me any tips to create a macro to export data to powerpoint. When I try to record the sequence it falls over at the 'copy' stage. Hi, Have you seen Jon's page on the subject? Cheers Andy -- Andy Pope, Microsoft MVP - Excel "NPAT" <> wrote in message > Can anyone give me any tips to create a macro to export data to > powerpoint. > When I try to record the sequence it falls over at ...

Caleder updation
Hi experts, We're installing Win2003+Exchange2003+Outlook2003. We are facing the problem that Exchange does not refresh user's caleder until he/she opens Outlook. Of course we know this is MS's specification. But we are now using web-based e-mail system and its "realtime refreshed" calender. So we have to show users our solution for it. Your any advise or comment is highly appresicated. Which web-based e-mail system are you using? Outlook Web Access? -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "hanchan" &l...

backup file size
I've noticed that my backup file size varies considerably. Sometimes its very close to the origonal file size and sometimes its more than 25% larger. Why? In, jerry wrote: >I've noticed that my backup file size varies >considerably. Sometimes its very close to the origonal >file size and sometimes its more than 25% larger. Why? You probably did not set Tools->Options->MakeMyFileSmall... "jerry" <> wrote in message news:079001c39eb1$491ea150$a401280a@phx.gbl... > I've noticed that m...

how to produce a csv file from a unicode-saved text file
Friends, I have an excel spreadsheet (version 2000) that has Japanese characters. I would like to save it as unicode text file so that I can FTP it to my unix box for loading into an Oracle database. When I save the file as unicode text, it properly preserves the characters, but using whitespace as the delimiters. I would like to change this to a csv, but when I save as the file as CSV, the Japanese characters turn into set of ?? symbols. Is there any way around to create the unicode text file with delimiters other than whitespace? Thanks for any ideas. - Sal ...

Running Totals
Hi, everyody. I have prepard a worksheet that logs electicity meter readings. Against each reading I want the previous added to the current so I can view a running total of the electricity used for the year each week. Example: Column G shows the KWH used for that week. Column H shows the number of KWH used as a running total. This works okay with (H2)+(G3) H2 being the previous week's total. My problem is, when auto inserting the whole year's column the last entry shows all the way to the bottom of the worksheet. Is there a formula I can use so that the part of the column...

Copying decimal data to another column to integer 'on the fly'
Hi, I am working on Asset registers/Depreciation Schedules and at the star of the year I need to convert over my previous years spreadsheets (fo about 40 schools) to the new financial year. This means moving the accumulate depreciation at the end of the previous year to being the 'openin depreciation' for the new year. I therefore want to copy a column of figures to another column an paste to that column as values only BUT as INTEGERS. I am running Excel 2003 - 'Paste Only' can solve the 'values' part bu does not have conversion to an integer 'on the fly'. ...

Can I import a .pdf file into publisher
I tried to copy and paste from InDesign and it did not work. Can you import any type of file into publisher. Example: .pdf or .eps No. Publisher is pretty much a stand all by itself program. If you can't copy and paste into it, you're kind of sorely out of luck. You can put pictures into a Pub file but you can't go back and edit the individual parts of them, such as text. -- JoAnn Paules MVP Microsoft [Publisher] "Graphix grl" <> wrote in message >I tried...

Blocked and safe senders file in Outlook 2003
Hi, I am wondering where outlook 2003 saves the address that you add to the safe sender/recipient and blocked sender list. Outlook XP saved the junk senders in a file called "Junk senders" in C:\Documents and Settings\my_id\Application Data\Microsoft\Outlook I used to backup that file, so I would like to know where Outlook keeps the file now. Thank you The lists are kept in binary values in the Windows registry and also in a hidden item in the mail store (mailbox or PST file). Both lists are kept in one multivalued property although no one has decoded it yet, the bits also s...

Excel macro error msg..
Hi I get the following msgbox when I attempt to run a Macro - which is just a simple text string to be put into a cell. " 'xxx'.xls could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open a file from your list of most recently used files on the file menu, make sure that the file has not been renamed , moved or deleted." (ok) 'xxx.xls' trefers to a file name that was on my disk - but I deleted - I can't find it after a search. All macros when run, exhibit the same thing..... Tried a goog...