Computing.Net > Forums > Programming > Excel macro

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel macro

Reply to Message Icon

Name: dhoris
Date: February 2, 2004 at 19:57:58 Pacific
OS: Windows 2000
CPU/Ram: Pentium 4
Comment:

HI,
Having this problem. Does anyone knows how to read latest updated file from excel macro.

eg. File1 reads formula from FM03 and if I add FM04(which is the latest), I want File1 to read the latest formula from FM04. This is all done in Excel macro in VB. Please help. Desperate...




Sponsored Link
Ads by Google

Response Number 1
Name: dtech10
Date: February 5, 2004 at 08:03:40 Pacific
Reply:

Hi
Not quite sure about a couple of things.
is File1 the macro and or FMO3/FMO4 worksheets in the same workbook and is the formula always in the same location in both cases.


0

Response Number 2
Name: gieskebam
Date: February 12, 2004 at 15:06:32 Pacific
Reply:

Want to help, explain your question again.


0

Response Number 3
Name: dhoris
Date: March 8, 2004 at 18:08:31 Pacific
Reply:

the macro is actually in FM03.


0

Response Number 4
Name: dhoris
Date: March 8, 2004 at 18:10:24 Pacific
Reply:

Thanks. My problem is actually how to read a macro from a different spreadsheet. Eg. File1 reads from FM03.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Excel macro

Can I call an Excel macro from cell www.computing.net/answers/programming/can-i-call-an-excel-macro-from-cell/4812.html

Excel Macro www.computing.net/answers/programming/excel-macro/14702.html

Excel Macro protect www.computing.net/answers/programming/excel-macro-protect/14778.html