var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Argument passed null
I can't figure out what I am doing wrong on this. In the Load event I have:
My second to last line prints the file path I expect to the immediate window. When I enter the sub ImportExcelFile I get a message that the argument is null.
Dim InboundSpreadsheet As String
InboundSpreadsheet = GetFileLocation()
Debug.Print InboundSpreadsheet & " Inboundspreadsheet"
I go to the debugger and hover over the variable Location and get back "" as the value. I'm sure it is very simple but I can't find it.
Sub ImportExcelFile(Location As String)
Debug.Print Location & " Location"
DoCmd.TransferSpreadsheet acLink, , , Location
Scratch that I'm a dummie.
My debug print statements were not unique enough and I thought the variable was making it out but wasn't. It appears to be due a a next statement I was trying to use.