Solved

Application defined or object defined error

Posted on 2014-09-17
2
92 Views
Last Modified: 2014-09-17
I have some VBA Formula -  

.Range("AO2").Formula = "=[Controls FI.xlsm]Control_Sheet!$K$5"

It picks up a date from K5 the file Controls FI

I am getting "Application defined or object defined error" when it attempts to step through the above line

Can anyone suggest why this is?

Many thanks
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
ID: 40327678
Hi,

issue here is the space in the file name of the excel file from where you are reading the value.

Corrected formula is : .Range("AO2").Formula = "='[Controls FI.xlsm]Control_Sheet'!$K$5"

Notice the
'
 which i added...
0
 

Author Closing Comment

by:Seamus2626
ID: 40327923
Thanks!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now