Hi, all.
I'm quite new to VBA; I've only written a few macros (by recording, learning the code, and refining).
I am currently working on an Excel project that will allow users on remote systems without intranet access to update files with data from other (closed) worksheets.
I have had this user create a specific folder with a specific path so that she can save all the files there. The original code references this folder on both my system and hers:
Range("E11").Select
ActiveCell.FormulaR1C1 = _
"='C:\FOLDER NAME\[WORKBOOK.xls]WORKSHEET'!R12C5"
When I run this on my system, it works fine. When the user runs this on *her* system, she is asked to update the individual cell with the proper file (which she already has in the folder). This code runs on 266 cells - it is too much, I think, to select the file for *every* cell - in fact, it's why I had her set up the folder in a specific place and why I wrote the macro.
I am very new to this, and new to the forum. I've done a cursory look for a FAQ and through the forums. If a question like this has been answered before, please point me in the direction to go!
Other research-y notes - I Googled for solutions and found code to disable the Update Files Dialog box for *Power Point*. Could my problem be associated with that Dialog box that is thrown up every time the file is opened? I've looked for a spot to disable it, but I don't see where it is.
Thanks in advance for your help!
I'm quite new to VBA; I've only written a few macros (by recording, learning the code, and refining).
I am currently working on an Excel project that will allow users on remote systems without intranet access to update files with data from other (closed) worksheets.
I have had this user create a specific folder with a specific path so that she can save all the files there. The original code references this folder on both my system and hers:
Range("E11").Select
ActiveCell.FormulaR1C1 = _
"='C:\FOLDER NAME\[WORKBOOK.xls]WORKSHEET'!R12C5"
When I run this on my system, it works fine. When the user runs this on *her* system, she is asked to update the individual cell with the proper file (which she already has in the folder). This code runs on 266 cells - it is too much, I think, to select the file for *every* cell - in fact, it's why I had her set up the folder in a specific place and why I wrote the macro.
I am very new to this, and new to the forum. I've done a cursory look for a FAQ and through the forums. If a question like this has been answered before, please point me in the direction to go!
Other research-y notes - I Googled for solutions and found code to disable the Update Files Dialog box for *Power Point*. Could my problem be associated with that Dialog box that is thrown up every time the file is opened? I've looked for a spot to disable it, but I don't see where it is.
Thanks in advance for your help!
