Double Handling within working code Write to access and fire access macro

Couldn't you do everything in Access, or Excel?

I Believe I could but i would need some support converting the access queries that are running so they would work in Excel.

Ive posted some examples below of the queries in access.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[/CODE]
UPDATE Archive SET Archive.HashTag = (IIf(IsNull([Details]),"#Free",IIf(InStr([Details],"#")>0,IIf(InStr(InStr([Details],"#"),[Details]," ")>0,Mid([Details],InStr([Details],"#"),InStr(InStr([Details],"#"),[Details]," ")-InStr([Details],"#")),Mid([Details],InStr([Details],"#"),999)),IIf(InStr([Details],"Bank Holiday")>0,"#hols",IIf(InStr([Details],"Holiday")>0 Or InStr([Details],"Leave")>0,"#Hols",IIf(InStr([Details],"Training")>0,"#Trng",IIf(InStr([Details],"Routine")>0,"#ROUT",IIf(InStr([Details],"left")>0,"#left",IIf(InStr([Details],"Directed")>0,"",IIf(InStr([Details],"Dutie")>0,"#Other",IIf(InStr([Details],"prep")>0,"#Prep",IIf(InStr([Details],"maint")>0,"#mtce"))))))))))))
WHERE (((Archive.HashTag) Is Null) AND ((Archive.UploadDate)=Date()));

[/CODE]

I don't see why you shouldn't be able to execute those queries just are you are executing these queries.

Please Login or Register  to view this content.

I might even be tempted to try using the query names rather than the SQL.

What would be the problem with running that query from Excel?

There shouldnt be a problem, Ive just been trying this since your last post

What ive done is:

Open the Access DB.
Gone into the Query Design mode and SQL view (Ive posted the SQL below)
Pasted into VB and added .Execute and the Speech marks .

Ive getting errors such as syntax, Doesnt like "*" or any of the other speech marks.

Any ideas?

SQL's Below

Please Login or Register  to view this content.

In the query change the " to '.