F flaghippo Registered User. Local time Today, 08:08 Joined Jan 22, 2012 Messages 19 Jan 23, 2012 #1 Hi All Im trying to read the value of an excel cell and transfer the value to an Access variable in VBA. Can anyone help ??
Hi All Im trying to read the value of an excel cell and transfer the value to an Access variable in VBA. Can anyone help ??
R Rkay Registered User. Local time Tomorrow, 03:08 Joined Jan 11, 2012 Messages 11 Jan 27, 2012 #2 HI Flag, can you please explain more
V vbaInet AWF VIP Local time Today, 16:08 Joined Jan 22, 2010 Messages 26,328 Jan 27, 2012 #3 Read the file line by line and save it into a variable or Save it as text and use one of the methods you've already been given: http://www.access-programmers.co.uk/forums/showthread.php?t=221009
Read the file line by line and save it into a variable or Save it as text and use one of the methods you've already been given: http://www.access-programmers.co.uk/forums/showthread.php?t=221009
F flaghippo Registered User. Local time Today, 08:08 Joined Jan 22, 2012 Messages 19 Jan 27, 2012 #4 Hi thanks for your reply I have a VBA Sub I need to open an Excel file go to a defined cell read the contents back to a variable in the VBA sub. Hope that makes it clear Flaghippo
Hi thanks for your reply I have a VBA Sub I need to open an Excel file go to a defined cell read the contents back to a variable in the VBA sub. Hope that makes it clear Flaghippo
V vbaInet AWF VIP Local time Today, 16:08 Joined Jan 22, 2010 Messages 26,328 Jan 27, 2012 #5 See what you can do with this: http://www.btabdevelopment.com/ts/tq2xlspecwspath But why can't your users just copy from the cell and paste into Access since it's just one cell?
See what you can do with this: http://www.btabdevelopment.com/ts/tq2xlspecwspath But why can't your users just copy from the cell and paste into Access since it's just one cell?
