Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Application defined or object defined error

Posted on 2014-09-17
2
Medium Priority
?
107 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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

916 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