Recent content by malaydash

Dear Bob Fitz The world really seems to be a better place to live when people like you are around. I was astonished by the prompt response given by you. In the past also I have raised a few questions in this forum & every time a noble soul like you appeared to help. Hats up to people like you &...

Hi I have a database in which I have number of queries/tables. Some of these queries/tables are related to each other & some of them are totally independent of each other. I am able to make individual report for every queries/tables. What I want is to combine the individual report into one...

Thanks David for the prompt reply I am basically using Excel because I have some data in which I need to compare the values involving different rows which is pretty easy in Excel & quite difficult (at least for me) in Access. Of course I am working on that but for the time being I am relying on...

Can someone help me out of this problem. Is there a way to refresh Excel Sheet from within Access. Thanks & Regards

Thanks JANR I got the immediate window. But can you please suggest what should be the code if I am linking Access Data to Excel File as "Table" & not as "Pivot Table", because when I am running the code it is showing the following error:- Run-time error '1004' Unable to get the PivotTables...

Where is this Immediate window. I am also facing a similar problem. I opened the VBA window but was not sure where to paste the code. Please help.

Thanks for your response But I need to move those files to different computers as I have to distribute it to different users & they are not connected to each other through any network. Hope you understand my problem. Any help please Thanks & Regards

Thanks David for replying. Here I am giving the details of my problem. 1. I have an Access file to keep all the data. This is my master file & it contains multiple number of tables & Queries. All the data resides in this file so you can say this is my master file. 2. Now to do some calculation...

Can someone help me on this as I need to move my files to another PC & stuck with this problem. Please help. Thanks & Regards

Sorry if I am asking too much. But my problem was not solved as I was thinking after applying the suggestion. After applying the above procedure I am able to open & close the excel file but the data in the excel sheet is not being refreshed which was my prime & only requirement. I have set in...

Thanks Mr B I applied your suggestion & the problem was solved partly. My Access file in the new location was refreshed but the Excel file is getting data from the Access file in the original location. Whatever changes I made to the Access file in new location is not reflected in the excel...

Thanks Mr. B for your kind help & patience in handling my problem. I made the changes as suggested by you & it worked fine. Thanks a lot Regards

I use the procedure as described by you but the excel file doesn't open. It is showing a message of "Compile error: User-defined type not defined" & showing the code saved in the module with one line highlighted which I have highlighted in Red under quote. Actually I am not at all conversant...

Thanks Mr B for your reply & link provided. But my problem is I am not conversant with VB & thats why opted to do this using a macro. Can you please help me do this using macro? I want to know how the RunApplication command works in macro. Or else can you please explain where to write the code...

I have an Access & Excel linked files. I have my data in Access & do some calculation in excel. The system works fine till I change the location of both the file. Whenever I shift the files to another location or another computer the linking failed. I have tried to change the path from within...