How do I refer to "this workbook" rather than the file path?

**koska** · 05-09-2018, 07:14 PM

Hi all,

I created a simple macro that works exactly as I want but only when I am in the office. It breaks when I am out of the office.
How do I refer to "this workbook" instead of the file path as highlighted in red below? I am just wanting to refresh and consolidate sources from another sheet.

Forgive me, I am a newbie at these things!

Please Login or Register  to view this content.

**JLGWhiz** · 05-09-2018, 09:02 PM

Please Login or Register  to view this content.

See if this works.

**koska** · 05-09-2018, 09:31 PM

Thanks for your input, I have substituted with the text you offer and I get a "syntax error"

**Leith Ross** · 05-09-2018, 09:39 PM

Hello koska,

Try this...

Please Login or Register  to view this content.

**koska** · 05-09-2018, 11:39 PM

Hi Leith,

What does the code

Please Login or Register  to view this content.

refer to?

**JLGWhiz** · 05-10-2018, 07:32 AM

Originally Posted by koska

Thanks for your input, I have substituted with the text you offer and I get a "syntax error"

Try it like this

Please Login or Register  to view this content.

The leading quote mark and ampersand probably threw the error. BTW, you can remove al those 'ScrollRow' lines. Those are just where you were looking for the next thing to select and have no value to the macro. The recorder just picks up every move you make.

**koska** · 05-10-2018, 09:18 AM

Thanks JLGWhiz

I think there is still something missing between ThisWorkbook.FullName & "By Location'!R4C2:R1000C3" _

as I get an error couldn't not find "correctpathtoworkbook.xlsmBY Location". Is it possible it was moved, rename or deleted?

**xlnitwit** · 05-10-2018, 09:34 AM

You require some apostrophes and square brackets

Please Login or Register  to view this content.

**JLGWhiz** · 05-10-2018, 03:14 PM

Originally Posted by xlnitwit

You require some apostrophes and square brackets

Please Login or Register  to view this content.

Yep, that looks like it should produce the same format that was used in the OP.

**koska** · 05-10-2018, 08:52 PM

Originally Posted by xlnitwit

You require some apostrophes and square brackets

Please Login or Register  to view this content.

Appreciate it, perfect!

**koska** · 05-10-2018, 08:53 PM

Originally Posted by JLGWhiz

Yep, that looks like it should produce the same format that was used in the OP.

Thanks for your efforts!

How do I refer to "this workbook" rather than the file path?

LinkBack

Thread Tools

Rate This Thread

Display

How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

re: How do I refer to "this workbook" rather than the file path?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy from a workbook without using path or file name

[SOLVED] Refer to Excel workbook by path, based on cell value data

Refer Indirectly to File Path

Refer Indirectly to File Path

Macro to save workbook by referencing cell in another workbook for file name and file path

Find last row in closed workbook using file path name

how to set a workbook from a file name and path

Bookmarks

Bookmarks

Posting Permissions