Hello:
Please refer to attached file.
I have macro called "Import" (Button1) to import the data from another file.
I need to way to skip some part of the code in "Import" if H=1
Basically :
Please Login or Register to view this content.
Hello:
Please refer to attached file.
I have macro called "Import" (Button1) to import the data from another file.
I need to way to skip some part of the code in "Import" if H=1
Basically :
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
.
Paste in the Sheet Level Module :
Please Login or Register to view this content.
Hello TMS and Logit:
I am very sorry that i have not explained in detail.
Please refer to attached file, Sheet2.
Let me explain exactly what I am doing.
I have stores as shown in row 4, Store1,Store2, etc.
I am using code shown in Sheet2 to import data from Store1, Store2 etc
There is some code WITHIN Closed workwork which i need to avoid if cell H1 = 1 (from attached sheet)when code opens closed workbook.
So Basically, I need to pass the value of cell H1 in closed workbook so that i can put the condition to avoid.
I hope this is clear.
I am very sorry if it is still confusing.
Please let me know if any questions.
Riz
Last edited by rizmomin; 09-22-2017 at 07:30 PM.
.
This is either it or real close to what I believe you are attempting to do :
Please Login or Register to view this content.
Hello:
The CLOSED file which opens has OPEN Event, pleas refer to the error which i get..
My Personal.xlsb file is @ "C:\Users\Riz\AppData\Roaming\Microsoft\Excel\XLSTART" location.
Not sure what is the problem.
Let me know if any questions.
Riz
.
To open another Excel workbook from your active workbook using a reference written to cel A1:
Please Login or Register to view this content.
A B C D 1C:\Users\My\Desktop\Blood sugar levels.xlsx 2 3 4 5
If you want to hardcode the path in the macro itself (as in your example posted) :
Please Login or Register to view this content.
Last edited by Logit; 09-23-2017 at 04:30 PM.
Hello Logit:
Thanks a lot, will try and let you know if any problem.
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks