Search results

Dear, Is there any way to download multiple files from Google drive when i open my workbook? I found one code from internet to download single file and it works but i can not use this code for multiple files in a single workbook. Regards,

Dear, Many thanks for your support and help. What I understood from your solution you provided and looking at the code; for every new file added in column , I have to press update button to update the list but in code it is clearing the whole sheet and then adding from start. In this way, if i...

Dear, I need to make an excel file which have list of all the files from a specific folder with hyperlink. In addition with an update button, to update whenever a new file is added in that particular folder. Regards,

Dear, Yes u r right? i need the range of date to be copied; it may be 1 day or more. the file which i shared, it is working when i put the code in workbook Open trigger but if i want to run it manually by click button or direct from vb; it gives the error. I hope, its clear. regards,

Dear, I am really sorry for the incontinence caused by me. Lets make it little simple, lets first try to get data only from 1 file. I am attaching the files 1. master file 2. Production. Master file will get data from prduction file based on date difference which may be 1 day or more. I...

Dear, I am trying to write my problem again in details; 1. Master File (Where data has to collected based on dates) 2. Production Sheet (From this sheet data has to collect) 3. R-301 (From this sheet data has to collect) 4. R-302 (From this sheet data has to collect) Details: "Master Sheet"...

Thanks a lot. It was a great help regards,

Hello, I have 2 files. Master & Data BOth sheets have certain data based on daily date. What i need is, When ever i open Master file, it checks last date data filled in master sheet, and fill the data in Master file taking from Data file upto last record. Hope, i will get solution. Files...

Thanks a lot. It helped and solved my issue. is it possible to make a progress bar while refreshing/updating the records? Regards,

Dear, Kindly see the attached file; Summary sheet has collection of certain data from each sheet in the worksheet. 1. When UPDATE button is clicked it updates whole data in the sheet. but i need to only add new record when new sheet is added and not to rewrite the whole data again in summary...

Thanks dear.

Hello, Is it possible to get Google drive path on Local computer by Vb code? If yes, please share code. Regards,

Dear, Many thanks to you for the great help but unfortunately, it will not fulfill my purpose. Actually, i need to extract data dynamically. Excel file on Gdrive has date column and i need to get only that data which is matching with my date on local file. Hope, i explained my problem...

Dear, I have a excel file on my google drive which is shared by my friend. I want to extract data from that file and store in local excel file at my desktop. Kindly guide me how to do that Regrds,