Hey guys,
I'm currently starting a new position at a firm and I'm taking over the previous worker's tasks. She wrote an excel model to automate a few daily tasks but it seems to only work for her user account. I need to make this model work for every user.
So the problem is, she references a .txt file on her desktop, but we don't have access to that. So instead I tweaked the code to reference another common folder. However, it screws up at this line of code:
Selection.QueryTable.Refresh BackgroundQuery:=False
I'm not too sure how the QueryTable works, but I believe that it is because the querytable is referencing her c:\\document settings\desktop, as I see in the "Workbook Connections" option under data. So I would need to have the references to a shared folder... Problem is that she has over 100 connections that are referencing her desktop I think, and each one is referencing a specific portion of the .txt file. Is there any way to change the Workbook Connections and all the references to the current account?
Thanks,
Maxton
I'm currently starting a new position at a firm and I'm taking over the previous worker's tasks. She wrote an excel model to automate a few daily tasks but it seems to only work for her user account. I need to make this model work for every user.
So the problem is, she references a .txt file on her desktop, but we don't have access to that. So instead I tweaked the code to reference another common folder. However, it screws up at this line of code:
Selection.QueryTable.Refresh BackgroundQuery:=False
I'm not too sure how the QueryTable works, but I believe that it is because the querytable is referencing her c:\\document settings\desktop, as I see in the "Workbook Connections" option under data. So I would need to have the references to a shared folder... Problem is that she has over 100 connections that are referencing her desktop I think, and each one is referencing a specific portion of the .txt file. Is there any way to change the Workbook Connections and all the references to the current account?
Thanks,
Maxton
