Click here to Skip to main content
15,887,371 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Data Access Layer, How to get the count, and use the data returned by the first function posted above Pin
Dave Kreskowiak8-Jul-15 9:58
mveDave Kreskowiak8-Jul-15 9:58 
GeneralRe: Data Access Layer, How to get the count, and use the data returned by the first function posted above Pin
jkirkerx8-Jul-15 10:37
professionaljkirkerx8-Jul-15 10:37 
GeneralRe: Data Access Layer, How to get the count, and use the data returned by the first function posted above Pin
Dave Kreskowiak8-Jul-15 11:15
mveDave Kreskowiak8-Jul-15 11:15 
GeneralRe: How to load a single record, and with a join Pin
jkirkerx9-Jul-15 9:08
professionaljkirkerx9-Jul-15 9:08 
GeneralRe: How to load a single record, and with a join Pin
Dave Kreskowiak9-Jul-15 12:08
mveDave Kreskowiak9-Jul-15 12:08 
GeneralRe: How to load a single record, and with a join Pin
jkirkerx9-Jul-15 12:31
professionaljkirkerx9-Jul-15 12:31 
QuestionPrint RDLC without preview using VB.NET Pin
emmapaq6-Jul-15 10:00
emmapaq6-Jul-15 10:00 
QuestionExcel VBA Function runtime error 1004: Application-defined or object-defined error Pin
Member 118122063-Jul-15 11:57
Member 118122063-Jul-15 11:57 
Hello!

I need help please! I have no experience in programming or whatsoever and I have been sent this excel file to execute macros. But somehow it doesn't work and the message Excel VBA Function runtime error 1004: Application-defined or object-defined error message keeps appearing. I don't know what's wrong or how to fix it...

Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True,_
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
:="<", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _
TrailingMinusNumbers:=True

This is the highlighted part. Is there something wrong with the coding? Or is it because the file was created on non-Mac laptop and I am using Mac?

Please help, I would really appreciate it! Thank you!
SuggestionRe: Excel VBA Function runtime error 1004: Application-defined or object-defined error Pin
Richard MacCutchan3-Jul-15 21:28
mveRichard MacCutchan3-Jul-15 21:28 
QuestionPublic Delegate Sub Action(Of T) (obj As T) Pin
Member 1171394230-Jun-15 20:23
Member 1171394230-Jun-15 20:23 
AnswerRe: Public Delegate Sub Action(Of T) (obj As T) Pin
Richard MacCutchan30-Jun-15 21:21
mveRichard MacCutchan30-Jun-15 21:21 
QuestionFirstData G4 V14 HMAC Header Pin
jkirkerx29-Jun-15 13:47
professionaljkirkerx29-Jun-15 13:47 
AnswerRe: FirstData G4 V14 HMAC Header Pin
Jörgen Andersson29-Jun-15 20:17
professionalJörgen Andersson29-Jun-15 20:17 
GeneralRe: FirstData G4 V14 HMAC Header Pin
jkirkerx30-Jun-15 6:49
professionaljkirkerx30-Jun-15 6:49 
GeneralConclusion - XMLWriter, UTF16 and XML empty element short form. Pin
jkirkerx5-Jul-15 8:54
professionaljkirkerx5-Jul-15 8:54 
AnswerRe: FirstData G4 V14 HMAC Header - Issue 1: Pin
jkirkerx30-Jun-15 11:10
professionaljkirkerx30-Jun-15 11:10 
GeneralUpdate - got the calc to work now with the request message Pin
jkirkerx1-Jul-15 7:38
professionaljkirkerx1-Jul-15 7:38 
AnswerCan't get the hashed content right Pin
jkirkerx1-Jul-15 12:39
professionaljkirkerx1-Jul-15 12:39 
QuestionExecute multiple sql queries with one database hit Pin
satc27-Jun-15 19:53
satc27-Jun-15 19:53 
AnswerRe: Execute multiple sql queries with one database hit Pin
Sascha Lefèvre27-Jun-15 22:04
professionalSascha Lefèvre27-Jun-15 22:04 
GeneralRe: Execute multiple sql queries with one database hit Pin
satc27-Jun-15 22:49
satc27-Jun-15 22:49 
GeneralRe: Execute multiple sql queries with one database hit Pin
Sascha Lefèvre27-Jun-15 23:15
professionalSascha Lefèvre27-Jun-15 23:15 
GeneralRe: Execute multiple sql queries with one database hit Pin
satc27-Jun-15 23:28
satc27-Jun-15 23:28 
GeneralRe: Execute multiple sql queries with one database hit Pin
Sascha Lefèvre28-Jun-15 1:11
professionalSascha Lefèvre28-Jun-15 1:11 
GeneralRe: Execute multiple sql queries with one database hit Pin
Dave Kreskowiak28-Jun-15 2:17
mveDave Kreskowiak28-Jun-15 2:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.