Access talking to Excel (1 Viewer)

[gemma-the-husky]

A couple of things.

a) how do you address a tab with a space in it, in excel from access vba

I tried
sheetassign = chr(39) & "tab name" & chr(39)
Set exSheet = exBook.Worksheets(sheetassign)

currently, I've taken the space out of the tab name, but I just wondered how it should be done.

b) how do you manage comments attached to an excel cell from access vba? (create/append)


many thanks.

 

[GinaWhipp]

Never had a problem with spaces within the name as long as it's enclosed within the quotes. Are you saying you have a space on either side?

 

[JHB]

I think the Chr(39) cause the problem, try the below:

sheetassign = "tab name"
 Set exSheet = exBook.Worksheets(sheetassign)

Else if you get an error, show it.

 

[arnelgp]

on item (b), this might be of help:
https://msdn.microsoft.com/en-us/library/office/ff196533.aspx
http://www.contextures.com/xlcomments03.html